Buffer Cache Flushing
作者:Fenng
出处:http://www.dbanotes.net
日期:December 20, 2004
« Oracle 10gR2 会有什么新特性? | Blog首页 | Oracle Wait Interface: V$EVENT_NAME »
Oracle 10g 提供了一条命令，不用关闭实例即可清空 Buffer Cache 区。
提交如下命令即可:
SQL>Alter system flush buffer_cache;
该命令的用处，嗯，唯一的用处可能在于给 DBA 一个一致的 SQL 优化环境，而不需要重新启动数据库。产品库上会有人用么?
Oracle 10g 上类似的没什么大用处的“新特性”着实不少。
Posted by Fenng at December 20, 2004 02:05 PM
Last updated at 06:19 PM on August 20, 2005
相关文章：
- 免费的Oracle Database 10g XE - Oct 29, 2005
- Install Oracle 10g on SuSE 10 - Sep 17, 2005
- OCFS2 - Aug 13, 2005
Trackback Pings
TrackBack URL for this entry:
http://www.dbanotes.net/mt/mt-tb.cgi/20
Listed below are links to weblogs that reference Buffer Cache Flushing:
» desert eagle airsoft gun from desert eagle airsoft gun
[Read More]
Tracked on April 13, 2007 07:34 AM
» police riot from police riot
shit-happens 3517156 Of police riot and more [Read More]
Tracked on June 17, 2007 10:29 PM
» long nia from long nia
shit-happens 3517156 Reviews on long nia. [Read More]
Tracked on June 25, 2007 10:24 AM