Re: v$sql 'db block changes'

Get

perf_top_10_tables.sql

from www.idevelopment.info under Oracle DBA Scripts.

Modify it so it returns more than 10 tables. You should see your top insert/update/delete tables, or change the query so it only returns those type of actions.

Then look in v$sql_area for insert/update/deletes against those tables.

• Ethan

On 12/15/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> If only it were that easy. The problem here is that the application uses connection pooling, so there is no single session responsible for the heavy updates - it bounces around amongst 40 different sessions. The top statements in v$sql in terms of cpu, elapsed_time, buffer_gets and disk_reads are all SELECT statements, so I know they're not causing the write activity.
>
> Thanks,
> Brandon

--
http://www.freelists.org/webpage/oracle-l