look in sql$text, copy the query over to something else and run a plan on it.
Not sure if that is exactly what you were asking or not...


-----------------------------------------------------------------------
In the 60's people took acid to make the world weird.
Now the world is weird and people take Prozac to make it normal.

Jeremy Birkett mailto:jeremy.[Email Address Removed] Administrator http://www.westfraser.com
West Fraser Mills Ltd.
1250 Brownmiller Rd. Quesnel BC V2J 6P5
(250)992-0866 tel
(250)992-0807 fax


>>> Benny Pei <[Email Address Removed] 01/31/03 10:55AM >>>
Hi,

Does anyonw knows if it is possible to obtain a
queryplan of a running query? I am on o8174.

thanks

benny

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page