Blog Aggregator - Amardeep Sidhu

Just a quick note to wish everyone a happy holiday and a great New Year. My next blog entry will be January 8th! We’ll continue our discussion on access path identification.

We continue our discussion on Oracle access paths. In this blog, we’ll learn about the SQL*PLUS Autotrace utility and everyone’s favorite tracing tool SQL Trace. Since there is an abundance of information available, we’ll cover these tools briefly and I’ll provide you with some great links to learn more.

Now that we have a firm understanding of Oracle’s plan table and V$SQL_PLAN, let’s continue our education by learning how to format the raw data contained in these two objects. In addition, we’ll also learn how to create graphical access path displays using the raw data as input.

Recently I invited anyone who has been considering joining the Oracle blogging community to jump right in. Please, help me encourage John H:

Robert,

Way cool blog. I really need to create one too. I like to adhere to best practices and love to read stuff from Tom K. and Steven F.!

I have a question on regular expression check constraints and was wondering if you can help:

alter table

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.