tunning [message #493025] |
Fri, 04 February 2011 05:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/0edc5401ff22b4cca6a249f6b1bd46cc?s=64&d=mm&r=g) |
gxeon
Messages: 53 Registered: January 2011 Location: Mumbai
|
Member |
|
|
Hello frds
can anyone please help me to know, how to find the tables in
the database on which high DMLs are firing.
please help
|
|
|
|
|
|
Re: tunning [message #493043 is a reply to message #493039] |
Fri, 04 February 2011 06:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68664 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
select owner, object_name, subobject_name, nb_writes
from ( select owner, object_name, subobject_name,
sum(value) nb_writes,
rank() over (order by sum(value) desc) rk
from v$segment_statistics
where statistic_name like 'physical writes%'
and owner != 'SYS'
group by owner, object_name, subobject_name
having sum(value) > 0 )
where rk <= 50
order by rk
/
Regards
Michel
[Updated on: Fri, 04 February 2011 08:35] Report message to a moderator
|
|
|
|