Re: Contents of v$SQLArea.....

Correct.

Of course, if you 'nearly' need to do it, you might look at v$sql a few times,
and get some useful information each
time; or write a statement that tracked
from the high-cost sessions to the specific SQL cursors they had open by way of
a correct v$open_cursor.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Paul Brewer" <nothing_at_nowhere.com> wrote in message
news:40c4aede_2_at_mk-nntp-1.news.uk.worldonline.com...


> Sorry,  couldn't resist this:

> To summarise then, if you can afford it you don't need it, but if you need

> it you can't afford it ;-).

>

> Regards,

> Yossarian.

>