System-wide tuning of an Oracle database often requires the retrieval of detailed event-based information from the data dictionary. The query presented in this PDF file joins the v_$session_event view with the v$session and v$bgprocess views to develop a quick portrait of all event waits, categorize
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help