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
-
http://msdn2.microsoft.com/en-us/library/ms681381.aspx
-
when the SATA contorl mode =IDE 2 HDD, 1 SSD and 1 DVD ROM After change the mode to ACHI Notice the sequence c... -
This is useful. find /share/Multimedia/ –name *.m4a | while read foo; do rm “$foo” ;done https://www.ripcaster.co.uk/node/772
-
On the server vi /etc/exports add lines like: /data1/sessions 192.168.0.0/255.255.0.0(rw) 10.0.0.0/255.0.0.0(rw) vi /etc/hosts.allow add...
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
--to use AWR http://www.dbapool.com/articles/061906.html --to check AWR retention select * from DBA_HIST_WR_CONTROL; --to estimate AWR size ...
-
find a useful link http://www.codecrete.net/UnwrapIt/, helped to see what is inside the hotfix in .plb format. With this we are have a bit...
-
The DBWn background process writes to the datafiles whenever one of the following events occurs: A user’s Server Process has searched too ...
-
2nd round to migrate this CentOS after I bought a 3TB HDD, on top of one 120GB SSD, one 1TB and one 2TB HDD. Now I want to decommission the...