trace files use in oracle 8
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: trace files use in oracle 8

Hybrid View

  1. #1
    Join Date
    Apr 2003
    Location
    india
    Posts
    13

    Question trace files use in oracle 8

    we have installed oracle 8 server on netware server .
    in our server \\ORANW803\RDBMS80\TRACE folder in that folder somany trce files are reside. like Orclsnp0.trc , 000004f8.trc and one log file Orclalrt.log . are there any use with these files or not ... if i delete them any thing goes wrong .... why because this log file is occuping 1 gb space ...where as trace file occupies 100 kb etc plz give me a solution
    thanks in advance
    akhir dil hi hindustani

  2. #2
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    Yes, you can remove trace files, and Orclalrt.log will be used as cronological log for your Database, It generally include messages for Database startup, shutdown, Log switch.

    You can also remove Orclalrt.log file, but truncating from the beginning will be a good practice. If you remove it Oracle server will create one.

    To know position of these files check parameter BACKGROUND_DUMP_DEST.

    Cheers

    Dilip.
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

  3. #3
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    u should take copy of alert.log into another location(if space problem is there )before deleting. Because sometimes it helps
    in solving the future problems.

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