Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article I will be explaining the Alert file which details an error received.
Information about a user’s session, which SQL sentence the user has run, and where the error is received, etc. are found in the Trace file.
Trace files are located in the location specified in the USER_DUMP_DEST parameter.
1 2 3 4 5 | SQL> show parameter USER_DUMP NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ user_dump_dest string /oracle/diag/rdbms/onurdb/ONURDB/trace |
Or it is found by querying the v$parameter view.
1 2 3 4 5 6 7 8 | SQL> SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME like '%user_dump%'; NAME -------------------------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- user_dump_dest /oracle/diag/rdbms/onurdb/ONURDB/trace |
