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
(Server=Dedicated) parameter in TNSNAMES.ORA file
Moderators: chulett, rschirm, roy
Did you change anything else in your jobs or environment for this? If all you did was set this option in your tnsnames file and saw an immediate change, I don't see how they can assert that had 'already been setup' at the database level and it must be a DataStage thing.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The entry in tnsnames.ora instructs the client connection - irrespective of the actual client tool - to make use of the Dedicated features. Presumably its absence instructs the client connection not to make use of the said features.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 73
- Joined: Tue May 10, 2005 6:21 pm
- Location: Sydney
Re: (Server=Dedicated) parameter in TNSNAMES.ORA file
In my opinion, (SERVER = DEDICATED) should be there in the TNSNAMES.ORA if the database is set up with DEDICATED Server option.
It doesn't affect anything to add that parameter into the TNSNAMES.ORA if it's not there.
It doesn't affect anything to add that parameter into the TNSNAMES.ORA if it's not there.
dwuser wrote: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
Edward Yuan