How Oracle Move LOB Column
Whenever tablespace is crowded, the first thought in my mind is to move INDEX to another tablespace, because it's very flexible to rebuild an index… Read More »How Oracle Move LOB Column
Degree of Parallelism (DOP)
How Oracle Move Index
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 »How Oracle Move Index
How RMAN Backup Parallelly
To backup the database with multithreads can considerably speed up the backup process as long as IO throughput is good enough to handle high volume… 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