How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
3.1.4 Database Replay → The following sections provide information on new Database Replay features for 22.214.171.124.
WCR: replay lock order → A session will wait on this event during replay if it saw some lock contention during capture. Wait … wait for scn's hi 4 bytes High 4 bytes of the 8-byte replay SCN that the session is waiting on wait … for scn's lo 4 bytes Low 4 bytes of the 8-byte replay SCN that the session is waiting on
WCR: replay clock → A session will wait on this event during replay if it has some logical dependencies on another … replay SCN that the session is waiting on wait for scn's lo 4 bytes Low 4 bytes of the 8-byte replay SCN that the session is waiting on
WCR: replay client notify → During replay, the Workload Replay Client always keeps an open connection to the database to detect … some special errors. This session will normally be in the wait state until some specific replay … () to be issued. 2 - waiting for the replay to run to completion or REPLAY.CANCEL() to be issued.
WCR: replay paused → waiting on this wait event until replay is resumed. Parameters: None
1.4 Database Replay Support for Database Consolidation → Database Replay now supports simultaneous execution of multiple database captures on a single … consolidated database. Consolidated database replay supports scheduling of the individual replays … peak utilizations at the same time). Consolidated replay provides the ability to test database
Database Replay → Part II Database Replay Database Replay enables you to replay a full production workload on a test … system to assess the overall impact of system changes. Part II covers Database Replay and contains … the following chapters: Chapter 8, \"Introduction to Database Replay\" Chapter 9, \"Capturing a
13.2.1 Capturing Database Workloads for Consolidated Database Replay → Consolidated Database Replay does not require any special steps for capturing database workloads … for Database Replay, as described in Chapter 9, \"Capturing a Database Workload\". This section … contains the following topics for workload captures that are specific to Consolidated Database Replay … Consolidated Database Replay
13.2.4 Replaying Database Workloads for Consolidated Database Replay → Replaying consolidated workloads using Consolidated Database Replay is quite different from … replaying a single database workload using Database Replay. This section contains the following topics for … replaying workloads that are specific to Consolidated Database Replay: Defining Replay Schedules … Remapping
13.4.2 Setting the Replay Directory Using APIs → This section describes how to set the replay directory on the test system using the … DBMS_WORKLOAD_REPLAY package. Set the replay directory to a directory on the test system that contains the workload … captures to be replayed. For information about setting up the test system, see \"Setting Up the Test System for Consolidated Database Replay\".
13.5.1 Using Time Shifting → This section describes how to use time shifting with Consolidated Database Replay, and assumes a … applications and replay them simultaneously. The scenario demonstrates how to use time shifting for … performed by adding a delay of one hour to the CRM workload and a delay of 30 minutes to the DW workload during replay.
To perform workload folding in this scenario: → On the replay system where you plan to perform scale-up testing, create a directory object for the … ('CAP_MON_8AM_2PM'); EXEC DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE ('CAP_MON_2PM_8PM'); Set the replay … a replay schedule and add the capture subsets: EXEC DBMS_WORKLOAD_REPLAY.BEGIN_REPLAY_SCHEDULE … consolidated replay:
13.1.2 Workload Scale-Up Techniques → Workload Folding About Schema Remapping 126.96.36.199 About Time Shifting Database Replay enables you to … workload captures and replay them together using Consolidated Database Replay. See Also: \"Stress Testing … \" for information about using Consolidated Database Replay for stress testing \"Using Time Shifting
13.2.5 Reporting and Analysis for Consolidated Database Replay → Reporting and analysis for Consolidated Database Replay is performed using the replay compare … period report, as described in \"Using Compare Period Reports\". The replay compare period report for … Consolidated Database Replay identifies the Active Session History (ASH) data for each individual … consolidated
To view replay schedules: → Use the DBA_WORKLOAD_REPLAY_SCHEDULES view. See Also: Oracle Database PL/SQL Packages and Types Reference for information about the END_REPLAY_SCHEDULE procedure Oracle Database Reference for information about the DBA_WORKLOAD_REPLAY_SCHEDULES view
13.2.3 Preprocessing Database Workloads for Consolidated Database Replay → Figure 13-1 Setting Up the Test System for Consolidated Database Replay Description of \"Figure 13 … -1 Setting Up the Test System for Consolidated Database Replay\" See Also: \"Setting the Replay … Directory Using APIs\" 13.2.3 Preprocessing Database Workloads for Consolidated Database Replay … Preprocessing
13.3 Using Consolidated Database Replay with Enterprise Manager → Figure 13-2 Compare Period Report: Consolidated Replay Description of \"Figure 13-2 Compare Period … Report: Consolidated Replay\" The rest of the sections in the report resemble the ASH Data … Comparison section of the replay compare period report and are formed by joining all Capture vs. Replay … reports in
To set the replay directory: → 13-2 shows how to set the replay directory to a directory object named rep_dir. Example 13-2 … Setting the Replay Directory EXEC DBMS_WORKLOAD_REPLAY.SET_REPLAY_DIRECTORY ('rep_dir'); You can also use … the DBMS_WORKLOAD_REPLAY package to view the current replay directory that has been set by the SET_REPLAY_DIRECTORY procedure.
To add workload captures to a replay schedule: → an unique identifier that identifies the workload capture in this replay schedule. Set the … top-level replay directory. The directory must contain a valid workload capture that is preprocessed … on a system running the same database version as the replay system. Set the other parameters, which … replay schedule
8.1 Workload Capture → Figure 8-1 Database Replay Workflow Description of \"Figure 8-1 Database Replay Workflow\" On the … \". On the test system, replay the preprocessed files, as described in \"Workload Replay\". Using … the reports generated by Database Replay, perform detailed analysis of both the workload capture and