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