| statspack [message #276658] |
Thu, 25 October 2007 21:01  |
alantany
Messages: 115
Registered: July 2007
|
Senior Member |
|
|
Hello,all:
Here is a part of my statspack:
STATSPACK report for
DB Name DB Id Instance Inst Num Release OPS Host
------------ ----------- ------------ -------- ----------- --- ------------
ORA817 121212121 ora817 2 8.1.7.0.0 YES test
Snap Id Snap Time Sessions
------- ------------------ --------
Begin Snap: 131 25-Oct-07 14:45:28 23
End Snap: 162 25-Oct-07 15:18:37 23
Elapsed: 33.15 (mins)
.
.
.
Instance Activity Stats for DB: ORA817 Instance: ora817 Snaps: 131 -162
Statistic Total per Second per Trans
--------------------------------- ---------------- ------------ ------------
CPU used by this session 14,599,631 7,340.2 19,544.4
CPU used when call started 2,676 1.4 3.6
I notice that the CPU used by this session is very big,but CPU used when call started is so small.
Could someone give me a explain?
Regards
Alan
[Updated on: Thu, 25 October 2007 21:11] Report message to a moderator |
|
|
|
|
|
| Re: statspack [message #276708 is a reply to message #276694] |
Fri, 26 October 2007 01:13  |
alantany
Messages: 115
Registered: July 2007
|
Senior Member |
|
|
Thanks reply:
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
resource_limit boolean FALSE |
|
|
|
|
|
| Re: statspack [message #276725 is a reply to message #276721] |
Fri, 26 October 2007 02:10 |
alantany
Messages: 115
Registered: July 2007
|
Senior Member |
|
|
Thanks,Michel
Maybe you are correct,the system looks pretty idle from the report,
CPU used when call started here looks correct.
Regards
Alan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
