I understood,Thanks KG ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > 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" <[EMAIL PROTECTED]> > > 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" <[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). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Sultan Syed > > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sultan Syed 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).
