Oracle 11g features [message #317055] |
Tue, 29 April 2008 06:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ara.oracle
Messages: 142 Registered: August 2007
|
Senior Member |
|
|
hi,
In oracle 11g features one of the feature was Database replay.
In that it was mentioned that
By capturing a workload on the production system and replaying it on a test system,
I cant understand what it means, what they are mentioning as workload.Can any please explain me about thr database replay.
Wheather it is mentioning that it will capture all the datafiles,log,control etc is similar to taking backup.
Then whats the difference between taking backup and copying it to test setup and Database replay?
please say abt database reply briefly
|
|
|
|
Re: Oracle 11g features [message #317075 is a reply to message #317055] |
Tue, 29 April 2008 07:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ara.oracle
Messages: 142 Registered: August 2007
|
Senior Member |
|
|
ya i was reading that only but cant able to understand what it was mentioned.It was saying that caputring the workload of production database.
Workload means what are they mentioning?
|
|
|
|
Re: Oracle 11g features [message #317091 is a reply to message #317055] |
Tue, 29 April 2008 08:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ara.oracle
Messages: 142 Registered: August 2007
|
Senior Member |
|
|
Before system changes are made, such as hardware and software upgrades, extensive
testing is usually performed in a test environment to validate the changes. However,
despite the testing, the new system often experiences unexpected behavior when it
enters production because the testing was not performed using a realistic workload.
The inability to simulate a realistic workload during testing is one of the biggest
challenges when validating system changes.
Database Replay enables realistic testing of system changes by essentially recreating
the production workload environment on a test system. Using Database Replay, you
can capture a workload on the production system and replay it on a test system with
the exact timing, concurrency, and transaction characteristics of the original workload.
This enables you to fully assess the impact of the change, including undesired results,
new contention points, or plan regressions. Extensive analysis and reporting is
provided to help identify any potential problems, such as new errors encountered and
performance divergence.
Capturing the production workload eliminates the need to develop simulation
workloads or script, resulting in significant cost reduction and time savings. By using
Database Replay, realistic testing of complex applications that previously took months
using load simulation tools can now be completed in days. This enables you to rapidly
test changes and adopt new technologies with a higher degree of confidence and at
lower risk.
Database Replay performs workload capture of external client workload at the
database level and has negligible performance overhead. You can use Database Replay
to test any significant system changes, including:
■ Database and operating system upgrades
■ Configuration changes, such as conversion of a database from a single instance to
an Oracle RAC environment
■ Storage, network, and interconnect changes
■ Operating system and hardware migrations
|
|
|
|
Re: Oracle 11g features [message #317100 is a reply to message #317091] |
Tue, 29 April 2008 09:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Maybe I should add "where" did you read it? Post a link then we can see and read the same thing and know where you are.
Regards
Michel
|
|
|