Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: No one could logon to productio database for a while
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.gifReceived on Tue Oct 03 2006 - 19:40:50 CDT
![]() |
![]() |