| how to speed up [message #180546] |
Tue, 04 July 2006 02:59  |
dude4084
Messages: 222
Registered: March 2005
Location: Mux
|
Senior Member |
|
|
Hi
I have no experience in DBA.
I have developed on a project and it working at a POS (Point of Sale).
With the addition of records, the system is getting slower.
Please advice me the steps which i can do to speed up.
Fact File says:
*1* There are just around 35000 Records in around 16 main tables
*2* There are major 6 VIEWS based on main tables calculating results all the time
*3* I am using WINDOWS 2000. Forms 6 and Oracle 8
*4* Process is P-2 400 Celeron. 128 MB RAM
*5* Hard Disk size is 10 GB with 3 equal partitions with overall 2 GB left unused
*6* I have not created any index on any table
Please guide me.
-Dude
|
|
|
|
| Re: how to speed up [message #180549 is a reply to message #180546] |
Tue, 04 July 2006 03:10  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
To start with,
index your columns accordingly. Choose the right type of index.
after every major data change, collect statistics on tables/indexes(use dbms_stats).
Write good sql (tons of examples over sql/plsql forums).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
