Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Memory leaks
Are you using Parallel Query Option with either partition views with 100+ partitions or Bitmap indexes.
In 7.3.3.N there are some parse time bugs that cause processes to grab a lot of memory. Bitmap indexes can cause disasters at parse time (my worst case is 400MB), and large partition views can be pretty bad.
If you are using PQO, then the PQ slaves below min_parallel_slaves will allocate this memory and never release it, so that over time memory tends to disappear.
Using top, compare the memory allocated to PQ slaves with the memory allocated to a freshly started standard shadow process, and see if they are dramatically different.
Jonathan Lewis Received on Thu May 07 1998 - 16:37:43 CDT
![]() |
![]() |