To estimate maximum active sessions on my oracle database is reasonable to the approach?
From: Quanwen Zhao <quanwenzhao_at_gmail.com>
Date: Sun, 31 Oct 2021 11:35:01 +0800
Message-ID: <CABpiuuQ=dv6fKW=jq3Xrt8gWSKLB8csnhMwWfiCUcjbR2+07wA_at_mail.gmail.com>
Hey my folks and colleagues 😉,
Date: Sun, 31 Oct 2021 11:35:01 +0800
Message-ID: <CABpiuuQ=dv6fKW=jq3Xrt8gWSKLB8csnhMwWfiCUcjbR2+07wA_at_mail.gmail.com>
Hey my folks and colleagues 😉,
For estimating the *maximum concurrent connections* on my oracle database server I did the some work as follows:
- Acquiring *Average Active Sessions* & *Logic CPUs* in Real Time;
- Retrieving the *current concurrent connections* on view *"v$session"*;
Via the above two steps I've got some data, such as, aas value is *3.66* and logic cpus are *192*. Next I've got the current concurrent connections (*61*) by running this SQL statement: *select count(*) from v$session where status = 'ACTIVE';* Thus I am able to estimate the maximum concurrent connections using the following formula: aas value / logic cpus = current concurrent connections / maximum concurrent connections. That is to say, *3.66 / 192 = 61 / maximum concurrent connections*, so which is *3200*. Is it reasonable to this approach?
Best Regards
Quanwen Zhao
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Oct 31 2021 - 04:35:01 CET