Size of oracle Control File

Size of control files

SYS@orcl> select sum((cffsz+1)*cfbsz)/1024/1024 "Control File Size(MB)" from x$kcccf;

Control File Size(MB)
---------------------
20.203125

How to stop oracle Trace ?

Stop trace dump


1. Get the process number from trace file.

Example :
-rw-rw—- 1 dba 184034 Jan 29 17:02 test_diag_17701.trc

2. 18701 is the process number from trace file.

SQL> oradebug setospid 17701
Oracle pid: 3, Unix process pid: 17701,

SQL> oradebug close_trace;
Statement processed.