Issue after oracle database 11g to oracle 12.2 migration facing major performance issue?
up vote
0
down vote
favorite
We are done recently database migration oracle 11g to oracle 12.2c. After migration facing huge performance issue in oracle 12.2c database. But if we set alter session set optimizer_features_enable="11.2.0.3"; then performance fast. Here i have doubt why it's taking so much time higher version (optimizer_features_enable="12.2.0.1).
What we need to check for this parameter. Please suggest us?
oracle12c
asked yesterday
srinu nivas
35
add a comment |
up vote
0
down vote
favorite
We are done recently database migration oracle 11g to oracle 12.2c. After migration facing huge performance issue in oracle 12.2c database. But if we set alter session set optimizer_features_enable="11.2.0.3"; then performance fast. Here i have doubt why it's taking so much time higher version (optimizer_features_enable="12.2.0.1).
What we need to check for this parameter. Please suggest us?
oracle12c
asked yesterday
srinu nivas
35
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
We are done recently database migration oracle 11g to oracle 12.2c. After migration facing huge performance issue in oracle 12.2c database. But if we set alter session set optimizer_features_enable="11.2.0.3"; then performance fast. Here i have doubt why it's taking so much time higher version (optimizer_features_enable="12.2.0.1).
What we need to check for this parameter. Please suggest us?
oracle12c
asked yesterday
srinu nivas
35
We are done recently database migration oracle 11g to oracle 12.2c. After migration facing huge performance issue in oracle 12.2c database. But if we set alter session set optimizer_features_enable="11.2.0.3"; then performance fast. Here i have doubt why it's taking so much time higher version (optimizer_features_enable="12.2.0.1).
What we need to check for this parameter. Please suggest us?
oracle12c
oracle12c
asked yesterday
srinu nivas
35
asked yesterday
srinu nivas
35
asked yesterday
srinu nivas
35
asked yesterday
srinu nivas
35
asked yesterday
srinu nivas
35
35
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53203666%2fissue-after-oracle-database-11g-to-oracle-12-2-migration-facing-major-performanc%23new-answer', 'question_page');
}
);
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
