| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> DB gets really slow
Hello,
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:http://www.puschitz.com/InstallingOracle9i.html, 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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Reuben D. Budiardja
INET: techlist_at_voyager.phys.utk.edu
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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
 |
 |