Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

After upgrade to 19.5, a statement that runs 'normally' in 12.1 and 18.5 now is running with what I

edited Dec 19, 2019 9:23PM in Database Install/Upgrade/Opatch (MOSC) 8 commentsAnswered ✓

After upgrade to 19.5, a statement that runs 'normally' in 12.1 and 18.5, now creates multiple sessions on the database and appears to be running in parallel.

The execution plan indicates this.  I didn't change any parameters between the upgrade from 18.5 to 19.5.  Any idea why it would behave like this now?

Is parallelism turned on by default?

I found a command to run - alter session disable parallel query, and now the statement runs in one session, and takes about 4 minutes compared to 8 with all the extra sessions running in parallel.

I need to make the behaviour work like it did in 18.5.  Does anybody  know what changed?

Tagged:

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