Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: No one could logon to productio database for a while

Re: No one could logon to productio database for a while

From: joel garry <joel-garry_at_home.com>
Date: 3 Oct 2006 17:40:50 -0700
Message-ID: <1159922450.071917.185840@m7g2000cwm.googlegroups.com>

dbaplusplus_at_hotmail.com wrote:
> Description
> This script displays the SQL and the SQL execution plan that is in the
> librarycache. This script does not work on 9.0 because the view
> v$sql_plan_statistics_all does not exits. This part can be removed and
> than the script works also on 9.0.
>

I am not a lawyer, but you might want to look about on metalink for their terms of service. Probably not a good idea to cut and paste to the public from there.

"v$sql_plan_statiscs_all does not exits."

Self-fulfilling prophecy? :-)

jg

--
@home.com is bogus.
http://nickjr.co.uk/global/media/images/medium_blue.gif
Received on Tue Oct 03 2006 - 19:40:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US