Rman backup retention policy
There are two mutually exclusive options for implementing a retention policy: redundancy and recovery window. If no retention policy is configured by the user, then the REPORT OBSOLETE andDELETE OBSOL...
explain plan
http://www.start0.net/blog/post/304.html explain
Oracle Memory Structures
Oracle 在内存中存储以下信息: 1.程序代码 2.已连接的会话(session)信息,包括当前活动的(active)及非活...
rebuild index online or offline
When you rebuild index online,- it will do a full tablescan on the base table.- At the same time it will maintain a journal table for DML data, which has changed during this index rebuilding operation...