ODAC Oracle DEDICATED Server slow down problem
Posted: Fri 20 Apr 2007 12:46
Dear CRLAB-Support,
-ODAC 5.80.0.40 with NET-OPTION
-Delphi 5
With the Oracle 8.1.7 server version, our ODAC based program works just
fine.
With the Oracle 9.2.0 server version sometimes we have havy slow downs.
Our RDBSM support team suggested that we enter into the local tnsnames.ora file in the "CONNECT_DATA" section the "(SERVER = DEDICATED)" parameter, and it will work fine too. Like:
sid =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = port))
)
(CONNECT_DATA =
(SID = sid)
(SERVER = DEDICATED)
)
)
If we connect without the "NET-OPTION" parameter than tnsnames.ora is
not used, so we have to solve this in the ODAC component.
Our question would be, that how can the TOraSession with NET-OPTION be accessible so we can pass this parameter to the Oracle Session.
Could you please check that and give me response as fast as possible?
Thank you for your efforts.
-ODAC 5.80.0.40 with NET-OPTION
-Delphi 5
With the Oracle 8.1.7 server version, our ODAC based program works just
fine.
With the Oracle 9.2.0 server version sometimes we have havy slow downs.
Our RDBSM support team suggested that we enter into the local tnsnames.ora file in the "CONNECT_DATA" section the "(SERVER = DEDICATED)" parameter, and it will work fine too. Like:
sid =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = port))
)
(CONNECT_DATA =
(SID = sid)
(SERVER = DEDICATED)
)
)
If we connect without the "NET-OPTION" parameter than tnsnames.ora is
not used, so we have to solve this in the ODAC component.
Our question would be, that how can the TOraSession with NET-OPTION be accessible so we can pass this parameter to the Oracle Session.
Could you please check that and give me response as fast as possible?
Thank you for your efforts.