Home » RDBMS Server » Performance Tuning » which to tune first
which to tune first [message #65351] Mon, 16 August 2004 23:20 Go to next message
Ravikumar.V
Messages: 26
Registered: July 2004
Junior Member
Sir

      performance is very low in system

which part to tune first ,taken memory, tune shared pool(data dictionary or library ) or buffer or redo log..

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
Re: which to tune first [message #65353 is a reply to message #65351] Tue, 17 August 2004 03:22 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
First Collect the complete Stats and then decide which one to tune first.

Regards
Himanshu
Re: which to tune first [message #65354 is a reply to message #65351] Tue, 17 August 2004 05:14 Go to previous messageGo to next message
Art Metzer
Messages: 2478
Registered: December 2002
Senior Member
You should read this.
Re: which to tune first [message #65360 is a reply to message #65351] Wed, 18 August 2004 07:23 Go to previous messageGo to next message
shoblock
Messages: 325
Registered: April 2004
Senior Member
you should tune your code first - always.

poorly written code may increase disk reads - so should you buy bigger, faster disks, or should you create some indexes, and change a subquery to a correlated subquery, improving the sql, reducing the disk reads, and freeing up resources to other processes?

find out what is slow (either use v$sql to get elapsed time, turn on sql_trace for the whole db and search every trc file, add log messages to all your code with timestamps, or just ask the users "what things are slow"), then tune it.

After you've tuned all the code, then if something is still slow, you can look at the other stuff.

This is based on my 17 years of oracle performance tuning - not once has the culprit been anything other than crap code.
Re: which to tune first [message #65416 is a reply to message #65353] Wed, 15 September 2004 20:10 Go to previous message
DD
Messages: 12
Registered: January 2003
Junior Member
ddd
Previous Topic: Statspack-Urgent
Next Topic: Sql tuning, Waits
Goto Forum:
  


Current Time: Sun Sep 27 02:53:28 CDT 2020