Hello Friends,

Welcome you back on exciting topic, today’s session is on

CPT 4: Connecting to the Database Instance –
--- Dedicated Server process
--- Shared Server Process

1. Dedicated server connection – 1 to 1 connection
2. Shared server connection – 1 to Many connection
3. Tnsnames.ora file defines whether connection is dedicated or shared
(SHARED = SHARED) or
(SHARED=DEDICATED)
4. At database level we can check using v$sessions
select sid, server from v$session;

#ServerProcess #Dedecated #Shared #tnsnames #listener #Connection #oracle #database #Instance #architecture #databaseadministration #dba #RAC

Please do follow me and support me on,

LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg


Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Email: [email protected]
LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg