>You're observation about v$sqlarea is correct. >However, that wasn't the view I mentioned: > > >You can also play around with v$sql_workarea to get some idea > >The view v$sql_workarea is a simple list of the >cost and size of sort, hash, etc. operations that >have been carried out recently. Ooops! My mistake - reading v$sql_workarea as v$sqlarea :( Thanks again Jonathan, John ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------