Go up

Next thread:	ORA-01940: cannot drop a user that is currently connected
Prev thread:	Replication

Message	Score	Author	Date
I need help with interprting the below statspack r......		Frank S	Dec 27, 2004
send me an email on the following address, I will ......		Syed Jaffar	Dec 28, 2004

Follow up by mail

Click here

---

Subject:	statspack report help
Author:	Frank S, United States
Date:	Dec 27, 2004, 2082 days ago
Os info:	SUN Solaris 5.8
Oracle info:	9.2.0.4
Message:	I need help with interprting the below statspack report. The system is a 2 node RAC cluster, it is running very slowly.Thanks Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 99.97 Redo NoWait %: 100.00 Buffer Hit %: 99.95 In-memory Sort %: 100.00 Library Hit %: 99.78 Soft Parse %: 99.05 Execute to Parse %: 85.92 Latch Hit %: 99.91 Parse CPU to Parse Elapsd %: 2.39 % Non-Parse CPU: 99.68 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 43.04 52.10 % SQL with executions>1: 69.03 66.17 % Memory for SQL w/exec>1: 69.29 69.80 Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Ela Time -------------------------------------------- ------------ ----------- -------- latch free 198,475 21,130 60.10 buffer busy global CR 8,448 5,663 16.11 CPU time 4,026 11.45 global cache cr request 34,360 2,613 7.43 log file sync 2,956 351 1.00
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: statspack report help
Author:	Syed Jaffar, Saudi Arabia
Date:	Dec 28, 2004, 2081 days ago
Message:	send me an email on the following address, I will forward you a good presentation file which describes who to evaluate statspack to resolve the bottleneck. Its really good one. sjaffarhussain@gmail.com SJH OCP DBA
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here