| High I/O disk writes [message #359919] |
Tue, 18 November 2008 17:01  |
Georgette
Messages: 3
Registered: November 2008
|
Junior Member |
|
|
Not an Oracle DBA but are installing a replication software on AIX 5.3 to replicate the LV's Oracle lives on. We are seing very high volumes of disk writes and are looking for a way to track down the process causing these writes.
Is there a SQL statement that could tell me who/what is causing this? or an AIX command maybe?
Thanks.
|
|
|
|
|
|
| Re: High I/O disk writes [message #360602 is a reply to message #360412] |
Fri, 21 November 2008 10:29  |
Georgette
Messages: 3
Registered: November 2008
|
Junior Member |
|
|
The replication happens at a very low level and does not give any visibility on the data that's moved across.
Here's maybe another question that could help me find the problem:
Does anyone know how to get stats out of the temp tablespace and redo logs? I would like to see what sql statements are producing the most i/o writes to these table.
|
|
|
|
| Re: High I/O disk writes [message #360981 is a reply to message #360602] |
Mon, 24 November 2008 09:14 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Have a look at the view v$sql.
That has columns such as disk_reads, buffer_gets, cpu_time ec that will give ou an idea about how the pieces of sql are performing on average.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
