Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2002
    Posts
    77

    Unanswered: running out of disk space

    Hi guys, I am a working with oracle 9i (version 9.2.0.1.0) on red hat linux advanced server 2.1

    The disk where oracle runs on constantly runs out of space, I didn't add any new data to it. Is there logging or tracing that is enabled by default. I tried to look in the udump and bdump directories but those files weren't big at all.

    Thanks in advance for your help.

  2. #2
    Join Date
    Aug 2003
    Posts
    123
    Hi,
    Check some one is importing data or any data is inserted in endless loop inside the stored proc or block. Check all the running process. possible send me the latest bdump file I will look into that.
    what is the current database size, can you increase the table space..

    --Jaggu

  3. #3
    Join Date
    May 2003
    Location
    Dublin, Ireland
    Posts
    44

    Re: running out of disk space

    Check also cdump directory and arch if database is in archivelog mode.
    Check $ORACLE_HOME/network/log. Every connection via NET8 is logged and if you have tracing on then traces go to $ORACLE_HOME/network/trace.
    Check $ORACLE_HOME/network/agent/log if you are running dbsnmp.

    Jacek

  4. #4
    Join Date
    Sep 2003
    Posts
    3

    Re: running out of disk space

    Originally posted by vld
    Hi guys, I am a working with oracle 9i (version 9.2.0.1.0) on red hat linux advanced server 2.1

    The disk where oracle runs on constantly runs out of space, I didn't add any new data to it. Is there logging or tracing that is enabled by default. I tried to look in the udump and bdump directories but those files weren't big at all.

    Thanks in advance for your help.
    Check your UNDO and TEMP spaces be sure you have a coalesce strategy, use tempfiles, etc.

  5. #5
    Join Date
    Sep 2003
    Posts
    4

    What!

    A database doesn't grow if you don't tell it to.
    So why suggest temp undo etc?

    The only thing I can think about is if you run the DB in archive mode.
    And don't take care of the archive logs.

Posting Permissions

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