How to write some sql statements about "Active Sessions" and "Runnable Processes" of oracle database?

  • From: Quanwen Zhao <quanwenzhao@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 20 Oct 2021 15:20:39 +0800

Hello my friends 😊,

How to write some sql statements about *"Active Sessions"* and *"Runnable
Processes"* in the same intention acquiring the similar graph on *EMCC 13.5*
monitoring my oracle database?

eg. the following *2* number of *AAS *(*Average Active Sessions*) graphs
and *ARP* (*Average Runnable Processes*) graph:

[image: 70f84f7dba1ce8737e29be7f4b98819.png]

[image: 1c8c48082f98911467245a3be869ad8.png]

[image: 672729ee008996310d1069aaa7d8d37.png]

Thank you in advance, if any help I'll appreciate you!

Best Regards
Quanwen Zhao

PNG image

PNG image

PNG image

Other related posts:

  • » How to write some sql statements about "Active Sessions" and "Runnable Processes" of oracle database? - Quanwen Zhao