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