Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Issues with OS and database performance
"barraboombarrabin" <barraboombarrabing_at_yahoo.com> wrote in message
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.
> 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.
>
> Thank you
>
stop looking at the system as a whole
find the offending processes, trace them and see what they are waiting on - fix them. Received on Sat Jun 18 2005 - 10:14:58 CDT