oracle aas计算公式,模仿Oracle OEM 展现AAS average active sessions

最新推荐文章于 2023-10-02 12:30:19 发布

鲍鱼王

最新推荐文章于 2023-10-02 12:30:19 发布

阅读量977

点赞数

文章标签： oracle aas计算公式

本文展示了如何使用R语言的ggplot2、RODBC和scales库来计算和展示Oracle AAS（Average Active Sessions）。通过创建图表，详细地分析了不同活动类型在特定时间间隔内的活跃会话数，包括'Other', 'Cluster', 'Network'等十二个类别，并对图例顺序进行了定制。" 124145813,8654183,TypeScript命名空间详解,"['开发语言', 'typescript']

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

library(ggplot2)

library(RODBC)

library(scales) # to access breaks/formatting functions

channel

tb_active_session

tb_active_session_AAS

#所有活动会话数的活动类型的次数展现

#自定义调整图例顺序，

tb_active_session$ACTIVITY=factor(tb_active_session$ACTIVITY,levels=c("Other","Cluster","Network","Administrative","Configuration"

,"Commit","Application","Concurrency","System I/O","User I/O","Scheduler","CPU"))

g+geom_area(aes(fill=ACTIVITY),stat="identity"

,position = "stack",rm=T ) + scale_fill_manual(values=c("#FF6699", "#CCCC99", "#999966","#666666"

, "#663300", "#CC6600", "#CC3300", "#FF0000", "#0099FF", "#0033FF", "#99FF99","#00CC00")) + scale_x_datetime(breaks = date_breaks("10 min"), labels = date_format("%H:%M"))

#AAS 展现

#自定义调整图例顺序，

tb_active_session_AAS$ACTIVITY=factor(tb_active_session_AAS$ACTIVITY,levels=c("Other","Cluster","Network","Administrative","Configuration"

,"Commit","Application","Concurrency","System I/O","User I/O","Scheduler","CPU"))

gAAS

gAAS+geom_area(aes(fill=ACTIVITY),stat="identity"

,position = "stack",rm=T ) + scale_fill_manual(values=c("#FF6699", "#CCCC99", "#999966","#666666"

, "#663300", "#CC6600", "#CC3300", "#FF0000", "#0099FF", "#0033FF", "#99FF99","#00CC00")) + scale_x_datetime(breaks = date_breaks("10 min"), labels = date_format("%H:%M"))