How to know/check our database server is
configured as Dedicated server?
Follow the below steps to check whether database is configured as Dedicated server or not.
1. Select username, server from v$session ;
2. Select * from v$dispatcher;
3. Go to $ORACLE_HOME/dbs and open init.ora(pfile/spfile) and find the variable DISPATCHERS
4. Finally open the tnsnames.ora file and find parameters of each database. This will forcibly make db to run in dedicated server mode.
Results:
1. Select username, server from v$session ;
USERNAME SERVER
------------------------------ ---------
USER3 DEDICATED
USER1 DEDICATED
USER2 DEDICATED
USER1 DEDICATED
USER1 DEDICATED
2. Select * from v$dispatcher;
no rows selected
3. DISPATCHERS = '(ADDRESS=(PROTOCOL=TCP)(HOST=accountmgt.tntt.com)(PORT=1524))'
4.database_1 = (description=(address=(host=amaze.tntt.com)(protocol=tcp)(port=1521))(connect_data=(sid=database_1)(server=dedicated)))
Conclusion:
Even though/not the output from 2,3 indicate MTS server config params, we should consider output of 1,4 and can say that database is in dedicated server mode. Why because server=dedicated param indicate the database to be in dedicated mode forcibly ignoring rest of config setting.
Follow the below steps to check whether database is configured as Dedicated server or not.
1. Select username, server from v$session ;
2. Select * from v$dispatcher;
3. Go to $ORACLE_HOME/dbs and open init.ora(pfile/spfile) and find the variable DISPATCHERS
4. Finally open the tnsnames.ora file and find parameters of each database. This will forcibly make db to run in dedicated server mode.
Results:
1. Select username, server from v$session ;
USERNAME SERVER
------------------------------ ---------
USER3 DEDICATED
USER1 DEDICATED
USER2 DEDICATED
USER1 DEDICATED
USER1 DEDICATED
2. Select * from v$dispatcher;
no rows selected
3. DISPATCHERS = '(ADDRESS=(PROTOCOL=TCP)(HOST=accountmgt.tntt.com)(PORT=1524))'
4.database_1 = (description=(address=(host=amaze.tntt.com)(protocol=tcp)(port=1521))(connect_data=(sid=database_1)(server=dedicated)))
Conclusion:
Even though/not the output from 2,3 indicate MTS server config params, we should consider output of 1,4 and can say that database is in dedicated server mode. Why because server=dedicated param indicate the database to be in dedicated mode forcibly ignoring rest of config setting.
No comments:
Post a Comment