No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7000
3 P. Wisse 5600
4 B. Vroman 5400
5 J. PĂ©ran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 T. Boles 400
10 A. Chavan 300
10 J. Schnackenberg 300
10 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48454
Total active users1499
Act. users last 24h5
Act. users last hour0
Registered user hits last week216
Registered user hits last month950
Go up

CPU time unit
Next thread: Snapshots for PDB
Prev thread: Catch heavy/active SQLs acroos all PDBs

Message Score Author Date
Hi, Does someone know what "Amount of CPU time ...... Lauri Aug 14, 2019, 14:53
Hi, from the quote that you posted (<i>next tim...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Ales Kavsek Aug 19, 2019, 12:30
Hi Ales, Thanks for the explanation. I had fou...... Lauri Aug 20, 2019, 09:08
Hi, thanks, the documentation is pretty clear, ...... Ales Kavsek Aug 20, 2019, 09:19
Hi, Thanks again; for me it was not very clear....... Lauri Aug 21, 2019, 09:53

Follow up by mail Click here


Subject: CPU time unit
Author: Lauri, Netherlands
Date: Aug 14, 2019, 14:53, 97 days ago
Os info: All
Oracle info: 12c and higher
Error info: n/a
Message: Hi,

Does someone know what "Amount of CPU time (in 10s of milliseconds)" in v$statname mean exactly?

Kind Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: CPU time unit
Author: Ales Kavsek, Slovenia
Date: Aug 19, 2019, 12:30, 92 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Hi,

from the quote that you posted (next time please provide exact url to the text you're reading) I would speculate that 10ms is simply a unit of measurement.

If operation (call end - call start) is less than 10ms, Oracle will add 0ms to the total amount. Imagine that you execute 100.000 calls, each call is taking 9ms of CPU. In reality you spent 15 minutes on CPU, but the Oracle statistics will tell you 0.

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-CPU time unit
Author: Lauri, Netherlands
Date: Aug 20, 2019, 09:08, 91 days ago
Message: Hi Ales,

Thanks for the explanation.
I had found it for statistic name=CPU used by this session, on:
https://docs.oracle.com/database/121/REFRN/GUID-2FBC1B7E-9123-41DD-8178-96176260A639.htm#REFRN-GUID-2FBC1B7E-9123-41DD-8178-96176260A639

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-CPU time unit
Author: Ales Kavsek, Slovenia
Date: Aug 20, 2019, 09:19, 91 days ago
Message: Hi,

thanks, the documentation is pretty clear, especially in this part:

If a user call completes within 10 milliseconds, the start and end user-call time are the same for purposes of this statistics, and 0 milliseconds are added.

If call completes in less than 10ms, then Oracle will not report it (it'll add 0 to the total), so Oracle will for 100.000 calls that each lasts 9ms report 0 time spend on CPU, but in reality, you'll be spending 15 minutes.

Regards,
Ales

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-CPU time unit
Author: Lauri, Netherlands
Date: Aug 21, 2019, 09:53, 90 days ago
Message: Hi,

Thanks again; for me it was not very clear. Maybe my English is not so proficient.

King Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here