Home » RDBMS Server » Performance Tuning » about sql tuning
about sql tuning [message #210845] Fri, 22 December 2006 11:24 Go to next message
Messages: 45
Registered: October 2006
Location: TRICHY
Good day sir,

We have one problem ,last week we update our project version ,in our updataion our dev guys write very long query
suddnely our project status became very slow.

our database version :
SQL*Plus: Release - Production on Fri Dec 22 19:04:23 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release - Production
JServer Release - Production

our database in CBO mode
so i am suggested to increase the db_cache_size according to db_cache_advice and also set dbwr_io_slaves=4

I am notified that slowness due to some 3 table ,each tables contain more then 30 lks records how can i speed up this particular table,plz mention how can i find the slowness and improve the query performance.

Advanced thank u...

Re: about sql tuning [message #210863 is a reply to message #210845] Fri, 22 December 2006 13:08 Go to previous messageGo to next message
Messages: 25533
Registered: January 2009
Location: SoCal
Senior Member
Collect fresh statistics.
Post table descriptions
Re: about sql tuning [message #210932 is a reply to message #210845] Sat, 23 December 2006 10:02 Go to previous message
Messages: 619
Registered: July 2006
Senior Member
statspack may be helpfull
Previous Topic: Table Stats running
Next Topic: does it cause any negative impact on performance
Goto Forum:

Current Time: Mon Jul 24 14:05:30 CDT 2017

Total time taken to generate the page: 0.10674 seconds