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: Mul
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
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
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 th
; @ 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_
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
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!
>
>