Re: Performace Degrade after upgrading to 8.1.7.4
From: Mahesh Hardikar <hardikarm_at_yahoo.com>
Date: 10 Jun 2003 23:20:12 -0700
Message-ID: <4a1c57c2.0306102220.58515a79_at_posting.google.com>
Date: 10 Jun 2003 23:20:12 -0700
Message-ID: <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 ?
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,
Correct me if I am wrong.
Mahesh Hardikar