| about sql tuning [message #210845] |
Fri, 22 December 2006 11:24  |
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...
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
