Database Tuning (MOSC)

MOSC Banner

Cursor_sharing, can affect performance in anything be different in multiple instances of a single da

edited May 13, 2013 1:59AM in Database Tuning (MOSC) 6 commentsAnswered
 Hello dear all:

Does having an instance of the database with a different configuration,

mainly CURSOR_SHARING can affect performance somewhat?

eg X1 in Exact place and at Force x2 and x3 in Force, for example, place an instance of the database CURSOR_SHARING X1 equal to Exact, and other database instance CURSOR_SHARING X2 equals Force. And they're both bases in the same database server, use the same database engine.

Will it affect anything to the database engine, having different these values affects the performance of the database?

I appreciate your thoughtful comments.

Best regards!

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