Space under $ORACLE_BASE/$ORACLE_HOME keeps increasing why
Date: Sat, 19 Mar 2011 07:50:50 -0700 (PDT)
Message-ID: <1ac7302b-e668-4680-99a6-1c37167421fe_at_v31g2000vbs.googlegroups.com>
I am on Oracle 10.2.0.4 on HP UNIX 11.2. I am running a program which has an infinite loop. Each loop iteration sleeps for 15 seconds, does some datbase access using jdbc…? I am noticing that space under $ORCALE_BASE keeps increasing. My program is definitely not writing any files under $ORACLE_BASE, so Oracle is creating some files, else how can I explain increase in $ORACLE_BASE. When I stop the program, space shrinks back to original, so looks like file has been deleted.
My program could have some cursors not being closed, but this will
increase the memory of Oracle shadow process and not space under
$ORACLE_BASE. Are there any memory mapped files, where shared memory
is being mapped to some file under $ORACLE_BASE. I am unable to find
any such files using:
Find . –mtime -1
I see some Oracle files such as Oracle agent log, listener.log but do not see anything unusual. Can someone explain what is going on and how can I troubleshoot this problem.
I am on Oracle 10.2.0.4 on HP UNIX 11.2. I am running a program which has an infinite loop. Each loop iteration sleeps for 15 seconds, does some datbase access using jdbc…? I am noticing that space under $ORCALE_BASE keeps increasing. My program is definitely not writing any files under $ORACLE_BASE, so Oracle is creating some files, else how can I explain increase in $ORACLE_BASE. When I stop the program, space shrinks back to original, so looks like file has been deleted.
My program could have some cursors not being closed, but this will
increase the memory of Oracle shadow process and not space under
$ORACLE_BASE. Are there any memory mapped files, where shared memory
is being mapped to some file under $ORACLE_BASE. I am unable to find
any such files using:
Find . –mtime -1
I see some Oracle files such as Oracle agent log, listener.log but do not see anything unusual. Can someone explain what is going on and how can I troubleshoot this problem.
java [program does various selects, inserts, updates; it writes its
execution log under /gps/twq/db3 and
ORACLE_BASE is /gpsg/twq/oracle
bdf shows...
/dev/vg03/lvtwqstage
8192000 6088123 1972403 76% /gpsg/twq/stage
/dev/vg03/lvtwqoracle
12288000 8418465 3637466 70% /gpsg/twq/oracle
/dev/vg03/lvtwqdb1 8192000 4752239 3225929 60% /gpsg/twq/db1
/dev/vg03/lvtwqdb4 8192000 5435984 2583829 68% /gpsg/twq/db4
/dev/vg03/lvtwqexpbkup
72466432 22210280 47115159 32% /gpsg/twq/expbkup
/dev/vg04/lvtwqdb2 66322432 26020448 37783114 41% /gpsg/twq/db2
/dev/vg04/lvtwqdb3 66322432 26936468 36924350 42% /gpsg/twq/db3
/dev/vg06/sq_db1 65536000 50530190 14067949 78% /gpsg/getsq/db1
It is /gpsg/twq/oracle which keeps increasing until program is recycled, then frees up space under /gpsg/twq/oracle..
I ran
lsof /gpsg/twq/oracle | sort -k 7n,7
It shows an Oracle shadow process 1778 size is 1519m and this size keeps increasing. What I do not undesrtand why this shadow process is writing to this directory and what eaxctly it is writing which occupies so much disk sapce.
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
oracle 29334 twqora txt REG 64,0x30002 262845312 3633 /gpsg/twq/oracle/
product/10.2.0/bin/oracle
oracle 1778 twqora 7u REG 64,0x30002 1519238927 28811 /gpsg/twq/oracle
(/dev/vg03/lvtwqoracle)
Received on Sat Mar 19 2011 - 09:50:50 CDT