Translate into your own language

Thursday, April 28, 2016

Step by step --- How a user connect to the Oracle database

1. A user requests a connection to the Oracle database through his login credenital.

2. This login credential is accepted by listener on the server side and then listener hand over the login details to PMON background process.

3. PMON checks the autheticity of the user in the data dictionary cache of the Shared pool area. If the detail of user is found in the data dictionary then PMON creates a server process and allocate a memory area PGA to that user. And sends acknowlegement for successfull connection to user.

4. If PMON does not find the detail in the data dictionary cache, it checks in the datafiles and if details found a copy of that is placed in the data dictionary cache and user is acknowleged  for successfull connection.

5. If details are not found in the datafile also then PMON sends acknowledgement of unsuccessfull connection to user.

No comments:

Post a Comment