|
-
Forgot to add
while capturing p1 and p2 from v$syswait, I also captured the physicalreads and blockreads for those P1 from v$filemetric ..
FILE_ID PHYSICAL_READS PHYSICAL_BLOCK_READS PHYSICAL_WRITES PHYSICAL_BLOCK_WRITES
---------- -------------- -------------------- --------------- ---------------------
14 4240 4285 12 12
14 4240 4285 12 12
15 4493 4493 1 1
15 4493 4493 1 1
14 4240 4285 12 12
I am curious to know why the PHYSICAL_READS & the PHYSICAL_BLOCK_READS are so high ... bcoz the waits were pretty frequent (in every couple of seconds).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|