Re: Performace Degrade after upgrading to 8.1.7.4

hardikarm_at_yahoo.com (Mahesh Hardikar) wrote in message news:<4a1c57c2.0306102220.58515a79_at_posting.google.com>...
> Hello ,
>
> But when I do a import , it will always make Data Block completely
> filled to 90% based on PCTFREE setting. We have very less deletions
> happening in the database. So in such case can PCTUSED give a problem
> in Free List management ? I ran utlbstat & utlestat. Is there any
> indication for the above Wait Event ?
> Correct me if I am wrong.
>
> We have seen no of connections hitting database on a higher side than
> previous one. So CPU is almost busy during load times & 90% processes
> in Run Mode (TOP O/p). sar -q also shows run queue occupied for almost
> 100% Can it be the issue ? Will adding a CPU benefit ?
>
> Regards,
> Mahesh Hardikar

There is a good article by Stephan Haisley on Freelist Management with Oracle 8i. You should read it.

http://www.orapub.com/cgi/genesis.cgi?p1=sub&p2=abs142

Regards
/Rauf Sarwar Received on Wed Jun 11 2003 - 18:09:24 CEST