Alter Table Move to Another Tablespaceby Ed ChenDecember 8, 2021June 30, 2022Move Table to Another Tablespace Basically, moving an Oracle table can defragment the data and make it compact so as to gain some benefit when… Read More »Alter Table Move to Another Tablespace
Alter Table Move LOB to Another Tablespaceby Ed ChenDecember 6, 2021December 21, 2022Move LOB Segment Whenever tablespace is crowded, the first thought in my mind is to move INDEX to another tablespace, because it's very flexible to… Read More »Alter Table Move LOB to Another Tablespace
Alter Index Rebuild to Another Tablespaceby Ed ChenDecember 3, 2021December 1, 2022Move Index To move an index is to rebuild a whole index either in the original tablespace or another tablespace with some options like ONLINE… Read More »Alter Index Rebuild to Another Tablespace
How RMAN Parallelism Worksby Ed ChenFebruary 15, 2021September 6, 2022RMAN Parallelism To backup the database with multithreads can considerably speed up the backup process as long as IO throughput is good enough to handle… Read More »How RMAN Parallelism Works
How to Gather Statistics on Database Level for Various Situationsby Ed ChenNovember 19, 2016December 14, 2021DBMS_STATS.GATHER_DATABASE_STATS We usually gather statistics of the database globally after data migration. The following examples are very practical in post-migration phase. Default You can do… Read More »How to Gather Statistics on Database Level for Various Situations