首页 > IT基础架构 > 网络安全 > Server Processes (112)

Server Processes (112)

原创 网络安全 作者:tsinglee 时间:2007-10-30 12:26:37 0 删除 编辑

Oracle creates server processes to handle the requests of user processes connected to
the instance. In some situations when the application and Oracle operate on the same
computer, it is possible to combine the user process and corresponding server process
into a single process to reduce system overhead. However, when the application and
Oracle operate on different computers, a user process always communicates with
Oracle through a separate server process.
Server processes (or the server portion of combined user/server processes) created on
behalf of each user’s application can perform one or more of the following:
■ Parse and run SQL statements issued through the application
■ Read necessary data blocks from datafiles on disk into the shared database buffers
of the SGA, if the blocks are not already present in the SGA
■ Return results in such a way that the application can process the information

1. 解析运行SQL语句
2. 将数据块从SGA读取到shared database buffers
3. 返回应用程序能处理的信息


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量