ADDM Recommended Actions

• Investigate the possibility of improving the performance of I/O to the online redo log files
• Investigate the cause for high "LGWR wait on LNS" waits
• Investigate the cause for high "LGWR-LNS wait on channel" waits
• Investigate application logic for possible reduction in the number of COMMIT operations by increasing the size of transactions
• Consider not using compression option for RMAN jobs
• Investigate SQL queries for possible performance improvements
• Run SQL Tuning Advisor on the SELECT statement
• Look at the "Top SQL Statements" finding for SQL statements consuming significant I/O on this segment
• Trace cause of row contention
• Investigate the cause for high "SQL*Net more data to client" waits
• Run segment advisor on table
• Run "Segment Advisor" on TABLE PARTITION
• Investigate the cause for high "Disk file operations I/O" waits
• Investigate application logic involving I/O on table
• Investigate application logic for possible use of bind variables instead of literals
• Increase memory allocated to the instance by setting the parameter "memory_target"
• Increase the size of the PGA by setting the value of parameter "pga_aggregate_target"
• Increase the size of the SGA by setting the parameter "sga_target"
• Investigate application logic to keep open the frequently used cursors
• Consider increasing the session cursor cache size by increasing the value of parameter "session_cached_cursors"
• Investigate processes that do not belong to this instance running on the host that are consuming significant amount of virtual memory
• Consider adding more physical memory to the host.
• Tune the entry point PL/SQL
• Investigate the cause for high "SQL*Net message from dblink" waits
• Investigate application logic for possible reduction of connect and disconnect calls
• Investigate the cause for latch contention using the given blocking sessions or modules
• Consider using Oracle Database Resource Manager to prioritize the workload from various consumer groups
• Consider increasing the throughput of the I/O subsystem
• Stripe all data file using the SAME methodology
• Increase the number of disks for better performance
• Consider using Oracle's Automatic Storage Management solution
• Investigate application logic to eliminate parse errors
• Consider increasing the MTTR setting by increasing the value of parameter "fast_start_mttr_target"
• Investigate the cause for high "flashback log file sync" waits
• Increase the size of the redo log buffer by setting the value of parameter "log_buffer"
• Verify whether incremental shipping was used for standby databases
• Investigate the cause for high "Disk file Mirror Read" waits.
• Investigate the cause for high "virtual circuit wait" waits in Service "SYS$USERS"
• Consider partitioning the INDEX
• Investigate application or look at top SQL to find hot sequences
• Use a larger cache size for those sequences
• Try avoiding the use of the ORDER setting if running RAC