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

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_at_gmail.com> wrote:

>
> On 11/7/21 19:31, denis.sun_at_yahoo.com (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
>
> -- http://www.freelists.org/webpage/oracle-l

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