| Data PERFORMANCE ISSUES [message #624919] |
Sun, 28 September 2014 12:10  |
 |
sakamboh
Messages: 24
Registered: March 2013
Location: oman
|
Junior Member |
|
|
Hi All,
I have a database running in my production environment having tables with 10 million records each. while retrieving reports its taking around 3 hours to retrieve them. I am not able to identify the reason.
I have took a full dump and imported in my TEST environment and executed same reports, it took 5 to 10 minutes maximum for retrieving same reports. (Both servers prod and test have same processor and memory)
Please advice what could be the reason and how I can achieve the same performance in my production environment.
|
|
|
|
|
|
| Re: Data PERFORMANCE ISSUES [message #624929 is a reply to message #624919] |
Sun, 28 September 2014 21:57  |
lzfhope
Messages: 69
Registered: July 2006
|
Member |
|
|
same objects do not mean the same query plan .
if ignore the difference between hareware and software(OS and oracle installation),then the most possible reason
is that:plan is different.
--------------------------------
As you imported data into the new environment,the statistics for data may greatly different from the old.
the preceding is just a guess! in fact,the trace files are most useful for your problem.
---
or ,you can use the advice from oem .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
