Wishing you all a very Happy Diwali.. The festival of lights ! State object is a structure inside the shared pool which keeps the details about every components (for example, process or session or enqueues) and their status (or state). Basically it is an operating system resource related to the oracle instance (or an OS resource held by oracle instance) which has multiple states (free/init and dead I think). The background process PMON is responsible for freeing those resources to the OS should any of the state object dies because of the process failure.
Typically the SYSTEMSTATE dump will have the details about the state objects. Part of this info is visible in the V$sysstat. You will see the state object as SO in the system state dump. Along with you get the owner (holding that SO) and the state of the state object (is that too confusing?) which tells whether that SO is in the freelist or initialized or dead. For better understanding of the various state objects I would recommend to take a systemstate/process state dump and have a look at the trace files. Regards, K Gopalakrishnan Bangalore, INDIA ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 24, 2003 9:29 PM > Does anybody have a definition for the Oracle shared pool component "State > Object"? An Object that holds the state of something? Using Google, I get > some hints, but just wondered if someone has something definite. > > Sultan - your question got my curiosity aroused. I'm sorry I lost your reply > that confirmed you were indeed looking at the SGA. > > > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Wednesday, October 22, 2003 8:59 AM > To: '[EMAIL PROTECTED]' > > > Sultan - Are you referring to the Oracle shared pool components that are > identified as state objects? A quick Google also revealed that Java has > state objects. > > > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Wednesday, October 22, 2003 3:14 AM > To: Multiple recipients of list ORACLE-L > > > Can someone please explain what is 'state objects' in oracle and what is > that real work? > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
