(Server=Dedicated) parameter in TNSNAMES.ORA file
Posted: Thu Jun 14, 2007 5:39 pm
Hi All,
We have a condition here in Data Stage 7.5.2 with server jobs.
Currently, we are using 9.2.0.8 oracle database had a performance issue.
One of the suggestions from IBM was to set the (Server=Dedicated) parameter in the TNSNAMES.ORA in the data stage server.
After setting up the parameter as suggested we got an excellent performance (almost 50 to 100% in some cases) in our server jobs. But the DBAs debate that the database has already been setup with the "Dedicated" option at the database level so this change should have not changed the performance rather something else in DataStage should have been changed. Is there any way to dispute their argument? Please let me know
Thanks,
Chandru
We have a condition here in Data Stage 7.5.2 with server jobs.
Currently, we are using 9.2.0.8 oracle database had a performance issue.
One of the suggestions from IBM was to set the (Server=Dedicated) parameter in the TNSNAMES.ORA in the data stage server.
After setting up the parameter as suggested we got an excellent performance (almost 50 to 100% in some cases) in our server jobs. But the DBAs debate that the database has already been setup with the "Dedicated" option at the database level so this change should have not changed the performance rather something else in DataStage should have been changed. Is there any way to dispute their argument? Please let me know
Thanks,
Chandru