An Example of How Oracle Works
来源:互联网 发布:数据结构二维数组赋值 编辑:程序博客网 时间:2024/05/27 06:13
An Example of How Oracle Works
The following example describes the most basic level of operations that Oracle performs. This illustrates an Oracle configuration where the user and associated server process are on separate machines (connected through a network).
- An instance has started on the computer running Oracle (often called thehost or database server).
- A computer running an application (alocal machine or client workstation) runs the application in auser process. The client application attempts to establish aconnection to the server using the proper Oracle Net Services driver.
- The server is running the proper Oracle Net Services driver. The server detects the connection request from the application and creates a dedicated server process on behalf of the user process.
- The user runs a SQL statement and commits the transaction. For example, the user changes a name in a row of a table.
- The server process receives the statement and checks theshared pool for any shared SQL area that contains a similar SQL statement. If a shared SQL area is found, then the server process checks the user's access privileges to the requested data, and the previously existing shared SQL area is used to process the statement. If not, then a new shared SQL area is allocated for the statement, so it can be parsed and processed.
- The server process retrieves any necessary data values from the actual datafile (table) or those stored in the SGA.
- The server process modifies data in the system global area. The DBWn process writes modified blocks permanently to disk when doing so is efficient. Because the transaction is committed, the LGWR process immediately records the transaction in the online redo log file.
- If the transaction is successful, then the server process sends a message across the network to the application. If it is not successful, then an error message is transmitted.
- Throughout this entire procedure, the other background processes run, watching for conditions that require intervention. In addition, the database server manages other users' transactions and prevents contention between transactions that request the same data.
原文地址:http://docs.oracle.com/cd/B10501_01/server.920/a96524/c01_02intro.htm#41832
- An Example of How Oracle Works
- An example of how to do a simulation by LAMMPS
- How Synchronization works in Java ? Example of synchronized Block and Method
- How Volatile in Java works? Example of volatile keyword in Java
- an example of repeater
- How JavaScript works: an overview of the engine, the runtime, and the call stack
- 转 -- How Oracle Locking Works
- How Oracle Locking Works - First
- How Oracle Locking Works - Second
- an example of using automake.
- An Example of association query
- An example of responseXML.getElementsByTagName
- An example of using Thrift
- an example of enhancement framework
- An Entry Example of Log4j
- Ruby CSV - An example of how to split CSV row data into fields
- An example of how to streaming audio over network using Qt
- example of how this plant
- hdu 4417 线段树离线处理
- JSON字符串的在线检测工具网址
- Android AutoCompleteTextView实现历史记录
- mysql索引的类型和优缺点
- candence measure显示内容描述
- An Example of How Oracle Works
- const指针
- 其实我不懂C++
- 在ubuntu 8.10下安装thunderbird中文版
- android中的按键处理
- 程序员技术练级攻略
- 使用xib定制uitalbeViewCell 加载方式
- Linux下patch的制作和应用 (
- 快照更新延迟的原因是什么