Alert & Trace files - Monitor

Monitoring Alert and Trace Files

 # to obtain the Location of Trace Files
 column NAME format a35
 column VALUE format a35
 select name, value from v$parameter
 where name in ('background_dump_dest','user_dump_dest')
# to set maximum size of trace files (excluding the alert file)
# in number of block unless you sepcify K or M
select * from v$parameter where upper(name )= 'MAX_DUMP_FILE_SIZE'
alter session set MAX_DUMP_FILE_SIZE='100M'