Tx. I thought of that too but the problem is I would
have to come up with the number and such for the bind
variables. I wish there is a way to obtain the plan
while a query is running.

sorry I am just being lazy. :-)

--- Jeremy Birkett <Jeremy.[Email Address Removed] 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] Database 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] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit 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
>


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