Home » RDBMS Server » Performance Tuning » identifying query problem (Oracle 10.2.0.4.0, RedHatLinux-5)
identifying query problem [message #592816] Mon, 12 August 2013 08:53 Go to next message
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?
Re: identifying query problem [message #592819 is a reply to message #592816] Mon, 12 August 2013 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: identifying query problem [message #592820 is a reply to message #592819] Mon, 12 August 2013 09:03 Go to previous messageGo to next message
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"?
Re: identifying query problem [message #592836 is a reply to message #592820] Mon, 12 August 2013 11:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: identifying query problem [message #593783 is a reply to message #592820] Tue, 20 August 2013 22:11 Go to previous message
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:
  


Current Time: Thu Mar 28 05:02:32 CDT 2024