Home » RDBMS Server » Performance Tuning » Performance on single query (Oracle 9i)
Performance on single query [message #427718] Sat, 24 October 2009 05:48 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,

I have performance issue along in our prduction environment for a query ,but the same query is running fast in our local DB
Both the DB has same scripts and same indexes but peformance is different i have took the versions from both local and production DB below are the details

Production

BANNER

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE	9.2.0.8.0	Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production


Local DB

BANNER

Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE	9.2.0.8.0	Production
TNS for Linux: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production



Re: Performance on single query [message #427719 is a reply to message #427718] Sat, 24 October 2009 06:14 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member

Hi,

Yes it might differ due to data volumes ..please do gather stats on all the tables which are involved in that query where it is performing slow.

You can also paste you query with execution plan.

Regards

Bala
Re: Performance on single query [message #427727 is a reply to message #427718] Sat, 24 October 2009 09:44 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- OraFAQ Forum Guide, Performance Tuning section
- Performances Tuning sticky
- OraFAQ Performance Tuning
- Database Performance Tuning Guide

Regards
Michel
Re: Performance on single query [message #427729 is a reply to message #427718] Sat, 24 October 2009 10:03 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
>I have performance issue along in our prduction environment for a query ,but the same query is running fast in our local DB

Compare & contrast.

Find what is different & correct it.

start by posting EXPLAIN PLAN from both systems
Re: Performance on single query [message #427743 is a reply to message #427718] Sat, 24 October 2009 16:13 Go to previous message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
Quote:

I have performance issue along in our prduction environment for a query ,but the same query is running fast in our local DB


Whatever info you have provided is not enough .

1.Can you provide the sql statement that have performaance issue
2.Please provide the plan for the same sql in PROD and your local database.Make sure that stats are upto date in both environment (Can have a look at LAST_ANALYZED of USER_TABLES/USER_INDEXES(ALL_INDEXES)
3. There should be a high volume of data in your PROD database comapredd to your locaal DB
So obviously, the sql you ran may not return you the same amount of data and response time should differ
4. What are the list of indexes for the tables used in your sql?



Thanks

[Updated on: Sat, 24 October 2009 16:21]

Report message to a moderator

Previous Topic: Optimizing the query containing 7 table joins
Next Topic: explain plan difference between 9i and 10g
Goto Forum:
  


Current Time: Sun Sep 25 19:41:09 CDT 2016

Total time taken to generate the page: 0.36942 seconds