query or session level. I had this query in a script on my last project, but forgot to bring it with me. Now I'm having a brain fart and can't figure out the joins. I know its v$sort_usage to some where. I think its a 3 table join. Can anyone give it to me? ---------------------------------------------------------------- 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 -----------------------------------------------------------------