I am starting to think that it is a memory leak, it's just to huge to be
anything else. I will calculate the size of the tables, that will be the
best sign of whats happening.
Interesting point, which I am sure everyone knows already, is that Oracle
does not let NT manage VM, it takes
I like that idea Ross, maybe I'll just bring all of you DBA geniouses in and
you guys can corner him with a hot cattle prod:)
Thanks again for all of your help Rossinater!
Kev
-Original Message-
Sent: Thursday, June 21, 2001 6:54 PM
To: Multiple recipients of list ORACLE-L
yea,
:-)
Yes! And anything you have, i'll be glad to try!
-Original Message-
Sent: Friday, June 22, 2001 1:18 PM
To: Multiple recipients of list ORACLE-L
Ross have you stopped taking your medication again :)
Dave
Ross Mohan wrote
Snip
a) I *like* NT, actually.
Snip
--
And NT does a good job with VM?
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Friday, June 22, 2001 12:06 PM
To: Multiple recipients of list ORACLE-L
I am starting to
I do not feel the statement: Oracle does not let NT manage VM is not a
correct statement.
I'm not an NT expert but I believe that Oracle on NT is like any WINDOWS 32
application that allocates memory through OS which is NT.
If you have anything that proves otherwise please let's know.
I wanted to say : I feel the statement: Oracle does not let NT manage VM
is not a
correct statement.
-Original Message-
Sent: Friday, June 22, 2001 7:46 PM
To: Multiple recipients of list ORACLE-L
I do not feel the statement: Oracle does not let NT manage VM is not a
correct statement.
Hmmm...
Why keep the pl/sql table in memory? Why not just a regular table that's
cached (sp.?)
-Original Message-
Sent: Thursday, June 21, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L
Hi all,
I have a procedure that seems to be bringing my server to it's
knees.
Winnt,
Hi all,
I have a procedure that seems to be bringing my server to it's knees.
Winnt, Oracle 817 (Pipe down Ross:))
Anyway, what happens is a pl/sql table is placed into memory and then later
on it will be written to the disk. However, by the time the process is
about to get to the
:)
a) I *like* NT, actually.
b) that's DBMS_PIPE.down('Ross'); to you, Buster
c) oracle, as a process, should include EVERYTHING
on the box having to do w/Oracle with the
exception of the listener. Including user
connects, i believe700MBytes is not at
Kevin,
Note 46001.1 Oracle Database and the Windows NT
memory architecture, Technical Bulletin is an
excellent resource.
ORA_WORKINGSETMAX is set to a value in MB (complete
details in the note).
Do you have QSLICE (part of the NT resource kit) or
another tool that will let you view the
DBMS_PIPE.down('Ross');,
Thanks for not destroying me with your mental powers:) I am concerned
about the size because it is completely hosing the machine. The worst part
is, it is ONE connection that is doing it. No one else is connected to the
db, but once this migration begins, POW,
I would love to speak more of this mythical code, but that would require me
to understand the cryptic inner sanctum of the code of P.Dorsey and his
developers!! I will speak to the developer, see what I can squeeze out of
him without getting shot!!
KK
-Original Message-
Sent: Thursday,
yea, have him break his code into modules and
try to track it down that way.
or, do it the right way and use dbms_application.
-Original Message-
Sent: Thursday, June 21, 2001 5:27 PM
To: Multiple recipients of list ORACLE-L
I would love to speak more of this mythical code, but
On Thu, 21 Jun 2001,Kevin Kostyszyn scribbled on the wall in glitter crayon:
-I would love to speak more of this mythical code, but that would require me
-to understand the cryptic inner sanctum of the code of P.Dorsey and his
-developers!! I will speak to the developer, see what I can squeeze
All right, I am not DBASTUD, you're using big words!!:) I am all over the
idea of having him split up the code. I recommended doing it with script
files that way we could end the session after the first run, free up the ram
and the vm and then start the process again. But he says he can't do
yea, you're on the right trackif he says
I can't claim you have found a guru who can
and you want to bring him in for an interview.
Then, watch the creativity unfurl from his
puckered sphincter.
As for DBMS_APPLICATION, it's a real thang. rtfm,
it's interesting even if you don't use
The amount of memory (Virtual) that is used is proportional to the size of
PL/SQL table.
There is no solution for this b/c it's perfectly normal except that the
amount of used memory is huge in comparison to the maximum amount of data in
the table which could be a memory leak.
You could estimate
17 matches
Mail list logo