Memory Leak in Oracle 7.3.4???

Hello,

I am experiencing some very bizarre behavior in Oracle 7.3.4. for Windows NT, was wondering if anyone has seen this and knows why it is happening.

I have a relatively large and complex query which uses constrained Cartesian products to expand a table which has a date range and a time range. Query is of the form

select [Lots of stuff] from MasterTable M, DetailTable D, Dates Da, Times T where T.time between M.start_time and M.end_time and Da.date between M.start_date and M.end_date and M.ID = D.ID . . .

M and D have a complex many-to-many relationship, so I'm using a hash join here. Also, in the select columns are a fair number of simple function calls to stored PL/SQL procedures -- little trivial things which do some date arithmetic etc.

This query keeps sucking memory until it finishes -- up to 8M most of the time, occasionally up to 100M -- and it won't put the memory back unless the session closes. Since I have a set of queries to run in this process, I can't be opening and closing the sessions all the time.

Does anyone know why this gobbles memory, and how to get it to put the memory back?

Thanks in advance,
-Ben Walther Received on Wed Feb 24 1999 - 23:48:05 CST