This article using Oracle Database 11g , I will post for 10g Later .
How Could I change name for Oracle Trace :
alter session set tracefile_identifier = ‘some_id’;
SQL> alter session set tracefile_identifier = ‘osama’;
SQL> oradebug tracefile_name
maximum size of Oracle Trace File
-By Set max_dump_file_size parameter
– alter session set max_dump_file_size = unlimited;
Finding Oracle Trace File for current session :
WHERE name = ‘Default Trace File’;
Finding Oracle Trace File for Current Database Process
SELECT pid, program, tracefile
To find all trace files for the current instance:
SELECT VALUE FROM V$DIAG_INFO WHERE NAME = ‘Diag Trace’;
and you could use ADRCI features.
Published by Osama Mustafa
Osama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers.
In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases.
Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.
View all posts by Osama Mustafa
One thought on “Dealing With Oracle Traces”
Good Info. Thank you.