Amazon books

Tuesday, November 10, 2009

Close trace that has been removed to free up space on operational system

--You have killed a session that was generating big trace file and deleted the file but the space wasn't freed

Fisrt, you need to get the spid using the query bellow or use the name of trace file that has this number:

select
p.spid
from
v$process p,
v$session s
where
p.addr=s.paddr
and
s.sid=;


Then, you will use oradebug to close the trace
oradebug setospid
oradebug close_trace

This operation will close the trace file removed and thus freeing up space on your OS.

Best Regards,
Paulo Portugal

No comments:

Post a Comment