Re: To estimate maximum active sessions on my oracle database is reasonable to the approach?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 8 Nov 2021 22:40:10 -0500
Message-ID: <3bb49a9f-e03e-5790-7f67-796a73c533b4_at_gmail.com>
Date: Mon, 8 Nov 2021 22:40:10 -0500
Message-ID: <3bb49a9f-e03e-5790-7f67-796a73c533b4_at_gmail.com>
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 SessionsAAS = 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-- http://www.freelists.org/webpage/oracle-l Received on Tue Nov 09 2021 - 04:40:10 CET