Database Tuning (MOSC)

MOSC Banner

I am at a loss. a select on a view returns 82000 rows in 30 seconds but if i place insert before it

edited Feb 5, 2018 10:12AM in Database Tuning (MOSC) 23 commentsAnswered

returns 82000 rows in 30 seconds but if i place insert before it, it takes 15 minutes.  i ran sqlt xtract and what jumped out was that the insert appear to be processing a much higher number of rows.  the execution plan seems to be the same which is baffling.  i figure this to be a common process but have been unable to come up with an explanation from my research.  i am attaching info on the query and screenshots from the sqlt monitor report.  thanks in advance.  cheers

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