| |
 |
|
Oracle Tips by Burleson Consulting
|
Large Dynamic Tables
Very large replicated tables will consume too much time of you drop
and re-creating the snapshot, or if you use the REFRESH COMPLETE
option. For static tables, a snapshot log would not contain very
many changes—we could direct Oracle to propagate the changes to the
replicated table at frequent intervals. Let’s take a look at the
different refresh intervals that can be specified for a snapshot:
CREATE SNAPSHOT
cust_snap1
REFRESH FAST
START WITH SYSDATE
NEXT SYSDATE+7
AS
SELECT
cust_nbr, cust_name
FROM
customer@hq
WHERE
department = 'NC';
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
