Oracle 11.2.0.2 SE-One
ASM 11.2.0.2
Oracle Linux 5.6 x86-64
Every morning at 0600 I run a report that includes this query:
asmcmd lsdg | awk '{print $13 " " $2 " " $7 " " $8 " " $10 }' >> $logfile
Normally I will see a very slight decrease in "free" and "usable" over the course of a week or so. This is a DW app, so data constantly goes in but rarely leaves, but the system in question is the test system. It gets refreshed from prod via an rman duplicate on the weekend but typically that is the only time this system would show any changes.
But this morning I saw a distinct drop in 'usable'. That was unusual in and of itself, but there was no correlating drop in 'free', which I find very puzzling.
Yesterday's report had this:
Name Type Total_MB Free_MB Usable_file_MB
DEV_LARGE/ EXTERN 972800 439422 439422
DEV_SMALL/ EXTERN 307200 44301 44301
LARGE/ EXTERN 972800 247864 247864
SMALL/ NORMAL 920308 271714 81508
And today I have
Name Type Total_MB Free_MB Usable_file_MB
DEV_LARGE/ EXTERN 972800 439422 439422
DEV_SMALL/ EXTERN 307200 44301 44301
LARGE/ EXTERN 972800 247864 247864
SMALL/ NORMAL 920308 271714 81508
Notice the change in the fourth DG -- "SMALL"
FWIW, between these two reports I installed PSU 11.
So I'm trying to determine
1 - the cause of the abnormal drop in 'usable' space on the DB, and
2 - why the drop in 'usable' was not also reflected in 'free'.