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>

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 Received on Wed Jun 11 2003 - 08:20:12 CEST

This message: [ Message body ]
Next message: Joel Garry: "Re: End of the distribution of Oracle 8i"
Previous message: Prasad Mahale: "How to trap error in sqlplus?"
Maybe in reply to: Mahesh Hardikar: "Performace Degrade after upgrading to 8.1.7.4"
Next in thread: Rauf Sarwar: "Re: Performace Degrade after upgrading to 8.1.7.4"
Reply: Rauf Sarwar: "Re: Performace Degrade after upgrading to 8.1.7.4"
Reply: sybrandb_at_yahoo.com: "Re: Performace Degrade after upgrading to 8.1.7.4"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message