Oracle 8i very slow

Posted on 2009-04-17
Last Modified: 2013-12-19

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,
Question by:silviall
    LVL 3

    Expert Comment

    Could you give us more details on the server hardware and the kind of operations which are slow?

    Author Comment


    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.
    LVL 47

    Expert Comment

    Compute statistics over tables and indexes.

    Check the alert.log file.

    Clean big log flles:
    LVL 3

    Accepted Solution

    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.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now