Skip to Main Content
  • Questions

  • How can i measure thread usage in a 11g standard edition database

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, JOHN.

Asked: August 19, 2016 - 9:34 am UTC

Last updated: August 23, 2016 - 1:19 am UTC

Version: 11g

Viewed 1000+ times

You Asked

We have an 11g standard edition database. We are being faced with an upgrade to 12c standard edition 2 with its inherent thread limit. Within my database I can see sockets, cores and cpu usage but I need some advice on how this relates to the thread usage. What exactly does oracle mean by a thread ? and how I relate this to the OS data that I can gather.

and Chris said...

This blog post answers a lot of "thread" related questions for SE2, including how to check how many threads your OS supports:

https://blogs.oracle.com/UPGRADE/entry/se2_some_questions_some_answers

Look under "Other topics".

But basically it's how many processes the OS can run concurrently.

You can find your current usage by checking statspack, as shown in:

http://www.redstk.com/current-thread-count-for-your-standard-edition-oracle-databases/

Rating

  (1 rating)

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

Comments

threads and cores

John Wilson, August 22, 2016 - 12:00 pm UTC

From your response it seems clear that as far as Oracle is concerned, a thread is sim[ply a core, and the thread limit is the same as saying it is a limit on the number of active (non background) sessions. Would you agree with this ?


Connor McDonald
August 23, 2016 - 1:19 am UTC

That is how I interpret the document, yes.

Connor.
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 latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.