OraFAQ Forum: Performance Tuning » identifying query problem

Home » RDBMS Server » Performance Tuning » identifying query problem (Oracle 10.2.0.4.0, RedHatLinux-5)

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

identifying query problem [message #592816]

Mon, 12 August 2013 08:53

8939513598$
Messages: 103
Registered: July 2013
Location: chennai

Senior Member

Hi, Totally iam having 8 database, how to identify the query problems in each database?

Report message to a moderator

Re: identifying query problem [message #592819 is a reply to message #592816]

Mon, 12 August 2013 08:57

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

Senior Member
Account Moderator

You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- Performances Tuning sticky
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Tuning High-Volume SQL Wiki page

You can also have a look at Database Performance Tuning Guide.

Regards
Michel

Report message to a moderator

Re: identifying query problem [message #592820 is a reply to message #592819]

Mon, 12 August 2013 09:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Totally iam having 8 database, how to identify the query problems in each database?

which metric measures "query problem"?

Report message to a moderator

Re: identifying query problem [message #592836 is a reply to message #592820]

Mon, 12 August 2013 11:43

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

Senior Member
Account Moderator

1/ You have 8 databases and thousand queries which one will you take for your explain plans?
2/ Cost is totally useless between queries, it can be used ONLY to compare plans of the SAME query.
3/ "analyze the table as well and gather statistics", NO NO NO, surely not, forget ANALYZE and surely not use it with DBMS_STATS.GATHER_STAT..., this is the WORST way, better do nothing.

Please also read the links I posted.

Regards
Michel

Report message to a moderator

Re: identifying query problem [message #593783 is a reply to message #592820]

Tue, 20 August 2013 22:11

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

check out this other OraFAQ thread. Might be what you are looking for. Near the end is a script I offered at that time. It still works and I assume it can still be downloaded.

Ross thought is was pretty good so it must be pretty good.

Good luck. Kevin

[Updated on: Tue, 20 August 2013 22:12]

Report message to a moderator

Previous Topic:	dbms_stats.set_table_prefs and "LIST STALE"
Next Topic:	Efficient Way - Outer join Vs Not Exists

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 12 00:24:56 CDT 2026