Current Database details: - Oracle Database 10g EE 10.2.0.5.0 - Linux x86_64 Error: ORA-02047: cannot join the distributed transaction in progress. WARNING:Could not increase the asynch I/O limit to 480 for SQL direct I/O |
Cause: The user was facing issue with his one of the job which was failed due to below error message. The problem was due to aio-max-size in #cd /proc/sys/fs/aio-max-size on linux server was not set, the default is 128 |
Solution: To ensure ASYNC I/O can be performed by Oracle Database, you need to verify or set the following parameters in the Database: SQL> alter system set disk_asynch_io=true scope=spfile; SQL> alter system set filesystemio_options=setall scope=spfile; Need to shutdown and startup the database and check if the warning reappears. Current: NAME TYPE VALUE ------------------------ ----------- ------- disk_asynch_io boolean FALSE filesystemio_options string NONE New: NAME TYPE VALUE ------------------------ ----------- ------- disk_asynch_io boolean TRUE filesystemio_options string SETALL |
📚 Refer More Popular Posts:
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get future blog updates !
