Table size 3.x Gb during my alter table shrink space compact, the redo log size is about 13Gb.
Be careful if the archived log space is too small.
Popular Posts
-
Being a DBA or system administrator, simple ENTER may bring us into a nightmare. It is unavoidable, however what we can do is to prevent ...
-
Database audit records for statement, privilege, and object auditing are stored in the table SYS.AUD$. Depending on how extensive your audit...
-
got two useful articles about compression. Marked here 11g Release 2 RMAN Backup Compression Oracle 11g Release 2 – RMAN compressi...
-
--to use AWR http://www.dbapool.com/articles/061906.html --to check AWR retention select * from DBA_HIST_WR_CONTROL; --to estimate AWR size ...
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
Organize a chart based on below full list of backup information. Note that if BACKUP OPTIMIZATION is turned on , the seeds files then... -
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...
-
This is useful. find /share/Multimedia/ –name *.m4a | while read foo; do rm “$foo” ;done https://www.ripcaster.co.uk/node/772
-
/etc/fstab内容主要包括六项： 例如：打印出中间的两行内容，如下 LABEL=/ / ext3 defaults 1 1 /dev/sda2 /mnt/D/ vfat defaults 0 0 第 ...
