> I have a relatively small database on AIX 4.2.1 (model J30) running Oracle
> 188.8.131.52 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
> I can provide much more detail on what has been tried, config files, etc...
Oracle performance on AIX issues have been covered at great length in this
group within the last year or so. Check out the archive and do a search on
"Oracle" or "Oracle tuning" or something similar. You should be able to find
what you're looking for. If you don't please repost a new question and we'll
help in any way we can.
Robert Kennedy - A fool and his ideas are...umm...uhh...I forgot.
Boeing Space and Communications Group
Kent Space Center
System Administration - CAD/CAM
f u cn rd ths ur prbly a unix usr...