Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.1 Time Model Statistics

Time model statistics were introduced in Oracle 10.1

The following table shows the 17 time model statistics that were introduced in Oracle 10.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
sequence load elapsed time
sql execute elapsed time