Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Async. I/O - Oracle - Is there any way to find out ?

SOLVED
Go to solution
Degner, Jürgen
Occasional Advisor

Async. I/O - Oracle - Is there any way to find out ?

Because of an current database problem we do have a little discussion about the I/O coming from the Oracle DB.
Our DB_Admin says, that the database is configured for async. IO - as far as I know this also needs to be enabled on the operating system. We are using HP-UX 11.23 v2 and Online JFS 4.1 - However since the DB-Files are not located on RAW devices, data should not come in other then syncronized.
Is there any way to find out ?

Regards
J. Degner
3 REPLIES
Geoff Wild
Honored Contributor
Solution

Re: Async. I/O - Oracle - Is there any way to find out ?

That is correct - async I/O is only for RAW and HFS filesystems - period.

Tell DBA's to turn off async I/O.

Async IO is NOT supported on file systems, only on raw devices and particular volume managers like Veritas.

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams061.htm#sthref246

So basically, we shouldn't be using async i/o on HP-UX.

Someone else said to look at metalink note 60692.1



Rgds...Geoff
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Coolmar
Esteemed Contributor

Re: Async. I/O - Oracle - Is there any way to find out ?

Please see the following thread....it basically confirms what Geoff wrote above, but good to see other opinions - esp. since you have to go back to the DBA with this information.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1040722&admit=-682735245+1165263807457+28353475

S.
Degner, Jürgen
Occasional Advisor

Re: Async. I/O - Oracle - Is there any way to find out ?

Thank you all for the quick response, I strongly believe that our DBA will accept these information. I assume that he is going to try out working with i/o slaves.

Regards
J. Degner