Oracle 8i tuning

Posted on 2009-02-16
Medium Priority
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 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 23649022
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...

Accepted Solution

lilian-arnaud earned 1500 total points
ID: 23649141
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

850 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