«

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
something…? 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.

Thanks a lot.

In article
<055f977b-0469-448b-bac4->,
zigzagdna <> wrote:

> 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
> something…? I am noticing that space under $ORCALE_BASE keeps
> increasing.

Assuming it's a Java program running in the Oracle database, I can only
guess that your "something…" is consuming, but not releasing, resources
that requires disk space. The possibilities are myriad [1], but the
manual particularly mentions operating system resources [2].

> When I stop the program, space shrinks back to original, so [it]
> looks like [the] file has been deleted.

Or truncated to it's previous size.

Instead of an infinite loop, why not use DBMS_SCHEDULER [3]?

[1]<http://www.javaworld.com/javaworld/jw-03-2006/jw-0313-leak.html>
[2]<http://download.oracle.com/docs/cd/B19306_01/java.102/b14187/chtwo.htm#BABEFEBH>
[3]<http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sched.htm#CIHHBGGI>

--
John B. Matthews
trashgod at gmail dot com
<http://sites.google.com/site/drjohnbmatthews>

On Mar 19, 10:52*pm, "John B. Matthews" <nos...@nospam.invalid> wrote:
> In article
> <055f977b-0469-448b-bac4-81411fbc7...@x3g2000yqj.googlegroups.com>,
>
> *zigzagdna <zigzag...@yahoo.com> wrote:
> > 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
> > something…? I am noticing that space under $ORCALE_BASE keeps
> > increasing.
>
> Assuming it's a Java program running in the Oracle database, I can only
> guess that your "something…" is consuming, but not releasing, resources
> that requires disk space. The possibilities are myriad [1], but the
> manual particularly mentions operating system resources [2].
>
> > When I stop the program, space shrinks back to original, so [it]
> > looks like [the] file has been deleted.
>
> Or truncated to it's previous size.
>
> Instead of an infinite loop, why not use DBMS_SCHEDULER [3]?
>
> [1]<http://www.javaworld.com/javaworld/jw-03-2006/jw-0313-leak.html>
> [2]<http://download.oracle.com/docs/cd/B19306_01/java.102/b14187/chtwo.ht....>
> [3]<http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sche....>
>
> --
> John B. Matthews
> trashgod at gmail dot com
> <http://sites.google.com/site/drjohnbmatthews>

John:
Thanks a lot. My java application is not running inside the database
(i.e. deos not use Oracle JVM). It is using Sun's JVM (in the old
sense before Oracle bought Sun). oracle's dbms_scheudler is not
applicable to me.

What puzzles me, if there are memory leaks etc my shadow Oracle
process will show memory increase etc but it will not write anything
inside Oracle install directory, that is most baffling.

In article
<7e3b6f22-314c-4d38-82fd->,
zigzagdna <> wrote:

> On Mar 19, 10:52Â*pm, "John B. Matthews" <nos...@nospam.invalid> wrote:
> > In article
> > <055f977b-0469-448b-bac4-81411fbc7...@x3g2000yqj.googlegroups.com>,
> >
> > Â*zigzagdna <zigzag...@yahoo.com> wrote:
> > > 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
> > > something…? I am noticing that space under $ORCALE_BASE keeps
> > > increasing.
> >
> > Assuming it's a Java program running in the Oracle database, I can only
> > guess that your "something…" is consuming, but not releasing, resources
> > that requires disk space. The possibilities are myriad [1], but the
> > manual particularly mentions operating system resources [2].
> >
> > > When I stop the program, space shrinks back to original, so [it]
> > > looks like [the] file has been deleted.
> >
> > Or truncated to it's previous size.
> >
> > Instead of an infinite loop, why not use DBMS_SCHEDULER [3]?
> >
> > [1]<http://www.javaworld.com/javaworld/jw-03-2006/jw-0313-leak.html>
> [...]
> [Please omit signatures.]
>
> Thanks a lot. My java application is not running inside the database
> (i.e. deos not use Oracle JVM). It is using Sun's JVM (in the old
> sense before Oracle bought Sun). oracle's dbms_scheudler is not
> applicable to me.

Then I'd consider another scheduler such as cron, anacron, at, quartz,
etc.

> What puzzles me, if there are memory leaks etc my shadow Oracle
> process will show memory increase etc but it will not write anything
> inside Oracle install directory, that is most baffling.

I don't follow; many things default to $ORACLE_BASE, e.g. auditing. I
don't know what "something…" does, but it does so continually, in "an
infinite loop." My suggestion is to do "something…" intermittently,
closing the session each time. If that helps, then you can focus on
"something…" with a view to toward finding the culprit.

--
[Please omit signatures.]