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.
