| Query runtime predictiction simulator in test like prod [message #654325] |
Sat, 30 July 2016 10:40  |
 |
swas_recall
Messages: 12
Registered: May 2012
Location: Bangalore
|
Junior Member |
|
|
Hello All
I have a requirement as below.
We are in need to build a oracle data simulator on 11g and 12c databases.This needs to be a framework that can predict the query output timiing.
Case study is as below.
TEST Database which normaly has around 2 GB of data across
Production databases have 200 GB of source data
WE want to build a system that would allow the query to run on 2GB of data but predict the outout of 200 GB,simulating the production run stats whcih it should give from the test database itself without actually running the queries on production.
I hope i was able to explain the requirement,can you please advise what should be done to achieve this.
Can this be done by exporting the statistic and simulating the data output/load,Please help me on the approach for this soltion to build
thanks
Swastik
[Updated on: Sat, 30 July 2016 10:41] Report message to a moderator |
|
|
|
| Re: Query runtime predictiction simulator in test like prod [message #654326 is a reply to message #654325] |
Sat, 30 July 2016 10:52  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
swas_recall wrote on Sat, 30 July 2016 08:40Hello All
I have a requirement as below.
We are in need to build a oracle data simulator on 11g and 12c databases.This needs to be a framework that can predict the query output timiing.
Case study is as below.
TEST Database which normaly has around 2 GB of data across
Production databases have 200 GB of source data
WE want to build a system that would allow the query to run on 2GB of data but predict the outout of 200 GB,simulating the production run stats whcih it should give from the test database itself without actually running the queries on production.
I hope i was able to explain the requirement,can you please advise what should be done to achieve this.
Can this be done by exporting the statistic and simulating the data output/load,Please help me on the approach for this soltion to build
thanks
Swastik
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
IMO, it will be faster & more accurate to run SQL against clone of Production, than the level of effort to construct any "simulator".
Nothing is impossible for the person who does not have to do it.
For many moons to come, I expect any simulator to be wrong more often then it is correct at predicting SQL performance.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
