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

Thank you so much for the reference PDF from *DOAG*, Jonathan 😉! I've also found the similar PDF from oracle -
*https://www.oracle.com/technetwork/oem/db-mgmt/s317294-db-perf-tuning-with-db-time-181631.pdf* <https://www.oracle.com/technetwork/oem/db-mgmt/s317294-db-perf-tuning-with-db-time-181631.pdf>, they are both very interesting and I'll read and learn it as well.

Best Regards
Quanwen Zhao

Jonathan Lewis <jlewisoracle_at_gmail.com> 于2021年11月9日周二 下午10:09写道：

>
> 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