Oracle 9i Database memory problem. [message #62126] |
Mon, 28 June 2004 08:33 |
Corentin Hauchard
Messages: 2 Registered: May 2004
|
Junior Member |
|
|
Hi All,
I am working in a small french enterprise and we have an Oracle 9i Database to admin. The problem is that I am not an Oracle DBA but I have to do his job!!
Our problem is : we do a lot of select request in a short time every month but after a working time around 30 minutes, the peformance of the database are going down until become null. So we think this comes from the memory. My question is : Does anyone know a sql command or an oracle method to free the memory that is used by Oracle to save the select request's results?
Thank you in advance.
Corentin.
|
|
|