oracle μ?workloadμ?è¨ít?aêí(3)

 

A value of 0.75 Average Active Sessions for a specific session indicates that during the specified timeframe, the session was active 75% of the time. Values greater than 1 indicate that the session has been parallelized (parallel query) and is using more than a single query slave.

 

A value of 3 Average Active Sessions for a specific SQL Statement indicates that during the specified timeframe, an average of 3 sessions ran the SQL statement for the entire duration. Such an average can reflect: 

 

6 sessions, each running the SQL statement for 50% of the specified timeframe,

 

12 sessions, each running the statement for 25% of the specified timeframe, or

 

3 sessions, each running the SQL statement throughout the entire specified timeframe.

 

Average Workload Per Execution Workload is measured in Seconds Per Execution; Seconds Per Execution measures the average net active time for a particular SQL statement. This representation is useful for measuring or comparing the duration and impact of SQL statements. Note that this metric represents the average net processing time and therefore differs from the Average SQL Duration metric that measures the average elapsed SQL time.