Re: state objects

I understood,Thanks KG

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

> Sultan:
>
> PGA is a private memory area which holds actual memory components
> (like sort area, event settings,parameter settings and UGA). State objects
> are just the data structure which holds the info about the OS resources
> (b)locked by the instance.
>
> In other words, state objects can be called as global and PGA components
> are local to that process (in crude terms.)
>
> KG
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Sunday, October 26, 2003 10:59 AM
>
>
> > 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).
>
> --
> 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).