Yong Huang 发表于 2011-10-28 22:52
If it's a simple select * from table, the data goes straight to the client. If the SQL has some inte ...
Yong Huang 发表于 2011-10-31 23:39
> 游标中会保存查询结果集的rowid信息,而结果集所需要的数据块被载入到了SGA中
Of course the data blo ...
Yong Huang 发表于 2011-11-2 00:01
It's quite common to have more data fetched than the SGA (buffer cache) can hold. Oracle simply send ...
欢迎光临 ITPUB论坛-专业的IT技术社区 (http://www.itpub.net/) | Powered by Discuz! X3.2 |