Database Administration (MOSC)

MOSC Banner

ora-02049

edited Jan 8, 2010 8:25AM in Database Administration (MOSC) 5 commentsAnswered
 Our CRM application is running the process that constantly showing ora-02049 locking error. When I searched online, it suggest to increase shared_pool_size. However, we use the sga_target and I believe it automatically assigns a value to shared_pool_size. In this case, do I need to increase the value of sga_target?

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