Mount Point gets Filled Up
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
What process is geenrating the trace file.
its not clear for me,
i am pasting starting lines of the trace.
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
Version: #1 SMP Thu Aug 12 23:26:16 EDT 2004
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 "
Click Here to Expand Forum to Full Width