From steve.adams@ixora.com.au Wed, 02 May 2001 14:10:41 -0700 From: "Steve Adams" Date: Wed, 02 May 2001 14:10:41 -0700 Subject: RE: _ROW_CACHE_BUFFER_SIZE Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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:steve.adams@ixora.com.au] > || 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: steve.adams@ixora.com.au > || > || 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: ListGuru@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.com -- Author: Jared Still INET: jkstill@cybcon.com 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: ListGuru@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.com -- Author: Steve Adams INET: steve.adams@ixora.com.au 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: ListGuru@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).