| abort statspack? [message #261923] |
Fri, 24 August 2007 01:23  |
alantany
Messages: 115
Registered: July 2007
|
Senior Member |
|
|
Hello,all！
Could someone tell me what the relationship in a statspack report among:
"cpu used by this session" "CPU used when call started"---Instance Activity PART
and "CPU time" --TOP 5 PART
Regards!
Alan
|
|
|
|
|
|
| Re: abort statspack? [message #261944 is a reply to message #261926] |
Fri, 24 August 2007 02:31  |
alantany
Messages: 115
Registered: July 2007
|
Senior Member |
|
|
Hi,Michel：
Thanks for your quikly replay：
I am sorry for still puzzling:
does "CPU used by this session" mean the amount of cpu time for only one session?
if there were 10 sessions,so
cpu time = "CPU used by this session"*10?
Am I correct?
Regards!
Alan
|
|
|
|
|
|
| Re: abort statspack? [message #261959 is a reply to message #261948] |
Fri, 24 August 2007 03:01 |
alantany
Messages: 115
Registered: July 2007
|
Senior Member |
|
|
Thanks Michel!
But I found that the "CPU used by this session" is always similar with CPU TIME, even there are over teens sessions.
Why?
And please kindly give a explain on the deferent between:
"CPU used by this session" and "CPU used when call started"
Best regards!
Alan
|
|
|
|
|
|
| Re: abort statspack? [message #262055 is a reply to message #261961] |
Fri, 24 August 2007 07:12 |
alantany
Messages: 115
Registered: July 2007
|
Senior Member |
|
|
Thanks ,Michel!
| Quote: | "CPU used when call started" is CPU before the current call starts. A call is a part of Oracle code.
|
Which call started? I think it means when the session started,the amount of cpu,yes?
Regards!
Alan
[Updated on: Fri, 24 August 2007 07:13] Report message to a moderator |
|
|
|
| Re: abort statspack? [message #262131 is a reply to message #262055] |
Fri, 24 August 2007 12:13 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | Which call started? I think it means when the session started,the amount of cpu,yes?
|
All or any session call.
A call is a small piece of code of Oracle.
Let say both statistics are the same thing but not exactly the same as not taken at the same point.
It does not matter both are approximative, both are wrong just take one and use it as a reference to compare your statspacks.
Most (almost all) of what you find on Internet refer to "CPU used by this session". Steve Adams said that "CPU used when call started" is more accurate. Choose your own.
Regards
Michel
[Updated on: Sat, 25 August 2007 01:37] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
