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. <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).