SQL Performance (MOSC)

MOSC Banner

11.2.0.4 inserts

edited Aug 10, 2015 2:30PM in SQL Performance (MOSC) 5 commentsAnswered

Simple insert test runs consistently in 18s in 11.2.0.2 (on old hardware).

On my shiny new 11.2.0.4 the same job runs in 28s.  (faster hardware)

I'm just wondering, in general, if this has been observed by others.

All the time is spent in CPU, but the CPU is < 1% used.   This seems like a bug to me.

I have an SR, but nothing good happening there so far, but it's early. 

Thanks for your helpful comments.

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