Database Tuning (MOSC)

MOSC Banner

checking DirectIO

edited Apr 29, 2010 4:25AM in Database Tuning (MOSC) 3 commentsAnswered
Hello, I have read the doc  ID 555601.1,
to check if i use DirectIO

SQL> select spid, program from v$process where program like '%DBW%';  <br/> <br/>        SPID PROGRAM  <br/>  ---------- ------------------------------------------------  <br/>        2260 oracle@machine (DBW0) <br/> $ strace -o /tmp/strace.out -e trace=open -p 2260 <br/> <br/> <br/> <br/>in the file /tmp/strace.out : <br/>cat strace.out <br/> <br/>open("/proc/8897/stat", O_RDONLY)       = 33 <br/> <br/> <br/>nothing more <br/> <br/>Does someone knows why ? <br/> <br/> <br/>i have made some writes in the db <br/> <br/> Thanks <br/>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center