Hi Syed, You are right. The V$SGASTAT entry would be better named "miscellaneous state objects". @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all -----Original Message----- From: Sultan Syed Sent: Tuesday, 16 March 2004 7:22 PM To: oracle-l@xxxxxxxxxxxxx Subject: State objects Hi list, In v$sgastst ,I could see the state objects as seperate row. I thougt process ,session ... are the state objects . It seems like (process,session...) and state objects are different structures. Please clarify Thanks in advance. Syed ---------------------------------------------------------------- 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 -----------------------------------------------------------------