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 ) an
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 '
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 sta
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 S
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"