Books for you

The uncommitted transactions are determined
after the redo log is applied and automatically rolled back.
Accessing a Database
The previous sections described the process of starting up and shutting down a database.
But the database is only part of a complete system??”you also need a client
process to access the database, even if that process is on the same physical machine
as the database.
Server Processes and Clients
To access a database, a user connects to the instance that provides access to the
desired database. A program that accesses a database is really composed of two distinct
pieces??”a client program and a server process??”that connect to the Oracle
instance. For example, running the Oracle character-mode utility SQL*Plus involves
two processes:
??? The SQL*Plus process itself, acting as the client
??? The Oracle server process, sometimes referred to as a shadow process, that provides
the connection to the Oracle instance
Server process
The Oracle server process always runs on the computer on which the instance is running.


Pages:
150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174