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

  • From: Jonathan Lewis <jlewisoracle@xxxxxxxxx>
  • To: Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 9 Nov 2021 14:08:29 +0000

One reference here:
https://www.doag.org/formes/pubfiles/5268742/2013-DB-Graham_Wood-DB_Time-based_Oracle_Performance_Tuning__Theory_and_Practice-Praesentation.pdf

There are probably several newer version of the presentation somewhere else
on the Internet, and a video on youtube


Regards
Jonathan Lewis







On Tue, 9 Nov 2021 at 03:40, Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:


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-1217https://dbwhisperer.wordpress.com

-- //www.freelists.org/webpage/oracle-l

Other related posts:

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