Friday, March 16, 2012

INSERT INTO wrh$_tempstatxs () - is pseudo AWR bug

In addition to my previous AWR bugs post.

The new database in Exadata. No any workload.
This Insert was executed on both nodes of cluster during 3 minutes each (history from bottom to top):


DBControl shows one Insert into WRH$-tempstatxs, which is the part of AWR:


I decided to gather some add statistics - for dictionary and for fixed views as I did it last time, but bad Insert appears soon after my statistics gathering. You see it in both screenshots.

The solution was found by chance - after db restart bad Insert disappeared forever.

1 comment:

  1. And another workarounds may be found in Bug 13257247 - AWR Snapshot collection hangs due to slow inserts into WRH$_TEMPSTATXS )

    ReplyDelete

cellcli -e list diskmap

The interesting LIST DISKMAP command in the storage cells links all views to hard disks: PCI bus address as Name 252:5, OS name (/dev/sdh,...