Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 11.1 Time Model Statistics

In both Oracle 10.2 and Oracle 11.1 there are 19 time model statistics.

There are no differences between the time model statistics in the aforementioned versions.

The following table shows the 19 time model statistics in Oracle 11.1:

Name
background cpu time
background elapsed time
connection management call elapsed time
DB CPU
DB time
failed parse (out of shared memory) elapsed time
failed parse elapsed time
hard parse (bind mismatch) elapsed time
hard parse (sharing criteria) elapsed time
hard parse elapsed time
inbound PL/SQL rpc elapsed time
Java execution elapsed time
parse time elapsed
PL/SQL compilation elapsed time
PL/SQL execution elapsed time
repeated bind elapsed time
RMAN cpu time (backup/restore)
sequence load elapsed time
sql execute elapsed time