Home » RDBMS Server » Performance Tuning » about sql tuning
about sql tuning [message #210845] Fri, 22 December 2006 11:24 Go to next message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member
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 9.2.0.4.0 - Production on Fri Dec 22 19:04:23 2006

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


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - 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
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
Collect fresh statistics.
Post table descriptions
Post SQL & EXPLIAN PLANs
Re: about sql tuning [message #210932 is a reply to message #210845] Sat, 23 December 2006 10:02 Go to previous message
michael_bialik
Messages: 611
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: Wed Dec 07 16:31:15 CST 2016

Total time taken to generate the page: 0.05930 seconds