Disk IO tuning of Oracle OLTP database applications is very difficult because very short operations are constantly occurring. SQL tasks and select operations are very short in manner. Means we can say that, only index scanning operations are more than full table scan operations.
The tuning of disk IO is very critical for every Oracle server. Some expert system admin prefers disk caching using read-ahead caches configuration at the server. This read-ahead caches technique successfully eliminates heavy disk IO operations. But in some application is not helpful to cut down physical reads of server-side.
A new article has been published to provide a more detailed explanation of read-ahead caching useful for Oracle OLTP or not. Dbametrix has the goal to provide exclusive Oracle DBA tips in every aspect and topics which you can’t find anywhere else.
For more detail of every technical article, kindly check our Oracle DBA Tips section.
Thanks and regards,
Expert Remote DBA team of Dbametrix