Re: To estimate maximum active sessions on my oracle database is reasonable to the approach?

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 8 Nov 2021 22:40:10 -0500


On 11/7/21 19:31, denis.sun@xxxxxxxxx (denis.sun) wrote:
I don't think AAS has any relationship to the number of CPU cores or the utilization of CPU core ( 100% or 0%).
AAS = Average Active Sessions AAS = DB Time/Elapsed Time(wall clock) DB Time = CPU Time + non-idle wait time


Hi Denis,

I am not sure that I understand this equivalence. Can you please clarify a bit?

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
-- //www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2021