It is auto tuned by Oracle, if it is the retention is set to 0.
https://community.oracle.com/thread/833573?tstart=0
Popular Posts
-
Upgraded to Ubuntu 15.10 from 15.10, resolved blank screen by playing with gdm/lightdm. Finally lightdm is my choice, which works with the v...
-
when running "backup filesperset 10 archivelog all not backed up 2 times;", encountered below error : channel ORA_DISK_1: starti...
-
CRS-5019:All OCR locations are on ASM disk groups [DATA], and none of these disk groups are mounted.In my case , from ASM alert.log , actually it is due to ASM failed to start because of ORA-00600 as shown below. ORA-0060...
-
got two useful articles about compression. Marked here 11g Release 2 RMAN Backup Compression Oracle 11g Release 2 – RMAN compressi...
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
brrestore We had problem with brrestore, have to follow up tomorrow. BR0374E 0 of 1 file restored by backup utility BR0280I BRRESTORE time s...
-
--to use AWR http://www.dbapool.com/articles/061906.html --to check AWR retention select * from DBA_HIST_WR_CONTROL; --to estimate AWR size ...
-
Security related values in the 12c SYS.USER$ table are CTIME: Date & Time when user was created PTIME: Date & Time when user pas...
-
Quest Toad and Alternatives http://yong321.freeshell.org/oranotes/ToadAndAlternatives.html#ToadAlternatives
-
五年前，在英国之外没人听说过ITIL。现如今，拿起任何一本贸易杂志，就会发现有人提到这个名词。但尽管人们大肆宣传ITIL，许多IT专业人士并不完全了解ITIL到底指的是什么。下面是对它的一些主要介绍。 1：ITIL代表信息技术基础构架库 ITIL包括一组用来开发并执行IT服务管理...
