Hi kids;
OS=NT
Oracle= ver 8.1.6.1.0
Well here is a strange problem that has been going on in one of our development instances for a couple of weeks.
It started when I tried to run one of my usual scripts that looks at free space. I have since narrowed it down to 2 main problems.
If I try to run ...
SELECT COUNT(*) FROM DBA_FREE_SPACE
the session will just hang, this does not happen in any other instance we have. Also, if I log into OEM everything is ok unless I click on "datafiles" or "tablespace" located under "storage", in either case OEM will hang and I have to kill the session.
To further complicate this we also have 5 other instances on the same box sharing the same oracle_home and they do not have this problem.
Anyone have any advice on this one?
Thanks in advance.
MH
I remember when this place was cool.