OraFAQ Forum: Performance Tuning » Query Tuning

Home » RDBMS Server » Performance Tuning » Query Tuning

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query Tuning [message #239427]

Tue, 22 May 2007 07:01

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.

Report message to a moderator

Re: Query Tuning [message #239474 is a reply to message #239427]

Tue, 22 May 2007 08:30

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post what you already try to search and you already (think) you know and we'll complete.

Regards
Michel

Report message to a moderator

Re: Query Tuning [message #239534 is a reply to message #239474]

Tue, 22 May 2007 10:47

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/toc.htm

Report message to a moderator

Re: Query Tuning [message #239694 is a reply to message #239474]

Wed, 23 May 2007 01:59

thiyagaraj
Messages: 41
Registered: August 2006

Member

Hi ,

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

Report message to a moderator

Re: Query Tuning [message #239722 is a reply to message #239694]

Wed, 23 May 2007 03:29

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 08:21:07 CST 2024