Home » RDBMS Server » Server Administration » statspack (8.1.7.0 ops)
statspack [message #276658] Thu, 25 October 2007 21:01 Go to next message
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 #276694 is a reply to message #276658] Fri, 26 October 2007 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
resource_limit set to true?

Regards
Michel
Re: statspack [message #276708 is a reply to message #276694] Fri, 26 October 2007 01:13 Go to previous messageGo to next message
alantany
Messages: 115
Registered: July 2007
Senior Member

Thanks reply:
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
resource_limit boolean FALSE
Re: statspack [message #276721 is a reply to message #276708] Fri, 26 October 2007 01:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are bugs with CPU used by this session which is wrongly calculated in some circonstances. CPU used when call started is more reliable but not exempt from bugs.

Regards
Michel
Re: statspack [message #276725 is a reply to message #276721] Fri, 26 October 2007 02:10 Go to previous message
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
Previous Topic: Checking Remote database is up or not
Next Topic: the mean of avrd(ms)
Goto Forum:
  


Current Time: Thu Dec 08 14:27:58 CST 2016

Total time taken to generate the page: 0.08455 seconds