Mount Point gets Filled Up
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Mount Point gets Filled Up

  1. #1
    Join Date
    Jul 2008
    Posts
    16

    Mount Point gets Filled Up

    Hi,

    We are facing a situation while working on Oracle 10.1.0.4.0 with OS as RHEL 3

    Firstly DB gets hang, when we restart DB it start with using 50% of memory with is a normal situation,
    but with in 10 minutes, it uses all memory, full swap memory and 100% of mount point assigned to Oracle
    Then again DB gets hang. A trace file gets generated of about size 2.7 GB.
    If we delete the trace file DB works normal for some time and again comes back to hanging position after 8-10 minutes.

    What the reasons for this and any possible remedy may please be posted

    With regards
    Prthvira
    INDI

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    What process is geenrating the trace file.

    regards
    Hrishy

  3. #3
    Join Date
    Jul 2008
    Posts
    16
    Dear Hrishy,

    its not clear for me,

    i am pasting starting lines of the trace.

    with regards


    "/home/oracle/admin/orcl/udump/orcl_ora_11494.trc
    Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
    With the Partitioning, OLAP and Data Mining options
    ORACLE_HOME = /home/oracle/product/10.1.0/Db_1
    System name: Linux
    Node name: Bramhagupta
    Release: 2.4.21-19.ELsmp
    Version: #1 SMP Thu Aug 12 23:26:16 EDT 2004
    Machine: i686
    Instance name: orcl
    Redo thread mounted by this instance: 1
    Oracle process number: 39
    Unix process pid: 11494, image: oracleorcl@Bramhagupta

    *** 2008-11-25 20:05:41.245
    *** SERVICE NAME:(SYS$USERS) 2008-11-25 20:05:41.244
    *** SESSION ID:(2714.5) 2008-11-25 20:05:41.244
    *********START PLSQL RUNTIME DUMP************
    ***Got internal error Exception caught in pfrrun() while running PLSQL***
    ***Got ORA-4030 while running PLSQL***
    PACKAGE BODY RATING_DEV.CE_UTIL:
    library unit=954c6264 line=3 opcode=84 static link=bf5fcd54 scope=1
    FP=bf5fce44 PC=954c677a Page=0 AP=bf5fce44 ST=bf5fce90
    "orcl_ora_11494.trc" Interrupted "
    Prthvira
    INDI

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