Home » RDBMS Server » Server Administration » abort statspack?
abort statspack? [message #261923] Fri, 24 August 2007 01:23 Go to next message
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 #261926 is a reply to message #261923] Fri, 24 August 2007 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Reference
Annex E Statistics Descriptions
Section Statistics Descriptions

Regards
Michel
Re: abort statspack? [message #261944 is a reply to message #261926] Fri, 24 August 2007 02:31 Go to previous messageGo to next message
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 #261948 is a reply to message #261944] Fri, 24 August 2007 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, this is the sum of the statistics for all sessions.

Regards
Michel
Re: abort statspack? [message #261959 is a reply to message #261948] Fri, 24 August 2007 03:01 Go to previous messageGo to next message
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 #261961 is a reply to message #261959] Fri, 24 August 2007 03:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But I found that the "CPU used by this session" is always similar with CPU TIME, even there are over teens sessions

Which others?

"CPU used when call started" is CPU before the current call starts. A call is a part of Oracle code.

Regards
Michel
Re: abort statspack? [message #262055 is a reply to message #261961] Fri, 24 August 2007 07:12 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: abort statspack? [message #262184 is a reply to message #262131] Fri, 24 August 2007 19:03 Go to previous message
alantany
Messages: 115
Registered: July 2007
Senior Member

Cool~~~
I think I got it.
Thanks ,Michel!
Alan
Previous Topic: can i kill unwanted background process from XE database
Next Topic: platform migration form solaris 5.8 to linux
Goto Forum:
  


Current Time: Fri Dec 02 12:21:39 CST 2016

Total time taken to generate the page: 0.06984 seconds