How to convert MTS to dedicated db
I would like to move a production db running on Oracle9i from MTS to dedicated since
1. Hit with an Oracle Bug and as per oracle support
2. No. of user session is only around 30+ anytime
This is what I did:
sql> alter system set dispatchers='' scope = both;
ORA-2065 alter system not allowed.
sql> alter system set shared_servers =0;
My understanding is if you set the shared_servers = 0 should disable MTS. But it did not happen. Also, Oracle documentation states to use the above commands and I still get the error.