Home » RDBMS Server » Performance Tuning » Query Tuning
Query Tuning [message #239427] Tue, 22 May 2007 07:01 Go to next message
thiyagaraj
Messages: 41
Registered: August 2006
Member
Hi
Iam having a set of performance tuning questions.Kindly clear my doubts with your experience.

1. In what situation one has to rebuild index?
2. What is mean by monitoring usage in dba_tables view?
3. Among many tables in a schema,how to identify ,in which table the maximum number of physical reads and writes are happening?
4.Can i pin the frequently used tables in the memory?how to achieve it?
5.Without running the statspack,sql_trace,tkprof, how to identify
the queries which take much time to execute and display results?
6.What is the acceptable value for "db file scattered read" and
"db file sequential read"?how to trobleshoot this?And how to calculate the neutral vale for "db file scattered read" and
"db file sequential read"?


Thanks.



Re: Query Tuning [message #239474 is a reply to message #239427] Tue, 22 May 2007 08:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what you already try to search and you already (think) you know and we'll complete.

Regards
Michel
Re: Query Tuning [message #239534 is a reply to message #239474] Tue, 22 May 2007 10:47 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/toc.htm
Re: Query Tuning [message #239694 is a reply to message #239474] Wed, 23 May 2007 01:59 Go to previous messageGo to next message
thiyagaraj
Messages: 41
Registered: August 2006
Member
Hi ,

Thanks for sending me the URL. This is very informative.


Re: Query Tuning [message #239722 is a reply to message #239694] Wed, 23 May 2007 03:29 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm very surprised you didn't already get this URL as it is in the sticky you surely read before posting: Performance Tuning Sticky

Regards
Michel
Previous Topic: How to get TRACE for a Sql script which is being called from a shell program
Next Topic: UL locks in Oracle Workspace Manager
Goto Forum:
  


Current Time: Wed Dec 07 09:05:23 CST 2016

Total time taken to generate the page: 0.06660 seconds