Re: Issues with OS and database performance

"barraboombarrabin" <barraboombarrabing_at_yahoo.com> wrote in news:1119106188.500213.149290_at_f14g2000cwb.googlegroups.com:

> We have a datawarehouse which has some performance issues.
> I am look for some reading material on how to analyze issues at the
> operating system level and correlating that with database performance.

Why?
The OS is only providing resources to Oracle. Oracle is the cause.
Linux is the effect.
Observing OS statics is typically a waste of time WRT Oracle tuning. Learn how to enable EVENT 10046, enable tracing at level 8 or 12, and learn how to run TKPROF on the trace files and understand TKPROF output.

> Specifically, I am looking for Red Hat Linux Operating system release 3
> and Oracle data 9.2.0.4 database.
> Basically, I need to generate some kind of stats looking at the output
> of commands like sar on OS and relate them to specific queries running
> in the database by looking at information from tools like statspack.
> Any books or articles that you can suggest that provide a good insight
> into this area will be appreciated.

ISBN: 0072131454 ISBN: 007222729X ISBN: 059600527X Received on Sat Jun 18 2005 - 10:44:46 CDT