• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 545
  • Last Modified:

Oracle 8i very slow

Hello,

I've Oracle 8i running, the tables has 181000 rows, 88101 rows, 266005 rows, and 20 clients connected, and the database is very slow.
What is the best option to increase the performance? Delete old rows or change some parameter in the server?

Best regards,
0
silviall
Asked:
silviall
  • 2
1 Solution
 
mganeshCommented:
Could you give us more details on the server hardware and the kind of operations which are slow?
0
 
silviallAuthor Commented:
Hello,

I've a server ML 350 G4.
2CPU Xeon 3.2GHz.
RAM 2GB
LAN 1Gb
3 HARD DISK  RAID 5.

All operations with database are slow. I think that there is a proces that every 10 minuts do a big select to database.

What could I do?

Thanks for your time.
0
 
schwertnerCommented:
Compute statistics over tables and indexes.

Check the alert.log file.

Clean big log flles:
alert.log
listener.log
0
 
mganeshCommented:
With the limited information, this is what I can suggest:
1. Make sure your db_block_buffers is large enough for big Selects
2. Make sure selects on similar tables are grouped together to take advantage of cached info
3. Look for CPU, RAM and IO usage using the operating system (if unix, then sar, ps, iostat, vmstat, free etc. Description of these commands are out of scope for this post I guess. You could get more iby googling.)
4. If RAM and CPU are not used much, then you could introduce parallelism into your queries using hints
5. Make sure your indexes are being used properly by going through the expain plan of your queries
6. Check alert log for any info on the slowness. Typically, if there are huge inserts without NOLOGGING, then your redolog sizing may require tuning (Look for 'Checkpoint not complete' messages)

This list can go on.:-)  But I guess you should try out some of the above first.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now