Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Statspack

Status
Not open for further replies.
snayak

snayak

IS-IT--Management
Nov 20, 2002
23
Hi,

I want to plot the graph for cpu used in hour , hence I queried the table stats$sysstat and got the logons current and cpu used by session by subtracting from the previous snapshot i.e.

Cpu used by session : 584439144
Logons current : 530

Hence I divided the cpu used by session in sec by logons current to know the cpu used per session but it gives me a big number . Can anyone explain how to get the above requirement.

Thanks,
With regards
 
Status
Not open for further replies.

Similar threads

mrn
  • Locked
  • Question
Statspack
Replies
6
Views
112
appi
appi
oracle8
  • Locked
  • Question
FREE DOWNLOAD OF STATSPACK
Replies
2
Views
89
oracle8
oracle8
lhugh
  • Locked
  • Question
change statspack default report location
Replies
2
Views
152
lhugh
lhugh
lhugh
  • Locked
  • Question
error while running statspack -"unable to exetend index"
Replies
2
Views
138
lhugh
lhugh
rk0000
  • Locked
  • Question
Installing statspack on oracle 8.1.6
Replies
0
Views
68
rk0000
rk0000

Part and Inventory Search

Sponsor

Back
Top