Oracle 8i tuning

Posted on 2009-02-16
Last Modified: 2013-12-19
I've a Windows 2000 server, with 2GB ram, RAID 5,... 2 CPU and a program 16 bit that is connected to Oracle 8.1.7 database. The program runs very slow. Could I do any tuning to Oracle 8i?
Question by:silviall
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    you need to check the queries that you run that take time, and tune them.
    get the explain plan of those, and see if there are full table scans for example...
    LVL 3

    Accepted Solution

    you have different ways to identify bad queries :

    - add an "alter session set  sql_trace true;" to put the session in trace mode,  then, after the end of the oracle session, run, on the server side, the oracle command "tkprof " , located in the ORACLE_HOME/bin folder.
    tkprof will create a text file with all sql statements executed during the session, with some metrics.

    - the other way is to select the system view V$SQLAREA, sorted by buffer_gets (desc).

    once you have the query, use the "explain plan" command to get the explain plan used.

    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 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows how to recover a database from a user managed backup

    755 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

    17 Experts available now in Live!

    Get 1:1 Help Now