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
Retrieved from "http://informationwww.orafaq.com/wiki/index.php?title=UDUMP&oldid=14907"