_ROW_CACHE_BUFFER_SIZE
Performance/Internals Wizards! Anyone ever play with _row_cache_buffer_size? I am having trouble with a crappy application and out of control packages ( too big ) and public synonyms out the ying yang. My 734 instance has DD cache size swells that remind me of "A Perfect Storm", except I bear zero resemblance to George Clooney. It may be a derived parameter ( depending on shpool size, processes, etc) but, if so, I cannot find the root parameter. I would like to apply an init.ora bandaid to the DD cache without having to touch the crApplication yet. Yes, it would be an indirect fix at best, especially given that V$LATCH_MISSES indicates it is the DD "find obj" that is the problem, not the parse. How I despise public synonyms, developers, and and and . If you've played with _row_cache_buffer_size, please let me know. I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively that the space/size is due to Public Synonyms. Any guidance there would be most welcome, as well. Thanks! - Ross p.s. I have set _row_cache_cursors to 200 ( range is 10-3300, default is 10, and yes i know (a) oracle says the default is fine, and (b) using undocumented parameters is bad ) || -Original Message- || From: Steve Adams [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 01, 2001 11:00 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: Oracle What savepoints are active for a given session? || || || Hi Venkata, || || There is no V$ view or X$ table that contains this || information. The only || solution that occurs to me is to dump the savepoints to the || process trace file || with || || alter session set events 'immediate trace name savepoints'; || || and then use UTL_FILE to read and parse the trace file || information. Here is an || example of what you might get: || || SAVEPOINT FOR CURRENT PROCESS || -- ||flag: 0x3 ||name: S3 ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082 ||status: VALID, next: 3822f60 ||name: S2 ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046 ||status: VALID, next: 37f63ec ||name: S1 ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602 ||status: VALID, next: 0 || || This process has three savepoints named S1, S2 and S3 respectively. || || @ Regards, || @ Steve Adams || @ http://www.ixora.com.au/ || @ http://www.christianity.net.au/ || || || -Original Message- || Sent: Tuesday, 1 May 2001 18:20 || To: Multiple recipients of list ORACLE-L || || || HI PLEASE SEND ME ANSWER || Question Title: Oracle What savepoints are active for a || given session? || || Detailed Question: Does anybody know IF and HOW can I get a list of || active savepoints for the current session? I need a native way, not || solutions based on additional application-level || housekeeping. Some query || on the V$ tables/views would be the kind of answer I'm looking for. || Details: Within one stored proc I'd like to obtain a list || (in any form) || of the savepoints issued currently in the current || transaction. Example: || Proc A issues savepoint svA; then proc B issues savepoint || svB; and then || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or || something like that. Of course, there are no intervening commits or || rollbacks. || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Steve Adams || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || 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.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: _ROW_CACHE_BUFFER_SIZE
Ross, Is this OPS? According to Steve Adams ( this is how you make mail show up in his mailbox :) that is for OPS. Sorry, that's all I have to offer. http://www.ixora.com.au/q+a/0008/31163237.htm Jared On Wednesday 02 May 2001 11:01, Mohan, Ross wrote: > Performance/Internals Wizards! > > > Anyone ever play with _row_cache_buffer_size? > > I am having trouble with a crappy application and out of control > packages ( too big ) and public synonyms out the ying yang. > > My 734 instance has DD cache size swells that remind me of > "A Perfect Storm", except I bear zero resemblance to George Clooney. > > It may be a derived parameter ( depending on shpool size, processes, etc) > but, if so, I cannot find the root parameter. > > I would like to apply an init.ora bandaid to the DD cache without having > to touch the crApplication yet. Yes, it would be an indirect fix at best, > especially given that V$LATCH_MISSES indicates it is the DD "find obj" > that is the problem, not the parse. How I despise public synonyms, > developers, and and and . > > If you've played with _row_cache_buffer_size, please let me know. > > I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively > that the space/size is due to Public Synonyms. Any guidance there would > be most welcome, as well. > > Thanks! > > - Ross > > p.s. I have set _row_cache_cursors to 200 ( range is 10-3300, default is > 10, > and yes i know (a) oracle says the default is fine, and (b) using > undocumented > parameters is bad ) > > || -Original Message- > || From: Steve Adams [mailto:[EMAIL PROTECTED]] > || Sent: Tuesday, May 01, 2001 11:00 AM > || To: Multiple recipients of list ORACLE-L > || Subject: RE: Oracle What savepoints are active for a given session? > || > || > || Hi Venkata, > || > || There is no V$ view or X$ table that contains this > || information. The only > || solution that occurs to me is to dump the savepoints to the > || process trace file > || with > || > || alter session set events 'immediate trace name savepoints'; > || > || and then use UTL_FILE to read and parse the trace file > || information. Here is an > || example of what you might get: > || > || SAVEPOINT FOR CURRENT PROCESS > || -- > ||flag: 0x3 > ||name: S3 > ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082 > ||status: VALID, next: 3822f60 > ||name: S2 > ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046 > ||status: VALID, next: 37f63ec > ||name: S1 > ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602 > ||status: VALID, next: 0 > || > || This process has three savepoints named S1, S2 and S3 respectively. > || > || @ Regards, > || @ Steve Adams > || @ http://www.ixora.com.au/ > || @ http://www.christianity.net.au/ > || > || > || -Original Message- > || Sent: Tuesday, 1 May 2001 18:20 > || To: Multiple recipients of list ORACLE-L > || > || > || HI PLEASE SEND ME ANSWER > || Question Title: Oracle What savepoints are active for a > || given session? > || > || Detailed Question: Does anybody know IF and HOW can I get a list of > || active savepoints for the current session? I need a native way, not > || solutions based on additional application-level > || housekeeping. Some query > || on the V$ tables/views would be the kind of answer I'm looking for. > || Details: Within one stored proc I'd like to obtain a list > || (in any form) > || of the savepoints issued currently in the current > || transaction. Example: > || Proc A issues savepoint svA; then proc B issues savepoint > || svB; and then > || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or > || something like that. Of course, there are no intervening commits or > || rollbacks. > || > || -- > || Please see the official ORACLE-L FAQ: http://www.orafaq.com > || -- > || Author: Steve Adams > || INET: [EMAIL PROTECTED] > || > || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > || San Diego, California-- Public Internet access / > || Mailing Lists > || > || 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
RE: _ROW_CACHE_BUFFER_SIZE
Hi All, Yes, '_row_cache_buffer_size' does nothing for single instance Oracle. There is a tip on setting '_row_cache_cursors' at http://www.ixora.com.au/tips/tuning/row_cache_cursors.htm on the Ixora web site. Ross, unless you can get an ALTER SESSION SET CURRENT_SCHEMA statement in there, the best thing for you to do would be to create private synonyms. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Thursday, 3 May 2001 7:26 To: Multiple recipients of list ORACLE-L Ross, Is this OPS? According to Steve Adams ( this is how you make mail show up in his mailbox :) that is for OPS. Sorry, that's all I have to offer. http://www.ixora.com.au/q+a/0008/31163237.htm Jared On Wednesday 02 May 2001 11:01, Mohan, Ross wrote: > Performance/Internals Wizards! > > > Anyone ever play with _row_cache_buffer_size? > > I am having trouble with a crappy application and out of control > packages ( too big ) and public synonyms out the ying yang. > > My 734 instance has DD cache size swells that remind me of > "A Perfect Storm", except I bear zero resemblance to George Clooney. > > It may be a derived parameter ( depending on shpool size, processes, etc) > but, if so, I cannot find the root parameter. > > I would like to apply an init.ora bandaid to the DD cache without having > to touch the crApplication yet. Yes, it would be an indirect fix at best, > especially given that V$LATCH_MISSES indicates it is the DD "find obj" > that is the problem, not the parse. How I despise public synonyms, > developers, and and and . > > If you've played with _row_cache_buffer_size, please let me know. > > I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively > that the space/size is due to Public Synonyms. Any guidance there would > be most welcome, as well. > > Thanks! > > - Ross > > p.s. I have set _row_cache_cursors to 200 ( range is 10-3300, default is > 10, > and yes i know (a) oracle says the default is fine, and (b) using > undocumented > parameters is bad ) > > || -Original Message- > || From: Steve Adams [mailto:[EMAIL PROTECTED]] > || Sent: Tuesday, May 01, 2001 11:00 AM > || To: Multiple recipients of list ORACLE-L > || Subject: RE: Oracle What savepoints are active for a given session? > || > || > || Hi Venkata, > || > || There is no V$ view or X$ table that contains this > || information. The only > || solution that occurs to me is to dump the savepoints to the > || process trace file > || with > || > || alter session set events 'immediate trace name savepoints'; > || > || and then use UTL_FILE to read and parse the trace file > || information. Here is an > || example of what you might get: > || > || SAVEPOINT FOR CURRENT PROCESS > || -- > ||flag: 0x3 > ||name: S3 > ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082 > ||status: VALID, next: 3822f60 > ||name: S2 > ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046 > ||status: VALID, next: 37f63ec > ||name: S1 > ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602 > ||status: VALID, next: 0 > || > || This process has three savepoints named S1, S2 and S3 respectively. > || > || @ Regards, > || @ Steve Adams > || @ http://www.ixora.com.au/ > || @ http://www.christianity.net.au/ > || > || > || -Original Message- > || Sent: Tuesday, 1 May 2001 18:20 > || To: Multiple recipients of list ORACLE-L > || > || > || HI PLEASE SEND ME ANSWER > || Question Title: Oracle What savepoints are active for a > || given session? > || > || Detailed Question: Does anybody know IF and HOW can I get a list of > || active savepoints for the current session? I need a native way, not > || solutions based on additional application-level > || housekeeping. Some query > || on the V$ tables/views would be the kind of answer I'm looking for. > || Details: Within one stored proc I'd like to obtain a list > || (in any form) > || of the savepoints issued currently in the current > || transaction. Example: > || Proc A issues savepoint svA; then proc B issues savepoint > || svB; and then > || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or > || something like that. Of course, there are no intervening commits or > || rollbacks. > || > || -- > || Please see the official ORACLE-L FAQ: http://www.orafaq.com > || -- > || Author: Steve Adams > || INET: [EMAIL PROTECTED] > || > || Fat City Network Services-- (858) 538-5051 F
Re: _ROW_CACHE_BUFFER_SIZE
Thanks Steve. The only useful reference to this parameter is on your web site. :) Jared On Wednesday 02 May 2001 14:22, Steve Adams wrote: > Hi All, > > Yes, '_row_cache_buffer_size' does nothing for single instance Oracle. > > There is a tip on setting '_row_cache_cursors' at > http://www.ixora.com.au/tips/tuning/row_cache_cursors.htm on the Ixora web > site. > > Ross, unless you can get an ALTER SESSION SET CURRENT_SCHEMA statement in > there, the best thing for you to do would be to create private synonyms. > > @ Regards, > @ Steve Adams > @ http://www.ixora.com.au/ > @ http://www.christianity.net.au/ > > > -Original Message- > From: Jared Still [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 3 May 2001 7:26 > To: Multiple recipients of list ORACLE-L > Subject: Re: _ROW_CACHE_BUFFER_SIZE > > > > Ross, > > Is this OPS? > > According to Steve Adams ( this is how you make mail show up > in his mailbox :) that is for OPS. > > Sorry, that's all I have to offer. > > http://www.ixora.com.au/q+a/0008/31163237.htm > > Jared > > On Wednesday 02 May 2001 11:01, Mohan, Ross wrote: > > Performance/Internals Wizards! > > > > > > Anyone ever play with _row_cache_buffer_size? > > > > I am having trouble with a crappy application and out of control > > packages ( too big ) and public synonyms out the ying yang. > > > > My 734 instance has DD cache size swells that remind me of > > "A Perfect Storm", except I bear zero resemblance to George Clooney. > > > > It may be a derived parameter ( depending on shpool size, processes, etc) > > but, if so, I cannot find the root parameter. > > > > I would like to apply an init.ora bandaid to the DD cache without having > > to touch the crApplication yet. Yes, it would be an indirect fix at best, > > especially given that V$LATCH_MISSES indicates it is the DD "find obj" > > that is the problem, not the parse. How I despise public > > synonyms, developers, and and and . > > > > If you've played with _row_cache_buffer_size, please let me know. > > > > I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove > > conclusively that the space/size is due to Public Synonyms. Any guidance > > there would be most welcome, as well. > > > > Thanks! > > > > - Ross > > > > p.s. I have set _row_cache_cursors to 200 ( range is 10-3300, default is > > 10, > > and yes i know (a) oracle says the default is fine, and (b) using > > undocumented > > parameters is bad ) > > > > || -Original Message- > > || From: Steve Adams [mailto:[EMAIL PROTECTED]] > > || Sent: Tuesday, May 01, 2001 11:00 AM > > || To: Multiple recipients of list ORACLE-L > > || Subject: RE: Oracle What savepoints are active for a given session? > > || > > || > > || Hi Venkata, > > || > > || There is no V$ view or X$ table that contains this > > || information. The only > > || solution that occurs to me is to dump the savepoints to the > > || process trace file > > || with > > || > > || alter session set events 'immediate trace name savepoints'; > > || > > || and then use UTL_FILE to read and parse the trace file > > || information. Here is an > > || example of what you might get: > > || > > || SAVEPOINT FOR CURRENT PROCESS > > || -- > > ||flag: 0x3 > > ||name: S3 > > ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082 > > ||status: VALID, next: 3822f60 > > ||name: S2 > > ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046 > > ||status: VALID, next: 37f63ec > > ||name: S1 > > ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602 > > ||status: VALID, next: 0 > > || > > || This process has three savepoints named S1, S2 and S3 respectively. > > || > > || @ Regards, > > || @ Steve Adams > > || @ http://www.ixora.com.au/ > > || @ http://www.christianity.net.au/ > > || > > || > > || -Original Message- > > || Sent: Tuesday, 1 May 2001 18:20 > > || To: Multiple recipients of list ORACLE-L > > || > > || > > || HI PLEASE SEND ME ANSWER > > || Question Title: Oracle What savepoints are active for a > > || given session? > > || > > || Detailed Question: Does anybody know IF and HOW can I get a list of > > || active savepoints for the current session? I need a native way,
Re: _ROW_CACHE_BUFFER_SIZE
Ross, So just how big *is* your DD cache? Jared On Wednesday 02 May 2001 11:01, you wrote: > Performance/Internals Wizards! > > > Anyone ever play with _row_cache_buffer_size? > > I am having trouble with a crappy application and out of control > packages ( too big ) and public synonyms out the ying yang. > > My 734 instance has DD cache size swells that remind me of > "A Perfect Storm", except I bear zero resemblance to George Clooney. > > It may be a derived parameter ( depending on shpool size, processes, etc) > but, if so, I cannot find the root parameter. > > I would like to apply an init.ora bandaid to the DD cache without having > to touch the crApplication yet. Yes, it would be an indirect fix at best, > especially given that V$LATCH_MISSES indicates it is the DD "find obj" > that is the problem, not the parse. How I despise public synonyms, > developers, and and and . > > If you've played with _row_cache_buffer_size, please let me know. > > I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively > that the space/size is due to Public Synonyms. Any guidance there would > be most welcome, as well. > > Thanks! > > - Ross > > p.s. I have set _row_cache_cursors to 200 ( range is 10-3300, default is > 10, > and yes i know (a) oracle says the default is fine, and (b) using > undocumented > parameters is bad ) > > || -Original Message- > || From: Steve Adams [mailto:[EMAIL PROTECTED]] > || Sent: Tuesday, May 01, 2001 11:00 AM > || To: Multiple recipients of list ORACLE-L > || Subject: RE: Oracle What savepoints are active for a given session? > || > || > || Hi Venkata, > || > || There is no V$ view or X$ table that contains this > || information. The only > || solution that occurs to me is to dump the savepoints to the > || process trace file > || with > || > || alter session set events 'immediate trace name savepoints'; > || > || and then use UTL_FILE to read and parse the trace file > || information. Here is an > || example of what you might get: > || > || SAVEPOINT FOR CURRENT PROCESS > || -- > ||flag: 0x3 > ||name: S3 > ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082 > ||status: VALID, next: 3822f60 > ||name: S2 > ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046 > ||status: VALID, next: 37f63ec > ||name: S1 > ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602 > ||status: VALID, next: 0 > || > || This process has three savepoints named S1, S2 and S3 respectively. > || > || @ Regards, > || @ Steve Adams > || @ http://www.ixora.com.au/ > || @ http://www.christianity.net.au/ > || > || > || -Original Message- > || Sent: Tuesday, 1 May 2001 18:20 > || To: Multiple recipients of list ORACLE-L > || > || > || HI PLEASE SEND ME ANSWER > || Question Title: Oracle What savepoints are active for a > || given session? > || > || Detailed Question: Does anybody know IF and HOW can I get a list of > || active savepoints for the current session? I need a native way, not > || solutions based on additional application-level > || housekeeping. Some query > || on the V$ tables/views would be the kind of answer I'm looking for. > || Details: Within one stored proc I'd like to obtain a list > || (in any form) > || of the savepoints issued currently in the current > || transaction. Example: > || Proc A issues savepoint svA; then proc B issues savepoint > || svB; and then > || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or > || something like that. Of course, there are no intervening commits or > || rollbacks. > || > || -- > || Please see the official ORACLE-L FAQ: http://www.orafaq.com > || -- > || Author: Steve Adams > || INET: [EMAIL PROTECTED] > || > || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > || San Diego, California-- Public Internet access / > || Mailing Lists > || > || 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.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San
RE: _ROW_CACHE_BUFFER_SIZE
Title: RE: _ROW_CACHE_BUFFER_SIZE Man o man do i not like to disagree w/Steve-a-rino, Oracle Demigod, and I may be misinterpreting his brief Q&A session, but I think the parameter has more general applicability than solely to OPS. Having said that, properly setting it will enhance *any* instance, including OPS instances. I think I am barking up the wrong tree in any case, b/c my DD hit ratio usually lies above 99%, but it's the *size* of the cache that becomes astronomical, and then (if the instance decides to remain healthy) drops like a wavefront in front of George Clooney's fishing boat. Essentially, public syns and crappy package design is making me take square poops, and I see no way out, because as all DBAs know (sing along with me, now) "There's no way to fix the crApplication.") . Thanks for the info, Jaredevery little bit helps... Ross || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 02, 2001 4:26 PM || To: [EMAIL PROTECTED]; Mohan, Ross || Subject: Re: _ROW_CACHE_BUFFER_SIZE || || || || Ross, || || Is this OPS? || || According to Steve Adams ( this is how you make mail show up || in his mailbox :) that is for OPS. || || Sorry, that's all I have to offer. || || http://www.ixora.com.au/q+a/0008/31163237.htm || || Jared || || On Wednesday 02 May 2001 11:01, Mohan, Ross wrote: || > Performance/Internals Wizards! || > || > || > Anyone ever play with _row_cache_buffer_size? || > || > I am having trouble with a crappy application and out of control || > packages ( too big ) and public synonyms out the ying yang. || > || > My 734 instance has DD cache size swells that remind me of || > "A Perfect Storm", except I bear zero resemblance to || George Clooney. || > || > It may be a derived parameter ( depending on shpool size, || processes, etc) || > but, if so, I cannot find the root parameter. || > || > I would like to apply an init.ora bandaid to the DD cache || without having || > to touch the crApplication yet. Yes, it would be an || indirect fix at best, || > especially given that V$LATCH_MISSES indicates it is the || DD "find obj" || > that is the problem, not the parse. How I despise || public synonyms, || > developers, and and and . || > || > If you've played with _row_cache_buffer_size, please let me know. || > || > I have done a ROW_CACHE dump via ORADEBUG, but I cannot || prove conclusively || > that the space/size is due to Public Synonyms. Any || guidance there would || > be most welcome, as well. || > || > Thanks! || > || > - Ross || > || > p.s. I have set _row_cache_cursors to 200 ( range is || 10-3300, default is || > 10, || > and yes i know (a) oracle says the default is fine, and (b) using || > undocumented || > parameters is bad ) || > || > || -Original Message- || > || From: Steve Adams [mailto:[EMAIL PROTECTED]] || > || Sent: Tuesday, May 01, 2001 11:00 AM || > || To: Multiple recipients of list ORACLE-L || > || Subject: RE: Oracle What savepoints are active for a || given session? || > || || > || || > || Hi Venkata, || > || || > || There is no V$ view or X$ table that contains this || > || information. The only || > || solution that occurs to me is to dump the savepoints to the || > || process trace file || > || with || > || || > || alter session set events 'immediate trace name savepoints'; || > || || > || and then use UTL_FILE to read and parse the trace file || > || information. Here is an || > || example of what you might get: || > || || > || SAVEPOINT FOR CURRENT PROCESS || > || -- || > || flag: 0x3 || > || name: S3 || > || dba: 0x831408, sequence #: 964, record #: 12, || savepoint #: 19082 || > || status: VALID, next: 3822f60 || > || name: S2 || > || dba: 0x831408, sequence #: 964, record #: 11, || savepoint #: 19046 || > || status: VALID, next: 37f63ec || > || name: S1 || > || dba: 0x831408, sequence #: 964, record #: 10, || savepoint #: 18602 || > || status: VALID, next: 0 || > || || > || This process has three savepoints named S1, S2 and S3 || respectively. || > || || > || @ Regards, || > || @ Steve Adams || > || @ http://www.ixora.com.au/ || > || @ http://www.christianity.net.au/ || > || || > || || > || -Original Message- || > || Sent: Tuesday, 1 May 2001 18:20 || > || To: Multiple recipients of list ORACLE-L || > || || > || || > || HI PLEASE SEND ME ANSWER || > || Question Title: Oracle What savepoints are active for a || > || given session? || > || || > || Detailed Question: Does anybody know IF and HOW can I || get a list of || > || active savepoints
RE: _ROW_CACHE_BUFFER_SIZE
Title: RE: _ROW_CACHE_BUFFER_SIZE Jared, Thanks again... Steve, Yea, that and views are the way we are heading. What a PITA, though! - Ross || -Original Message- || From: Steve Adams [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 02, 2001 5:22 PM || To: Jared Still; Multiple recipients of list ORACLE-L || Cc: [EMAIL PROTECTED] || Subject: RE: _ROW_CACHE_BUFFER_SIZE || || || Hi All, || || Yes, '_row_cache_buffer_size' does nothing for single || instance Oracle. || || There is a tip on setting '_row_cache_cursors' at || http://www.ixora.com.au/tips/tuning/row_cache_cursors.htm on || the Ixora web site. || || Ross, unless you can get an ALTER SESSION SET CURRENT_SCHEMA || statement in there, || the best thing for you to do would be to create private synonyms. || || @ Regards, || @ Steve Adams || @ http://www.ixora.com.au/ || @ http://www.christianity.net.au/ || || || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Thursday, 3 May 2001 7:26 || To: Multiple recipients of list ORACLE-L || Subject: Re: _ROW_CACHE_BUFFER_SIZE || || || || Ross, || || Is this OPS? || || According to Steve Adams ( this is how you make mail show up || in his mailbox :) that is for OPS. || || Sorry, that's all I have to offer. || || http://www.ixora.com.au/q+a/0008/31163237.htm || || Jared || || On Wednesday 02 May 2001 11:01, Mohan, Ross wrote: || > Performance/Internals Wizards! || > || > || > Anyone ever play with _row_cache_buffer_size? || > || > I am having trouble with a crappy application and out of control || > packages ( too big ) and public synonyms out the ying yang. || > || > My 734 instance has DD cache size swells that remind me of || > "A Perfect Storm", except I bear zero resemblance to || George Clooney. || > || > It may be a derived parameter ( depending on shpool size, || processes, etc) || > but, if so, I cannot find the root parameter. || > || > I would like to apply an init.ora bandaid to the DD cache || without having || > to touch the crApplication yet. Yes, it would be an || indirect fix at best, || > especially given that V$LATCH_MISSES indicates it is the || DD "find obj" || > that is the problem, not the parse. How I despise || public synonyms, || > developers, and and and . || > || > If you've played with _row_cache_buffer_size, please let me know. || > || > I have done a ROW_CACHE dump via ORADEBUG, but I cannot || prove conclusively || > that the space/size is due to Public Synonyms. Any || guidance there would || > be most welcome, as well. || > || > Thanks! || > || > - Ross || > || > p.s. I have set _row_cache_cursors to 200 ( range is || 10-3300, default is || > 10, || > and yes i know (a) oracle says the default is fine, and (b) using || > undocumented || > parameters is bad ) || > || > || -Original Message- || > || From: Steve Adams [mailto:[EMAIL PROTECTED]] || > || Sent: Tuesday, May 01, 2001 11:00 AM || > || To: Multiple recipients of list ORACLE-L || > || Subject: RE: Oracle What savepoints are active for a || given session? || > || || > || || > || Hi Venkata, || > || || > || There is no V$ view or X$ table that contains this || > || information. The only || > || solution that occurs to me is to dump the savepoints to the || > || process trace file || > || with || > || || > || alter session set events 'immediate trace name savepoints'; || > || || > || and then use UTL_FILE to read and parse the trace file || > || information. Here is an || > || example of what you might get: || > || || > || SAVEPOINT FOR CURRENT PROCESS || > || -- || > || flag: 0x3 || > || name: S3 || > || dba: 0x831408, sequence #: 964, record #: 12, || savepoint #: 19082 || > || status: VALID, next: 3822f60 || > || name: S2 || > || dba: 0x831408, sequence #: 964, record #: 11, || savepoint #: 19046 || > || status: VALID, next: 37f63ec || > || name: S1 || > || dba: 0x831408, sequence #: 964, record #: 10, || savepoint #: 18602 || > || status: VALID, next: 0 || > || || > || This process has three savepoints named S1, S2 and S3 || respectively. || > || || > || @ Regards, || > || @ Steve Adams || > || @ http://www.ixora.com.au/ || > || @ http://www.christianity.net.au/ || > || || > || || > || -Original Message- || > || Sent: Tuesday, 1 May 2001 18:20 || > || To: Multiple recipients of list ORACLE-L || > || || > || || > || HI PLEASE SEND ME ANSWER || > || Question Title: Oracle What savepoints are active for a || > || given session? || > || || > || Detailed Question: Does anybody know IF and HOW can I || get
RE: _ROW_CACHE_BUFFER_SIZE
Title: RE: _ROW_CACHE_BUFFER_SIZE In a 800 MB shpool the DD gets to 250 MB or so before all hell breaks loose. When it starts up, it's around 5 MB. || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 02, 2001 8:05 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: _ROW_CACHE_BUFFER_SIZE || || || || Ross, || || So just how big *is* your DD cache? || || Jared || || On Wednesday 02 May 2001 11:01, you wrote: || > Performance/Internals Wizards! || > || > || > Anyone ever play with _row_cache_buffer_size? || > || > I am having trouble with a crappy application and out of control || > packages ( too big ) and public synonyms out the ying yang. || > || > My 734 instance has DD cache size swells that remind me of || > "A Perfect Storm", except I bear zero resemblance to || George Clooney. || > || > It may be a derived parameter ( depending on shpool size, || processes, etc) || > but, if so, I cannot find the root parameter. || > || > I would like to apply an init.ora bandaid to the DD cache || without having || > to touch the crApplication yet. Yes, it would be an || indirect fix at best, || > especially given that V$LATCH_MISSES indicates it is the || DD "find obj" || > that is the problem, not the parse. How I despise || public synonyms, || > developers, and and and . || > || > If you've played with _row_cache_buffer_size, please let me know. || > || > I have done a ROW_CACHE dump via ORADEBUG, but I cannot || prove conclusively || > that the space/size is due to Public Synonyms. Any || guidance there would || > be most welcome, as well. || > || > Thanks! || > || > - Ross || > || > p.s. I have set _row_cache_cursors to 200 ( range is || 10-3300, default is || > 10, || > and yes i know (a) oracle says the default is fine, and (b) using || > undocumented || > parameters is bad ) || > || > || -Original Message- || > || From: Steve Adams [mailto:[EMAIL PROTECTED]] || > || Sent: Tuesday, May 01, 2001 11:00 AM || > || To: Multiple recipients of list ORACLE-L || > || Subject: RE: Oracle What savepoints are active for a || given session? || > || || > || || > || Hi Venkata, || > || || > || There is no V$ view or X$ table that contains this || > || information. The only || > || solution that occurs to me is to dump the savepoints to the || > || process trace file || > || with || > || || > || alter session set events 'immediate trace name savepoints'; || > || || > || and then use UTL_FILE to read and parse the trace file || > || information. Here is an || > || example of what you might get: || > || || > || SAVEPOINT FOR CURRENT PROCESS || > || -- || > || flag: 0x3 || > || name: S3 || > || dba: 0x831408, sequence #: 964, record #: 12, || savepoint #: 19082 || > || status: VALID, next: 3822f60 || > || name: S2 || > || dba: 0x831408, sequence #: 964, record #: 11, || savepoint #: 19046 || > || status: VALID, next: 37f63ec || > || name: S1 || > || dba: 0x831408, sequence #: 964, record #: 10, || savepoint #: 18602 || > || status: VALID, next: 0 || > || || > || This process has three savepoints named S1, S2 and S3 || respectively. || > || || > || @ Regards, || > || @ Steve Adams || > || @ http://www.ixora.com.au/ || > || @ http://www.christianity.net.au/ || > || || > || || > || -Original Message- || > || Sent: Tuesday, 1 May 2001 18:20 || > || To: Multiple recipients of list ORACLE-L || > || || > || || > || HI PLEASE SEND ME ANSWER || > || Question Title: Oracle What savepoints are active for a || > || given session? || > || || > || Detailed Question: Does anybody know IF and HOW can I || get a list of || > || active savepoints for the current session? I need a || native way, not || > || solutions based on additional application-level || > || housekeeping. Some query || > || on the V$ tables/views would be the kind of answer I'm || looking for. || > || Details: Within one stored proc I'd like to obtain a list || > || (in any form) || > || of the savepoints issued currently in the current || > || transaction. Example: || > || Proc A issues savepoint svA; then proc B issues savepoint || > || svB; and then || > || proc C builds and uses a cursor having 'svA' and 'svB' || as rows, or || > || something like that. Of course, there are no || intervening commits or || > || rollbacks. || > || || > || -- || > || Please see the official ORACLE-L FAQ: http://www.orafaq.com || > || -- || > || Author: Steve Adams || > || INET: [EMAIL PROTECTED] || > || || >