| performance issue [message #487013] |
Wed, 22 December 2010 01:03  |
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
|
Senior Member |
|
|
Hello Expert,
When looking for a user complain, i traced session is getting wait event "direct path read temp".
So i tried to find more information that causing the wait event.
SQL> SELECT p1 "file#", p2 "block#", p3 "class#"
FROM v$session_wait
WHERE event = 'direct path read temp'; 2 3
file# block# class#
---------- ---------- ----------
201 3985507 15
Next i tried to find the hot block.
SQL> SELECT relative_fno, owner, segment_name, segment_type
FROM dba_extents
WHERE file_id = &file
AND &block BETWEEN block_id AND block_id + blocks - 1 2 3 4
5 ;
Enter value for file: 201
old 3: WHERE file_id = &file
new 3: WHERE file_id = 201
Enter value for block: 3985507
old 4: AND &block BETWEEN block_id AND block_id + blocks - 1
new 4: AND 3985507 BETWEEN block_id AND block_id + blocks - 1
no rows selected
In last i didn't get result, so requested you to please foucus what went wrong.
Regards,
Jay vardhan
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
