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

Oracle 8i tuning

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?
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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...
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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