[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
dbcheck.pl undo tablespace and memory check
- To: hobbit (at) hswn.dk
- Subject: dbcheck.pl undo tablespace and memory check
- From: thorsten.erdmann (at) daimler.com
- Date: Mon, 22 Feb 2010 14:51:07 +0100
- Encrypted: No
I use the hobbit extension script dbcheck.pl for checking my oracle
databases. Now for the first time one of my databases gets a tablespace
full warning on the undo tablespace. dbcheck.pl says undotablespace is
filled up to 99%. But Enterprise Manager says it's only 75%.
Further analysis shows that indeed dba_free_space is up to 99%. As I
understand this, it does not make sense to check dba_free_space for undo
tablespaces because dba_free_space only shows the free data at the end of
a datafile, not the free blocks in the middle of the files (maybe this is
also tru with tablespaces containing BLOBs).
So I think it would be more sensefull to ignore undo tablespaces in the
tablespace check, therefor dbcheck has the undo-check. How can I filter
out all the undo tablespaces without knowing their exact names in general.
BTW: in the graph section of the tablespace-checks the undo tablespaces
are missing already, why?
Another problem is the MemReq-check. It shows the sum of all errors since
the beginning of time. I think this is more a database issue, but how can
I clear the counter if I think I have repaired the cause?
If you are not the intended addressee, please inform us immediately that you have received this e-mail in error, and delete it. We thank you for your cooperation.