Re: state objects

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" <ORACLE-L_at_fatcity.com> 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.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Wednesday, October 22, 2003 8:59 AM
> To: 'ORACLE-L_at_fatcity.com'
>
>
> 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.
> dwilliams_at_lifetouch.com
>
> -----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: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: kaygopal_at_yahoo.com

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: ListGuru_at_fatcity.com (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).