Re: V$SQLAREA to determine most disk intensive SQL

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 03 Mar 2004 17:48:04 -0800
Message-ID: <lVv1c.210$BA.133@fed1read03>

gslman wrote:
> srivenu_at_hotmail.com (srivenu) wrote in message news:<1a68177.0403022225.1cf1350c_at_posting.google.com>...
>

>>Viv,
>>I just wanted to note one small thing.
>>Dont concentrate only on SQL's with high Disk Reads.
>>SQL's with high logical reads and low disk reads are equally bad.
>>regards
>>Srivenu

>
>
> Hi Srivenu
> Please elaborate...why this is bad...

LIOs are not free.
LIOs tend to be CPU intensive & should be minimized. Received on Wed Mar 03 2004 - 19:48:04 CST