Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: _ROW_CACHE_BUFFER_SIZE

RE: _ROW_CACHE_BUFFER_SIZE

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Thu, 03 May 2001 07:31:00 -0700
Message-ID: <F001.002F85C3.20010503073541@fatcity.com>

Jared,

Thanks again...

Steve,

Yea, that and views are the way we are heading. What a PITA, though!

|| -----Original Message-----
|| From: Steve Adams [mailto:steve.adams_at_ixora.com.au]
|| Sent: Wednesday, May 02, 2001 5:22 PM
|| To: Jared Still; Multiple recipients of list ORACLE-L
|| Cc: MohanR_at_STARS-SMI.com
|| 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:jkstill_at_cybcon.com]
|| 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. <sigh>  How I despise
|| public synonyms,
|| > developers, and  and  and <sputtering into silence> .
|| >
|| > 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_at_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_at_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_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.com
|| --
|| Author: Jared Still

||   INET: jkstill_at_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_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).
||
Received on Thu May 03 2001 - 09:31:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US