Database Tuning (MOSC)

MOSC Banner

cursor: mutex S wait

edited Jan 26, 2017 4:00AM in Database Tuning (MOSC) 5 commentsAnswered

Hello,

The application running insert statement (using values) to big table with hundreds of columns from 5 different connections

and this cause conncurrency (cursor: mutex S wait). there are many child cursors (according to v$sql_shared_cursor)

for the insert sql_id (the reason is BIND_LENGTH_UPGRADEABLE)

Is there a way to decrease the wait event (cursor: mutex S wait) and improve performance?

cursor_sharing set to exact.

Version:  11.2.0.1.0

Many Thanks in Advance,

Galit.

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