Re: state objects

Hi K Gopalakrishnan ,
Wishing you the same
Thanks I understood what is state objects,but another question arisses,when this
state objects having process status then what this PGA really do and why that process status recorded again in PGA? Please clarify

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, October 24, 2003 8:59 PM

> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sultan Syed
  INET: ssyed_at_fine.ae

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).