V$SYS_TIME_MODEL

Oracle 11gR1

V$SYS_TIME_MODEL displays the system-wide accumulated times for various operations. The time reported is the total elapsed or CPU time (in microseconds). Any timed operation will buffer at most 5 seconds of time data. Specifically, this means that if a timed operation (such as SQL execution) takes a long period of time to perform, the data published to this view is at most missing 5 seconds of the time accumulated for the operation.

The time values are 8-byte integers and can therefore hold approximately 580,000 years worth of time before wrapping. Background process time is not included in a statistic value unless the statistic is specifically for background processes.

Column	Datatype	Description
STAT_ID	NUMBER	Statistic identifier for the time statistic
STAT_NAME	VARCHAR2(64)	Name of the statistic
VALUE	NUMBER	Amount of time (in microseconds) that the system has spent in this operation

Note:

1.

select stat_id, stat_name, round(value/1000/3600) hours from V$SYS_TIME_MODEL;

STAT_ID	STAT_NAME	HOURS
3649082374	DB time	3120457
2748282437	DB CPU	1829717
4157170894	background elapsed time	1163173
2451517896	background cpu time	1033763
4127043053	sequence load elapsed time	4931
1431595225	parse time elapsed	78941
372226525	hard parse elapsed time	49988
2821698184	sql execute elapsed time	3053867
1990024365	connection management call elapsed time	3071
1824284809	failed parse elapsed time	16759
4125607023	failed parse (out of shared memory) elapsed time	0
3138706091	hard parse (sharing criteria) elapsed time	1487
268357648	hard parse (bind mismatch) elapsed time	64
2643905994	PL/SQL execution elapsed time	258956
290749718	inbound PL/SQL rpc elapsed time	1595
1311180441	PL/SQL compilation elapsed time	17707
751169994	Java execution elapsed time	4709
1159091985	repeated bind elapsed time	346
2411117902	RMAN cpu time (backup/restore)	993361

2. V$SESS_TIME_MODEL and V$SYS_TIME_MODEL Statistics

Statistic Name	Description
DB Time	Amount of elapsed time (in microseconds) spent performing Database user-level calls. This does not include the time spent on instance background processes such as PMON.
DB CPU	Amount of CPU time (in microseconds) spent on database user-level calls. This does not include the CPU time spent on instance background processes such as PMON.
background CPU time	Amount of CPU time (in microseconds) consumed by database background processes.
sequence load elapsed time	Amount of elapsed time spent getting the next sequence number from the data dictionary. If a sequence is cached, then this is the amount of time spent replenishing the cache when it runs out. No time is charged when a sequence number is found in the cache. For non-cached sequences, some time will be charged for every nextval call.
parse time elapsed	Amount of elapsed time spent parsing SQL statements. It includes both soft and hard parse time.
hard parse elapsed time	Amount of elapsed time spent hard parsing SQL statements.
SQL execute elapsed time	Amount of elapsed time SQL statements are executing. Note that for select statements this also includes the amount of time spent performing fetches of query results.
connection management call elapsed time	Amount of elapsed time spent performing session connect and disconnect calls.
failed parse elapsed time	Amount of time spent performing SQL parses which ultimately fail with some parse error.
hard parse (sharing criteria) elapsed time	Amount of elapsed time spent performing SQL hard parses when the hard parse resulted from not being able to share an existing cursor in the SQL cache.
hard parse (bind mismatch) elapsed time	Amount of elapsed time spent performing SQL hard parses when the hard parse resulted from bind type or bind size mismatch with an existing cursor in the SQL cache.
PL/SQL execution elapsed time	Amount of elapsed time spent running the PL/SQL interpreter. This does not include time spent recursively executing/parsing SQL statements or time spent recursively executing the Java VM.
PL/SQL compilation elapsed time	Amount of elapsed time spent running the PL/SQL compiler.
inbound PL/SQL rpc elapsed time	Time inbound PL/SQL remote procedure calls have spent executing. It includes all time spent recursively executing SQL and JAVA, and therefore is not easily related to "PL/SQL execution elapsed time".
Java execution elapsed time	Amount of elapsed time spent running the Java VM. This does not include time spent recursively executing/parsing SQL statements or time spent recursively executing PL/SQL.

The relationships between the statistics listed in Table 8-1 form two trees in which all the time reported by a child in the tree is contained within the parent in the tree. The following are the relationship trees; the number is the level in the given tree.

1) background elapsed time

      2) background cpu time

1) DB time

    2) DB CPU

    2) connection management call elapsed time

    2) sequence load elapsed time

    2) sql execute elapsed time

    2) parse time elapsed

          3) hard parse elapsed time

                4) hard parse (sharing criteria) elapsed time

                    5) hard parse (bind mismatch) elapsed time

          3) failed parse elapsed time

                4) failed parse (out of shared memory) elapsed time

    2) PL/SQL execution elapsed time

    2) inbound PL/SQL rpc elapsed time

    2) PL/SQL compilation elapsed time

    2) Java execution elapsed time

The relationship between a parent and a child in the tree indicates containment only. Please keep the following in mind with regard to the tree:

· Children do not necessarily add up to the parent.

· Children are not necessarily exclusive (that is, it is possible that they overlap).

· The union of children does not necessarily cover the whole of the parent.

Oracle dynamic performance views