Database Tuning (MOSC)

MOSC Banner

12.1.0.2 Windows 64Bit Standard Edition slower than 12.1.0.1

edited Sep 23, 2016 6:09PM in Database Tuning (MOSC) 11 commentsAnswered

I am currently testing the 12.1.0.2 Windows 64Bit Standard Edition Two, installed with the latest patchset 23530387.

I compare the tests with version 12.1.0.1 on the same server. Both databases use the same settings and the same test data. On each database one user on a different client computer executes scripts of commands.

The overall performance of 12.1.0.2 is worse than the version 12.1.0.1. As it is only one user it cannot be the new restriction of max. 16 threads contemporarily executed.

- Standard optimizer settings used:

-> Up to 50 % slower

- Switch off features:  alter session set optimizer_adaptive_features=false;  and alter session set optimizer_dynamic_sampling=0;

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