What needs to be done to perform a fast refresh?

Options
- The server that manages the snapshot executes the snapshot's defining query
- Query should replace the existing snapshot data to refresh the snapshot
- The server that manages the snapshot first identifies the changes that occurred in the master since the most recent refresh of the snapshot and then applies them to the snapshot
- Create a snapshot log for the table so that fast refreshes of the snapshots are an option


CORRECT ANSWER : The server that manages the snapshot first identifies the changes that occurred in the master since the most recent refresh of the snapshot and then applies them to the snapshot

Discussion Board
Oracle Replication

A table snapshot is a transaction-consistent reflection of its master data as the data existed at a specific point in time. Oracle can refresh an individual snapshot using either a complete refresh or a fast refresh.

Complete Refreshes: To perform a complete refresh of a snapshot, the server that manages the snapshot executes the snapshot's defining query. The result set of the query replaces the existing snapshot data to refresh the snapshot. Oracle can perform a complete refresh for any snapshot.

Fast Refreshes: To perform a fast refresh, the server that manages the snapshot first identifies the changes that took place in the master since the most recent refresh of the snapshot and then applies them to the snapshot. Fast refreshes are more efficient than complete refreshes when there are few changes to the master because participating servers and networks must replicate less data. Fast refreshes are available for snapshots only when the master table has a snapshot log.

Prajakta Pandit 02-16-2017 01:44 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement