How Oracle Move Table to Another Tablespace
Alter Table Move Tablespace Basically, moving an Oracle table can defragment the data and make it compact so as to gain some benefit when performing… Read More »How Oracle Move Table to Another Tablespace
Degree of Parallelism (DOP)
How Oracle Move LOB to Another Tablespace
Alter Table Move LOB Whenever tablespace is crowded, the first thought in my mind is to move INDEX to another tablespace, because it's very flexible… Read More »How Oracle Move LOB to Another Tablespace
How Oracle Move Index to Another Tablespace
Alter Index Rebuild Tablespace To move an index is to rebuild a whole index either in the original tablespace or another tablespace with some options… Read More »How Oracle Move Index to Another Tablespace
How RMAN Backup Parallelly
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 Backup Parallelly
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