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)

On Mar 19, 10:50*am, zigzagdna <zigzag... (AT) yahoo (DOT) com> wrote:
Look under $ORACLE_BASE/admin... audit (*.aud) and trace files
(*.trc, *.trm) files, depending on definition of
db_recovery_file_dest, audit_file_dest, background_dump_dest, alert
log, listener logs and a host of other files will placed in the their
respective "destinations" - generally defaulting somewhere under
$ORACLE_BASE.

Also, if your database has a lot (or any) triggers, the base 11.2.0.1
has a problem where the test team forgot to remove a (trace forever
level 12?) command in the actual code causing Oracle to create a trace
file EVERY time a trigger fires. There is a patch to remove this
code. Search "metalink"

On Mar 19, 6:00*pm, onedbguru <onedbg... (AT) yahoo (DOT) com> wrote:
If there are trace files they won't get deleted when pprogram ends; so
it is unlikely it is because of trace files.

On Mar 19, 7:50*am, zigzagdna <zigzag... (AT) yahoo (DOT) com> wrote:

Does the java file write a temporary file?

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...out-james-art/

On Mar 20, 8:30*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Excellent point, may be java/jdbc is creating its own tmp file
eventhoug my program does not. Needs more research. When I did find . -
mtime -1 I had not see any strange files.