No question at this time
DBA Top 10
1 A. Kavsek 10600
2 M. Cadot 8900
3 B. Vroman 5600
4 P. Wisse 4800
5 J. PĂ©ran 2000
6 . Lauri 1000
7 D. Johnson 300
8 J. Van Der Steen 200
8 G. Muijrers 200
8 R. Chandran 200
8 G. Am77 200
8 B. Bartben 200
8 N. Abdul Rahman 200
8 J. Akhtar 200
8 F. Dumaguin 200
8 R. Rakotozafy 200
8 D. Ramakrishna 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48497
Total active users1452
Act. users last 24h7
Act. users last hour0
Registered user hits last week218
Registered user hits last month669
Go up

Disk File operations i/o
Next thread: 19c pdb duplication
Prev thread: swappiness

Message Score Author Date
Hi Sometimes we face performance issue on our OLT...... Ati V.rad Feb 26, 2020, 10:14
P2 is file number, file type is P3. See this th...... Michel Cadot Feb 26, 2020, 12:15
Hi Michel Thank you for your reply. The thread ...... Ati V.rad Feb 29, 2020, 13:20
Is this P2 or P3 you posted? Your first post i...... Michel Cadot Feb 29, 2020, 14:23
P1(operation) = 2 P2(file_no) = 0 P3(file_type...... Ati V.rad Mar 01, 2020, 08:42
OK. OSM files are part of Order and Service Man...... Michel Cadot Mar 01, 2020, 08:54
What is it doing in Oracle Database? Regards A...... Ati V.rad Mar 01, 2020, 10:06
I don't know. Maybe not in Oracle database but ...... Michel Cadot Mar 01, 2020, 10:15
Thank you. Regards Ati... Ati V.rad Mar 01, 2020, 10:21

Follow up by mail Click here


Subject: Disk File operations i/o
Author: Ati V.rad, Canada
Date: Feb 26, 2020, 10:14, 41 days ago
Os info: HP UX 11.31
Oracle info: 11.2.0.4
Error info: Disk File operations i/o
Message: Hi
Sometimes we face performance issue on our OLTP database with 5 nodes RAC, and DB time increases due to high number of active sessions waiting for 'Disk File Operations i/o'. Even response time of small queries raise because of this wait-event. After rebooting the server the problem disappears.
the P1 , P2 parameters are:
operation_type = 2 > File Open
file_type = 15 > OSM File
Mention that there is no performance issue on storage devices, everything has been checked at the IO Level.
My question is about OSM File. I cannot figure what is OSM file has to do with oracle database, while we do not use OSM or any service of that. Can anyone help me to understand the situation here.
Best Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Disk File operations i/o
Author: Michel Cadot, France
Date: Feb 26, 2020, 12:15, 41 days ago
Message:
P2 is file number, file type is P3.
See this thread:
http://www.orafaq.com/forum/mv/msg/206174/677884/#msg_677884

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Disk File operations i/o
Author: Ati V.rad, Canada
Date: Feb 29, 2020, 13:20, 38 days ago
Message: Hi Michel

Thank you for your reply. The thread didn't help me. I have the same problem but there is no answer.
What is OSM File? Why the problem disappears after OS reboot?

Regards
Ati
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Disk File operations i/o
Author: Michel Cadot, France
Date: Feb 29, 2020, 14:23, 38 days ago
Message:
Is this P2 or P3 you posted?
Your first post is inconsistent on this point.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Disk File operations i/o
Author: Ati V.rad, Canada
Date: Mar 01, 2020, 08:42, 37 days ago
Message: P1(operation) = 2
P2(file_no) = 0
P3(file_type) = 15

According to references operation is "file open", and file_type 15 is "OSM File".

Regards
Ati
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Disk File operations i/o
Author: Michel Cadot, France
Date: Mar 01, 2020, 08:54, 37 days ago
Message:
OK.
OSM files are part of Order and Service Management, a component of Weblogic.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Disk File operations i/o
Author: Ati V.rad, Canada
Date: Mar 01, 2020, 10:06, 37 days ago
Message: What is it doing in Oracle Database?

Regards
Ati
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Disk File operations i/o
Author: Michel Cadot, France
Date: Mar 01, 2020, 10:15, 37 days ago
Message:
I don't know.
Maybe not in Oracle database but manage by Oracle instance as it is Oracle stuff.
I think you can post your question in an Weblogic forum.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Disk File operations i/o
Author: Ati V.rad, Canada
Date: Mar 01, 2020, 10:21, 37 days ago
Message: Thank you.

Regards
Ati
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here