Home » RDBMS Server » Server Administration » Oracle 11g features
Oracle 11g features [message #317055] Tue, 29 April 2008 06:14 Go to next message
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 #317058 is a reply to message #317055] Tue, 29 April 2008 06:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What about reading Oracle documentation, FIRST?

Regards
Michel
Re: Oracle 11g features [message #317075 is a reply to message #317055] Tue, 29 April 2008 07:28 Go to previous messageGo to next message
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 #317090 is a reply to message #317075] Tue, 29 April 2008 08:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What did you read?

Regards
Michel
Re: Oracle 11g features [message #317091 is a reply to message #317055] Tue, 29 April 2008 08:33 Go to previous messageGo to next message
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 #317093 is a reply to message #317055] Tue, 29 April 2008 08:38 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
ara.oracle,
Congratulations!
You get a Gold Star for mastering the use of CUT & PASTE.
Next time, please practice in the TEST sub-forum.
Re: Oracle 11g features [message #317100 is a reply to message #317091] Tue, 29 April 2008 09:04 Go to previous message
Michel Cadot
Messages: 64152
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
Previous Topic: Oracle Scheduler locks packages
Next Topic: Upgrading oracle 10G -- catupgrd.sql file
Goto Forum:
  


Current Time: Sat Dec 10 04:43:52 CST 2016

Total time taken to generate the page: 0.12757 seconds