{9i New Features: V$SQL_PLAN}

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Tue, 07 May 2002 05:48:30 -0800
Message-ID: <F001.00459D3B.20020507054830@fatcity.com>

Welcome to the next installment of 9i new features(and yes when 9iR2 is released, we'll start this series all over again, woohoo)

In the mean time, here is the scoop on v$sql_plan view.

This view provides a way of examining the execution plan for cursors that were recently executed.

The view has about the same info as the output of an explain plan and this is intentional, the big difference is output from an explain is in theory what would happen but this view contains the actual plan as to what happened.

So is this of any use, probably, think about this, you can now see the plan that was executed. This has some really kewl uses for those of us who are still not up to speed in the whole "wait state" tuning concept(which yours truly is included).

This help you see that bad code in the database.

So of the columns in this view, which one are most useful????

Address and hash_value join to v$sqlarea. Address,hash_value and child_number join to v$sql Address and hash_value join to v$sqltext

Most of the rest of the columns are what you'd find in a normal plan table.

There's not much else to say about this v$ view, except if nothing else, I've finally now know which columns to join on on those v$sql* views.

Like always, send hate mail to /dev/null, all others to 9i_at_oracle-dba.com.

Joe

PS: anyone have any special requests that they'd like to know about but don't have the time, let me know.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: JOE TESTA
  INET: JTESTA_at_longaberger.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 07 2002 - 08:48:30 CDT