| vm size of oracle.exe grows [message #56743] |
Tue, 22 April 2003 05:17 |
Melvin
Messages: 4
Registered: November 2002
|
Junior Member |
|
|
Hi,
we have an application that makes intensive use of
the IN operator, i.e. about 99% of our queries look
like this:
SELECT DISTINCT COL1, COL2, COL3 FROM TAB1 WHERE COL1
IN (...) AND COL2 IN (...);
The lists can have hundreds of entries so that the
number of combinations makes it impossible to buffer
all queries in the shared pool. What I would expect
is that new queries get buffered in the shared pool
and the lru ones get deleted from it. The memory
consumption should be more or less constant.
But the observation is that the "VM Size" of the
oracle process (oracle.exe) is constantly growing
and I even get ORA-4030 (Out of process memory)
after running production queries for a couple
of hours.
By the way: Performance of unbuffered queries is
very good. We are using bitmap indexes and the
INDEX_COMBINE hint.
My questions are:
What part of the SGA is actually growing?
Is there a way to limit the size of the SGA in
Oracle8i (on Windows2000)?
I've already tried the LOCK_SGA parameter but
I cannot get my instance started with this
parameter set to true.
Any ideas?
Regards,
Melvin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
