Migration guide, depricated in 9.2, ... http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96530/changes.htm#639263 <quote> Dynamic Performance Views Deprecated in Release 9.2 The following dynamic performance views were deprecated in release 9.2: Deprecated In Favor Of GV$SORT_USAGE GV$TEMPSEG_USAGE V$SORT_USAGE V$TEMPSEG_USAGE </end quote> You are correct on the new one. Regards, Mike Thomas --- ryan.gaffuri@xxxxxxx wrote: > wierd v$sort_usage is not in the data dictionary doc > on otn. ther eis one called v$tempseg_usage which > looks very similiar. > __________________________________ Do you Yahoo!? Yahoo! Movies - Buy advance tickets for 'Shrek 2' http://movies.yahoo.com/showtimes/movie?mid=1808405861 ---------------------------------------------------------------- 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 -----------------------------------------------------------------