Cursor_sharing, can affect performance in anything be different in multiple instances of a single da
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!
1