-
Sql Tuning
Hi all,
can anyone tell me some good sites for getting knowledge in Tuning the SQL Queries..
thanx in advance..
Pratheesh
-
I think it all will start from identifying your sql queries you want to tune first..search this site for top sql and you will find many..
OCP 8.0, 8i, 9i
-
go to tahiti.oracle.com and read performance tuning guide chapter 5 to 10 or so
-
Originally posted by launchpad
I think it all will start from identifying your sql queries you want to tune first..search this site for top sql and you will find many..
Sorry tell me the exact one
Prathesh
-
okay, to start tuning SQL, you should first have SQL to tune in hand.
How do I get it ?
check from v$sqlarea, which sql statements are doing lots of logical reads and physical reads.
Run statspack report which will give you resource comsuming SQL's.
Once you have got the SQL's check the explain plan and try to find out why the sql is taking time.
Check data destribution to find out what's bottleneck.
Ensure database is gathering statsistics on regular basis.
These are really very general things to satrt with, but worth following!
OCP 8.0, 8i, 9i
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|