many large sid_p000n.trc

[big]

Hi,
on R12.2.9 DB 19c on AIX
On DB server we have many  large sid_p000n.trc files and ../../sid/sid/trace directory is saturated.

How can I find the reason?
How to know if any extra tracing is enabled?

Thank you.

[ErmanArslansOracleBlog]

Those may be doe to with enabled trace(s) or event(s)

Check and confirm if any events are set in the database by running the following;

DECLARE
l_level NUMBER;
BEGIN
FOR l_event IN 10000..10999
LOOP
dbms_system.read_ev (l_event,l_level);
IF l_level > 0 THEN
dbms_output.put_line ('Event '||TO_CHAR (l_event)||
' is set at level '||TO_CHAR (l_level));
END IF;
END LOOP;
END;
/


This issue is already documented, check -> Huge P000 Trace Files in trace dump directory (Doc ID 2347230.1)