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

Hi

What process is geenrating the trace file.

regards
Hrishy

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 "