Database Tuning (MOSC)

MOSC Banner

How to verify a thread limit bottleneck for 12.1.0.2.0 Standard Edition

edited Jun 2, 2017 11:08AM in Database Tuning (MOSC) 10 commentsAnswered ✓

Hello,

we have a new DB-Server (12.1.0.2.0 Standard Edition) with 128Gbyte Ram and the complete database is nearly hold 100% in memory. Disk access is very very low.

Unfortanly the performance is much more less we expected than our old DB-Server (11g) with 32 Gbyte Ram.

Our partner who sells us the system was talking we never had performance issues. But we have.

After reading i found the point that 12c Standard limits the threads to 16. If i look on the Server (Win 2012) CPU is average >50% usage.

But in the Express Monitor i have ~90% CPU Usage, other is User IO an nearly no waits.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center