Oracle 92 Home growing ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle 92 Home growing ?

  1. #1
    Join Date
    Feb 2004
    Location
    NYC
    Posts
    39

    Oracle 92 Home growing ?

    Oracle 92 Home growing ?


    After installed Oracle9i on window 2000, I found the size of Oracle Home continue increasing, it is going to out of disk space, what's the reason?
    The situation as below:
    1. OracleHome and Admin folders are put in an independent drive A, the disk space is 25G, it seems OracleHome increasing everyday in 200M speed. Why?
    2. I checked all backgroud and trace folder--udump, bdump...under Admin folder, the trace file size is limited, no more than 1 M.
    3. I put all control files, redo, archive, datafiles on another different drive B.
    So both trace files and database files would not affect the size of drive A, but why OracleHome is growing? Suppose those program files would not growing after installation.


    Thanks!

    --Betty

  2. #2
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    Betty

    please check $ORACLE_HOME/network/log folder, there will be some listener.log and other log files, Those you need to trim regularly.
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Not only that but you can do a search for which files have been modified over the past 24 hours. You'll be sure to catch the culprets that way.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Check for apache log file
    -nagarjuna

  5. #5
    Join Date
    Feb 2004
    Location
    NYC
    Posts
    39
    Thanks Dilip, OracleDoc and Nagarjuna's suggestion!

    I found network trace file made OracleHome growing -- every trace file has at least 200MB, and I didn't delete it since March 10, 2004.

    The trace file ate my disk space!


    --Betty

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