OracleRAC & ASM
ASM rebalance progress
Rebalance operations in flight with power level and estimated minutes left. No rows means nothing is rebalancing.
Not yet verified. How scripts are tested
1CLEAR COLUMNS2SET LINESIZE 120 PAGESIZE 100 TRIMOUT ON TAB OFF3COLUMN diskgroup HEADING "DISK GROUP" FORMAT A124COLUMN operation FORMAT A95COLUMN pass FORMAT A106COLUMN state FORMAT A57COLUMN power FORMAT 99908COLUMN sofar FORMAT 999,999,9909COLUMN est_work HEADING "EST WORK" FORMAT 999,999,99010COLUMN est_minutes HEADING "EST MIN" FORMAT 99,99011 12SELECT g.name AS diskgroup, o.operation, o.pass, o.state, o.power,13 o.sofar, o.est_work, o.est_minutes14FROM v$asm_operation o15JOIN v$asm_diskgroup g ON g.group_number = o.group_number;Save it as ora-asm-rebalance.sql and run it with SQL> @ora-asm-rebalance.
More Oracle scripts: RAC & ASM
- Stop, start and check a RAC database (srvctl)Clusterware commands to stop the database, start it read-only, check its status, and start a single instance in MOUNT mode. Run one line at a time;…
- ASM disk group spaceSize, free and usable space per disk group. Usable GB already accounts for mirroring, so it's the number to alert on. Works from the ASM or database…
- ASM disks and their statusEvery disk ASM can see, including CANDIDATE disks not yet in a group. Check MODE and STATE after storage maintenance.
- Sessions per instance and serviceHow connections are spread across RAC nodes and services. A lopsided spread usually means a service isn't running where you think it is.
- Global cache (interconnect) waits by instanceCluster-class waits per instance since startup. High average times on gc cr or gc current events point at the interconnect or at hot blocks shared…
- Cluster status commands (srvctl and crsctl)The Clusterware commands for checking a RAC database, its services and every cluster resource.