Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> DB gets really slow

DB gets really slow

From: Reuben D. Budiardja <>
Date: Thu, 21 Aug 2003 12:19:41 -0800
Message-ID: <>

Sorry if this is a really newbie kinda question. I am a web developer and at this point we have a contract to develop something using Oracle. We use PHP as the front end to connect to oracle.

Now, eventually all the codes will be moves to the company that outsource it to us, and they have cluster oracle and their DBA. But for development purposes, for some reason, we don't have access to their DB server.

So I downloaded the demo version and install it to our own development server (Redhat Linux 7.3, 1GB RAM, 1.4GHz Athlon XP). I just do install as explained here:, started the database, and started doing development (creating/dropping table, insert/update/delete/select, etc). I don't have very much data, since it's only dummy data for testing purposes.
So it's really a vanilla oracle-install. No customization, optimization whatsoever.

At some point, after being up for a while, the whole thing starts to slowdown. I am assuming it's Oracle, since I can't really think anything else who slow it down. The same codes and tables and data using postgreSQL doesn't do this.

Restarting oracle and the webserver helps, and things back to normal.

My question is, is there anything critical that I miss here? Do I have to do something, like cleaning up etc., to keep the DB running well? In the early starts of development, we did a lot of dropping and re-creating tables, indexes, constraint, and updating/deleting data. Does this have any effect? Anything I can do to find the source of this problem?

We don't have an Oracle DBA, and I am not very familiar with oracle from DBA point of view (only as developer), and I didn't really want to spend a lot of time customizing/learning/optimizing the development database because we needed to start development ASAP, but it's probably time to start learning.

Thanks for any help.
Reuben D.Budiardja


Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN

/"\ ASCII Ribbon Campaign against HTML \ / email and proprietary format
 X attachments.
/ \


Please see the official ORACLE-L FAQ:

Author: Reuben D. Budiardja

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Aug 21 2003 - 15:19:41 CDT

Original text of this message