How to get rid of huge diag file and why occurred
713555Apr 17 2012 — edited Apr 17 201211.2.0.2.0 windows 2008 2 node RAC.
In my diag/trace I have a diag file 20gb in size. Nothing is currently writing to it as its been a static size for some time. However, the Oracle server PID itself has a lock on it so I cant delete it. (procexp > handle find)
If this was linux I know a way but Im unable to delete or echo blank to it to wipe it in windows.
How did this get there? dont know. there is a bug on oracle about large diag files which was supposed to have been fixed after 11.1.0.7
Large Amount of Trace Information Written to DIAG Trace Files [ID 750773.1]
I dumped system system events with oradebug and queried all open events with dbms_system.read_ev but nothing is reported to be running.
thoughts on how to remove and why it occurred? I would rather remove online but can bring the instance later tonight so not too bothered but it would be nice to know how to remove it if I was in an urgent situation and needed that space.
Edited by: deebee_eh on 17-Apr-2012 07:38