-
编辑 删除
alter index unusable无法起作用的情况
SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdPL/SQL Release 10.2.0.1.0 - Productio...
-
编辑 删除
dbms_shared_pool.purge
在日常管理中,经常有让sql重新解析的需求,比如说使用了bind peeking,第一次绑定特定值的时候执行计划走的特别糟,因为绑定变量导致之后的语句不作重新解析,重用了最差的执行计划,这时候我们希望重新解析来得到一个相...
-
编辑 删除
parameter pre_page_sga
PRE_PAGE_SGA can increase the process startup duration, because every process that starts must access every page in the SGA. The cost of this strategy is fixed; however, you might simply determine tha...
-
编辑 删除
(tips) 10g log buffer
The LOG_BUFFER size will be set by default, by Oracle internal algorithm. In 10G R2, Oracle combines fixed SGA area and redo buffer [log buffer] together. If there is a free space after Oracle pu...
-
编辑 删除
rollback相关知识
1.defferred rollback:在前滚完成后,数据就open,而在open后做恢复a.smonb.user process 2.fast start parallel rollbackfast start parallel rollback主要是在宕机之前进行了大事务,使用并行回滚加快恢复...
