Skip to Main Content
  • Questions

  • Current thread count utilization in my database standard edition 12.2.0.1

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Haley.

Asked: February 05, 2023 - 6:20 pm UTC

Last updated: February 06, 2023 - 9:18 am UTC

Version: Oracle database standard edition 12.2.0.1

Viewed 1000+ times

You Asked

Hello,

My Oracle database is 12.2.0.1 standard editon 2 and my OS displays more than 16 threads. Could you please help me check some calculation advice in how to get current thread utilization in my database and Where can I look in statspack for current thread utilization?

Thanks


and Connor said...

You can have as many threads/sessions/connected users as you like.

How we apply the cap is that you get 16 threads *worth" of workload active at any point in time.

Thus if you monitor average *active* sessions over time, you get a measure of how close are you to that limit. Since with SE2 you don't get access to the AWR you can get a good approximation to that with your statspack data. There's plenty of posts around talking about how to get that, but here's a couple to get you started

https://oraculix.com/2015/03/24/visualizing-statspack-average-active-sessions-in-sql-developer/

https://laurent-leturgez.com/2015/11/06/active-average-session-trending-in-statspack/



Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.