Troubleshoot Oracle Event : 'switch logfile command'

Troubleshoot Oracle Event : 'switch logfile command'

When log switch will take more time in oracle database, you may observed oracle event "switch logfile command" which block the session for some time.


-- Basics Checks:
If native disk has I/O issue, you may found the above event also. So, change the 'log_archive_dest' location to high throughput performing I/O disk area and observe the issue again. If issue persists then do the following checks and fix the issue:

-- Check the following parameters :

SQL> show parameter disk_asynch_io;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
disk_asynch_io                       boolean     TRUE

SQL> show parameter filesystemio_options;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options                 string      none


Solution :

'filesystemio_options' parameter value is showing as 'none'. Set this value as 'asynch' in RAC environments and 'SETALL' in non-ASM instances.

This parameter "FILESYSTEMIO_OPTIONS" controls which IO options are used.

"setall" Enables both ASYNC and DIRECT IO, hence can lead to faster writes and therefore better performance.

Sure you don't have said oracle event.
If any doubt, please feel free to post queries/comment/suggestions.