Disk file operations i/o [message #677884] |
Mon, 21 October 2019 00:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/dc4f1237974f539743612a9cf1c8e2a8?s=64&d=mm&r=g) |
nimaz85
Messages: 2 Registered: October 2019
|
Junior Member |
|
|
Hi
I have a problem in my oracle 11.2.0.4 installed on HP-UX v11.31 which is active session rises with event "Disk File operations i/o" and sessions have parameters p1:2 p2:0 p3:15 . I have searched a lot even in oracle support but i cant understand what the source of the problem is and how to resolve it.
I really appreciate if someone can help me to find the solution.
Thanks
|
|
|
|
Re: Disk file operations i/o [message #677893 is a reply to message #677886] |
Mon, 21 October 2019 03:47 ![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) |
![](//www.gravatar.com/avatar/dc4f1237974f539743612a9cf1c8e2a8?s=64&d=mm&r=g) |
nimaz85
Messages: 2 Registered: October 2019
|
Junior Member |
|
|
Dear Michel
Refer to oracle docs
http://docs.oracle.com/cd/E18283_01/server.112/e17110/waitevents003.htm#insertedID40
the parameters for this event are :
"
Disk file operations I/O
This event is used to wait for disk file operations (for example, open, close, seek, and resize). It is also used for miscellaneous I/O operations such as block dumps and password file accesses.
FileOperation Type of file operation
fileno File identification number
filetype Type of file (for example, log file, data file, and so on)"
In my case fileoperation (p1) is 2 and fileno (p2) is 0 and if you query the v$iostat_file with file_no (p2) =0 ,you can not find filetype_id (p3) with value 15 .
So in my situtaion , the problem is actually unknown!
|
|
|
|
|