Freitag, 18. November 2011

Different results in v$asm_operation views

During some performance tests, I was wondering why rebalancing of one out of two hard disks was extremely fast - in my opinion it was too fast.
After some headache I found out, that the rebalancing caused an entry in v$asm_operation view of ASM instance. The particular row was missing in v$asm_operation view of RDBMS instance.

Rule of thumb:
Be careful when querying dynamic performance views v$asm_%. Their content depends on the instance against which you are connected

Keine Kommentare:

Kommentar veröffentlichen