6 Replies Latest reply on Nov 25, 2016 8:07 AM by Kanda-Oracle

    utl_file_dir

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

      OL6

      11gR2

       

       

      We encountered weird issues in our EBS instance like all users hang and after sometime it will resume.

      One of the suspect is our /usr/tmp is 99% full and our UTL_FILE_DIR is set to this folder

       

      I select values from v$parameters, and we got the following values:

       

       

      utl_file_dir/oracle/PROD/db/tech_st/11.2.0/appsutil/outbound/PROD_ebizdb/ebiz/prodr12/utl_file_dir
      utl_file_dir/usr/tmp/ebiz/prodr12/utl_file_dir
      utl_file_dir/usr/tmp/ebiz/prodr12/utl_file_dir
      utl_file_dir/usr/tmp/ebiz/prodr12/utl_file_dir

       

      How to I change it to /u01/temp?

      Why is there three /usr/tmp   setting?

       

      At linux side the /   mount point where   /usr/tmp is located   the total size is only 10Gb  hence it easily gets full.

       

      Why is that the tmp dir is not automatically cleared? I see lots of month old temp files.

      Do I need to write a script to clear > 2 days old temp files?

      var-tmp.png

       

       

       

      Please help...

       

      Kind regards,

      jc