I am junior oracle DBA.
Please suggest that "How to decie required how much limit rquire to MAX_DUMP_FILE_SIZE". I understood , default size of MAX_DUMP_FILE_SIZE is unlimited.
But, I receiving mails from application team,how much require. for example 5M or 20M etc..
Please suggest any one how to confirm limit. ORACLE VERSION IS 11.2
what is the average size of trace files you have ?
3 MB size of files existed in this file system.
how many trace files are generated per day or week ?
10-15 Files per week
what is the free space on corresponding file system ?
60% space used 40% is free.
do you purge automatically these trace files and when ?
No idea. How to check this??