Alter Table Move to Another Tablespace
Move 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
Degree of Parallelism (DOP)
Alter Table Move LOB to Another Tablespace
Move 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 Tablespace
Move 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 Works
RMAN 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 Situations
DBMS_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