oracle 的workload到底是什么意思

发布网友 发布时间：2022-04-11 20:55

我来回答

共2个回答

热心网友 时间：2022-04-11 22:24

　　oracle 的workload的意思是工作量。每个执行的工作量平均工作量是秒每执行测量；秒每执行措施平均净有效时间为一个特定的SQL语句。这表示是有用的测量或比较SQL语句的时间和影响。
　　Oracle Database，又名Oracle RDBMS，或简称Oracle。是甲骨文公司的一款关系数据库管理系统。它是在数据库领域一直处于领先地位的产品。可以说Oracle数据库系统是目前世界上流行的关系数据库管理系统，系统可移植性好、使用方便、功能强，适用于各类大、中、小、微机环境。它是一种高效率、可靠性好的 适应高吞吐量的数据库解决方案。

热心网友 时间：2022-04-11 23:42

您好，很高兴为您解答。

Workload
Workload is also referred to as Active Time.
Workload is a measurement of the Oracle instance's net processing time, measured in seconds. Workload is calculated by aggregating the net activity (non-idle time) for all Oracle processes.
Performance Analysis considers an Oracle process active when it is either:
Consuming CPU
Queued by the operating system, waiting for CPU to become available
Marked by Oracle as active with a non-idle wait event
The Workload indication is used in various contexts to reflect application load; such contexts can be the overall Oracle instance load, indivial session activity, program load over time, etc. and its interpretation may vary among the various totaling methods:
Total Workload is measured in seconds. This representation can be used to compare loads.
Average Workload Per Second Workload is measured by Average Active Sessions. This representation reflects the average number of sessions that were active ring a specified timeframe. This is the default representation for timeline graphs as it best reflects the session load on the instance.
For example:
A value of 5 Average Active Sessions for the Oracle instances Workload indicates that ring the specified timeframe, an average of 5 sessions were actively processing. Such an average can reflect:
10 sessions, each processing for only 50% of the time
20 sessions, each processing for only 25% of the time, or
5 sessions, each processing throughout the specified timeframe.
A value of 0.75 Average Active Sessions for a specific session indicates that ring 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 ring the specified timeframe, an average of 3 sessions ran the SQL statement for the entire ration. 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 ration 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.

原文：http://blog.csdn.net/crazy_xiaoxiao/article/details/8101900

如若满意，请点击右侧【采纳答案】，如若还有问题，请点击【追问】

希望我的回答对您有所帮助，望采纳！

~ O(∩_∩)O~