You can have both DEDICATED and SHARED connections concurrently.
Some environments with SHARED Servers also use DEDICATED connections for
Administrative jobs or Long Running Batch Jobs.
Read up on the "SERVER=DEDICATED" parameter that can be
specified in the client-side TNSNAMES.ORA file.
Hemant
At 07:18 PM Tuesday, you wrote:
than cheng. You are right i can
check if the system supports shared server or not but my main question is
to find the mode(shared/dedicated) for the database. Say DB1 is up and
running and i just have to decide the mode of the database is the db is
in :
1) archive /no archive log mode -- quite easy to check and i have
2) dedicated/shared --- confused for how to check this one
Hemant K Chitale
http://web.singnet.com.sg/~hkchital
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 17 2006 - 08:34:13 CST