Home » RDBMS Server » Performance Tuning » Disk file operations i/o (ORACLE 11.2.0.4 on HP-UX.)
Disk file operations i/o [message #677884] Mon, 21 October 2019 00:52 Go to next message
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 #677886 is a reply to message #677884] Mon, 21 October 2019 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This section of Database Reference gives you the description of this event.

First parameter is file operation:
    1 file creation
    2 file open
    3 file resize
    4 file deletion
    5 file close
    6 wait for all aio requests to finish
    7 write verification
    8 wait for miscellaneous io (ftp, block dump, passwd file)
    9 read from snapshot files
Second parameter is file number in its type.

Third parameter is file type:
    1 Control File
    2 Data File
    3 Log File
    4 Archive Log
    6 Temp File
    9 Data File Backup
   10 Data File Incremental Backup
   11 Archive Log Backup
   12 Data File Copy
   13 Parameter File
   14 DR Config file
   15 OSM File
   16 Change Tracking File
   17 Flashback Log
   18 Data Pump Dump File
   19 Cross Platform Data File
   20 Auto Backup File
   21 OS file
   22 Block Dump File
   23 CSS Voting File
   24 OCR File
   25 ASM Staleness File
   26 ASM Vol Device File
   27 ASM Vol Dirty Region File
   28 Password File
   29 ADS AMS Relation File
   30 OCR Backup File
   31 ASM Parameter File
   32 Flash File
   33 ASM spfile backup
   34 External Table File
   35 Data File XTT Backup
   36 OS Audit File
   37 Data File Incremental Backup
   38 AKM KeyStore
   39 AKM AutoLogin KeyStore
   40 ORS Block Pool File
   41 SQL Loader File
   42 AM Container File
Re: Disk file operations i/o [message #677893 is a reply to message #677886] Mon, 21 October 2019 03:47 Go to previous messageGo to next message
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!








Re: Disk file operations i/o [message #677896 is a reply to message #677893] Mon, 21 October 2019 04:26 Go to previous messageGo to next message
cookiemonster
Messages: 13747
Registered: September 2008
Location: Rainy Manchester
Senior Member
If the values you're getting don't correspond to what the documentation says then your only option is to raise the issue with oracle support.
Re: Disk file operations i/o [message #677901 is a reply to message #677893] Mon, 21 October 2019 10:57 Go to previous message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You didn't read what I posted, I posted the list of file types.
Your file type (p3) is 15 that is "OSM File".

Previous Topic: SQL_Text on SQL Profile
Next Topic: Solution for database hung
Goto Forum:
  


Current Time: Fri Dec 06 15:09:55 CST 2019