UDUMP

From Oracle FAQ
Jump to: navigation, search

UDUMP is the database's USER DUMP DIRECTORY.

SQL> SHOW PARAMETERS user_dump_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest                       string      /app/oracle/admin/o102/udump

To change:

SQL> ALTER SYSTEM SET user_dump_dest = '/app/oracle/admin/o102/udump' SCOPE=both;

System altered.

Also See[edit]

  • SQL Trace - procedure describing how to write to UDUMP