| Performance on single query [message #427718] |
Sat, 24 October 2009 05:48  |
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  |
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 #427743 is a reply to message #427718] |
Sat, 24 October 2009 16:13 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
