Re: Oracle 7.2.2.3 memory leak

Hi,

We have exactly the same problem: after the database has started up, performances are good, but after a time, processes slow down until it looks like oracle processes were blocked. However, our environment is not the same at all: we have few connections but each inserts or selects a lot of rows (about 1 million each time).

French support suggests that our application uses too many cursors (implicit or explicit) which causes the shared pool to be full. But we have no ORA 4031 error. I will receive patch 326110 to correct his bug but it seems that it will be of no effect, according to you.

Hope this helps, please email me a summary or post it to the group.

Laurent Citton                Email: citton_at_shom.fr