SQL Performance (MOSC)

MOSC Banner

Frequent parse error for sql running in parallel mode

edited Dec 5, 2019 5:53PM in SQL Performance (MOSC) 5 commentsAnswered

Hello experts,

                       I have been observing frequent parse error for a specific SQL which is executed from an application job.This parse error is flooded in database alert log and I can see the same in diag trace files of huge size.When I start looking into trace file I see most of the time it is waiting for 'Cursor pin S wait on x ' event and one parallel slave is blocking other parallel slave.For example below is a snap from diag trace file.

Oracle session identified by:

{

instance: 1 (mdmp2.mdmp2)

os id: 34783

process id: 1344, oracle@mdmprod2 (P032)

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