Home » RDBMS Server » Server Administration » Oracle 9i Database memory problem.
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.
Previous Topic: Oracle 9i vs 8i: Locally/Dictionary Managed Tablespace?
Next Topic: Query time out happenning from a web application
Goto Forum:
  


Current Time: Fri Sep 20 14:20:01 CDT 2024