Server processes

最新推荐文章于 2024-09-04 09:34:26 发布

转载最新推荐文章于 2024-09-04 09:34:26 发布 · 162 阅读

本文详细解析了服务器进程如何代表用户的每个应用程序执行任务，包括解析和运行通过应用程序发出的SQL语句，从磁盘上的数据文件读取必要的数据块到SGA的共享数据库缓冲区中，以及返回结果以便应用程序能够处理这些信息。

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15116811/viewspace-594826/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15116811/viewspace-594826/