04 Dec
System Triage V - Access Path Identification Part II
We continue our series on system triage by learning how to find the access paths our poorly performing queries are taking during execution. In this blog, we’ll review the two data objects that contain the access path raw data - plan_table and v$sql_plan. In addition will review a few of the V$ dynamic performance views that provide information pertaining to SQL statements executing in our Oracle database environment.