Re: performance issues

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Tue, 06 Dec 2005 16:13:03 GMT
Message-ID: <4395b83e.1727121875@localhost>

On 5 Dec 2005 15:03:26 -0800, vissuyk_at_yahoo.com wrote:

>OS = Linux, about 100 concurrent users, dedicated server, Middle tier
>machine runs JSP issues queries on backend, db machine has 8 Gigs RAM,
>SQL is well tuned. OEM Performance Manager and ADDM reports shows
>bottle necks in IO. I am not using recylce pool. I have two IO
>controllers controlling 16 15K RPM drives. SGA = 2.7 Gigs, buffer cache
>= 1 Gig; log buffer about 10 M, all files are well striped. The db
>machine also runs several batch jobs (updates every 15 minutes). The
>batch updates as many as 10 million rows, lots of DML.

You need to look at top queries by IO. I hope you use bind vars and those are easy to identify..
.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4 remove NSPAM to email Received on Tue Dec 06 2005 - 10:13:03 CST