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@xxxxxxxxx> 于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@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