Re: Oracle 7.3.4 on AIX. Why IS It SOOOOO SLow

estat and bstat would be the last places I'd look. Sure, I'd look, but *last*.

Have you looked at the disk i/o, memory usage (esp. swap) and cpu usage? What about the sql you are actually running? Bind variables being used? What are the plans like. What's the database layout look like? What sort of disk subsystem do you have? Is the box really big enough - even if perfectly tuned - to do what you are trying to do? What other processing is running on the box? How much SGA you got - is it being paged? Etc., etc., etc.

We run a few Oracle databases on AIX with servers smaller than J30's and they run fine. Suggest you do a bit more investigation like the stuff mentioned above. Get someone in for a day or so's consultancy to help if you need it.

Mike wrote:

> I have a relatively small database on AIX 4.2.1 (model J30) running Oracle
> 7.3.4.3 Financials...
>
> Estat and Bstat all look pretty good. Testing has revealed that sql
> statements (especially inserts) do not seem to be getting cached. The same
> sql execute over and over takes the same time or longer to execute...
>
> Are there any key patches either Oracle or AIX that could possibly improve
> poor response. We are not using async/io as it does not seem to make any
> difference.
>
> I can provide much more detail on what has been tried, config files, etc...
>
> TIA,
>
> Mike
Received on Wed Apr 28 1999 - 15:28:06 CDT