Re: v$sql 'db block changes'

From: stephen booth <stephenbooth.uk_at_gmail.com>
Date: Thu, 15 Dec 2005 19:51:38 +0000
Message-ID: <687bf9c40512151151w4cd7d94fw@mail.gmail.com>

On 15/12/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> I've got heavy writes occurring on a RAID 5
> system and it's killing performance, but I'm having trouble identifying the
> offending SQL. Any ideas?
>

If you've got a performance hit due to block writes then wouldn't that be due to any insert/update/delete type SQL. Whether 1 SQL updating 1000 blocks or 1000 SQLs updating one block each.

Are you sure it's block writes that are causing the performance problem? How about writes to the online redo logs? Log switches? LGWR catching up with ARCH? Or something similar?

Stephen

--
It's better to ask a silly question than to make a silly assumption.

http://stephensorablog.blogspot.com/
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 15 2005 - 13:51:57 CST