HOW TO CHECK INDEX FRAGMENTATION. When a database is frequently updated via UPDATE, or DELETE statements we can expect it to become fragmented over the time. If database indexes are fragmented, the SQL query optimizer may chose a non-optimal execution plan when using an index to… Read More
1. Backup the current Stats For Database stats: SQL> Exec dbms_stats.export_database_stats(statown => ‘SYSTEM’, stattab => ‘prod_stats_database_03282018’); For System stats: SQL> Exec dbms_stats.export_SYSTEM_stats(statown => ‘SYSTEM’, stattab => ‘prod_stat_system_03282018’); For Dictionary stats: SQL> Exec dbms_stats.export_Dictionary_stats(statown => ‘SYSTEM’, stattab => ‘prod_stats_dictionary_03282018’); For Fixed Tables stats: SQL> Exec dbms_stats.export_FIXED_OBJECTS_stats(statown… Read More
Rename Disk Label for reallocating disks from one diskgroup to other diskgroup Before : login as sysasm :
|
1 2 3 4 5 6 7 8 9 |
NAME ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB PCT_FREE ------------------------------ -------------------- ----------- ------ ---------- ---------- ---------- FRA01 1048576 CONNECTED EXTERN 1024000 517938 50.5798828 DATA01 1048576 CONNECTED EXTERN 17408000 11416800 65.5836397 SQL> alter diskgroup DATA01 drop disk PROD_TEST_DATA01_79,PROD_TEST_DATA01_80,PROD_TEST_DATA01_81,PROD_TEST_DATA01_82,PROD_TEST_DATA01_83,PROD_TEST_DATA01_84,PROD_TEST_DATA01_85 REBALANCE POWER 11; Diskgroup altered. |
Wait till rebalnce completes.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
[root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_79 PROD_TEST_FRA01_06 Renaming disk "PROD_TEST_DATA01_79" to "PROD_TEST_FRA01_06": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_80 PROD_TEST_FRA01_07 Renaming disk "PROD_TEST_DATA01_80" to "PROD_TEST_FRA01_07": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_81 PROD_TEST_FRA01_08 Renaming disk "PROD_TEST_DATA01_81" to "PROD_TEST_FRA01_08": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_82 PROD_TEST_FRA01_09 Renaming disk "PROD_TEST_DATA01_82" to "PROD_TEST_FRA01_09": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_83 PROD_TEST_FRA01_10 Renaming disk "PROD_TEST_DATA01_83" to "PROD_TEST_FRA01_10": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_84 PROD_TEST_FRA01_11 Renaming disk "PROD_TEST_DATA01_84" to "PROD_TEST_FRA01_11": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_85 PROD_TEST_FRA01_12 Renaming disk "PROD_TEST_DATA01_85" to "PROD_TEST_FRA01_12": [ OK ] |
Please perform “ asm scan” command on other nodes which exists in the cluster : … Read More
