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

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance Monitoring

Re: Performance Monitoring

From: Jerome Vitalis <vitalismanN0SP4M_at_gmail.com.invalid>
Date: Fri, 05 Oct 2007 13:08:22 +0200
Message-ID: <47061b66$0$8661$79c14f64@nan-newsreader-07.noos.net>


joel garry wrote:
> On Sep 28, 9:53 am, Jerome Vitalis
> <vitalismanN05..._at_gmail.com.invalid> wrote:

>> On Wed, 26 Sep 2007 13:54:08 -0700, joel garry wrote:
>>
>> Well said Joel!
>> But isn't there a typo in number 2?

>
> What might that be? (It's hard to be more specific than what I wrote,
> given parallel and pga and LRU chains and what-all. But if I didn't
> say something correctly, let us know what you think, it may be
> enlightening for everyone.

 > ...

Shouldn't point 2 read as follows?
"[...] For example, if some silly SQL reads an entire table to get a few rows, you wil likely have a lot of unnecessary I/O that *will* fill up the SGA." Received on Fri Oct 05 2007 - 06:08:22 CDT

Original text of this message

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