Convert Oracle Dedicaded to shared server

Converting Oracle database connection mode from Dedicated mode to Shared mode within Oracle Database 19c using DBCA.

Step 1: Configure an existing database.

Step 2: Choose the database.

Step 3: I have specified 30 process as shared servers.

Step 4: The database need Reboot.

Step 5: Check Oracle Parameter:

SQL>  show parameter shared_servers
NAME TYPE VALUE
max_shared_servers integer
shared_servers integer 30

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.