Database Reference
In-Depth Information
The Oracle Database is encrypted or in other words we cannot
read the data files through any text editor like MS Word. Only
Oracle Server knows how to decrypt the information residing in
the database. That's why anything going into the database or
coming out from the database has to be through Oracle Instance.
Each connected user sends requests in the form of SQL
commands to Oracle Instance to retrieve information from
Oracle Database or to store information into the database.
How Oracle works?
The communication between Oracle and user takes place in a
fashion that first user has to establish a connection with Oracle
server (or more precisely oracle instance) by providing his/her
credentials (Username and password). Once verified Oracle
accepts the connection otherwise the connection request will get
rejected.
Figure 1-3: Oracle Instance ~ Users Interactions. Users send SQL
commands to the Genie. The Genie listens users from any corner of
globe as long as the communication language is SQL.
In Oracle world each connected user with oracle server is
considered as session. If there are three connected users with
Search WWH ::
Custom Search