Qn on user_dump_dest
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Qn on user_dump_dest

  1. #1
    Join Date
    Oct 2000
    Posts
    449

    Qn on user_dump_dest

    Hello:

    I have my user_dump_dest/udump destined to /home/oracle.

    We are tracing lots of things and space is not enough in there. Our operations department is not finding space to add in /home/oracle. So temporarily of I have to change the destination to some other filesystems what are the implications I would have. What are the adjustments need to be made in pfile or init_SID.ora, coz, I don't want the system to hang around for overlooking anything.

    Thanks, ST2000

    ~

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    just change the user_dump_dest to whatever location you want to write to. make sure that filesystem/directory exists. Also. there are no implications...
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,476
    No problema, just do:

    ALTER SYSTEM SET USER_DUMP_DEST='/new_fs';

    and then edit the init.ora file to set the same directory.

    That's all it takes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width