Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

ISBN
0-9745993-5-2
ISBN 13
978-0974599359
Library of Congress Number: 2004096471
304 pages:
 Perfect bind - 9x7
PD 1204
Shelving:
Database/Oracle
Oracle In-Focus Series
#20

 

  Oracle Streams
High Speed Replication and Data Sharing

Madhu Tumma         

Retail Price $27.95 /  ฃ20.95 

Order now and get immediate online access to the code depot! Only $19.95
(30% off)
     
Key Features About the Author Table of Contents
Index Reader Comments Errata
     
Get the Oracle Replication Half-Pack
Three for $49.95 - An $83.00 value
Oracle Data Guard $27.95
Oracle Streams $27.95
Oracle Replication $27.95


Oracle Streams is a high-speed tool that allows synchronization of replicated databases across the globe and an indispensable feature for any company using Oracle for global eCommerce. A noted and respected Oracle author, Madhu Tumma shares his secrets for achieving high-speed replication and data sharing. Using proven techniques from mission-critical application, Tumma show the front-line secrets for ensuring success with Oracle Streams. From installation through implementation, Tumma provides step-by-step instruction to ensure your success with these powerful Oracle features.

Tumma walks you safely through the myriad of complex Oracle Streams tasks including the set-up of the staging area queue, propagation through data hubs, customized apply functions, rule-based data propagation, Oracle Streams transformation, and lots, lots more. Best of all, Tumma shares working code examples to allow you to easily manage even the most complex Oracle Streams implementation.

 
Key Features

* Learn expert secrets for high speed data replication

* Understand the successful installation and configuration techniques

* Use Oracle Streams to create a reliable failover database

* Achieve global data sharing and seamless data replication

* Learn the tricks to easily manage subscribed destinations

* Get working scripts to improve streams management

* Learn to customize data apply functions

* Understands tricks for rule-based propagation and data transformations

About the Author:

Madhu Tumma

Madhu Tumma has been working as Software Developer, IT Manager, Database Administrator, and Technical Consultant for about 18 years. He has worked on a wide variety of projects and environments ranging from mainframe, client-server, eBusiness to managed services.

He has provided consultancy to variety of clients on database clusters, business continuity and high availability solutions. His experience ranges across multiple relational database systems. Madhu is frequent speaker at Oracle World and IOUG where he presented many technical papers. Madhu has Master Degree in science and attended Business Management graduate program. He lives in New Jersey with his wife Hema and two children Sandi and Sudeep.

Table of Contents: 
I INTRODUCTION
Data Sharing
• Growing Need
• Global Operations
• Heterogeneous Systems
Data Synchronization
• Data Movement
• Data Transformation
• Data Migration
• Data Replication
What is Oracle Streams?
Why Oracle Streams?
Where to use Streams Mechanism
• Replication
• AQ – Advanced Queuing
• Event Management
• Data Loading
• Summarization of Data
• High Availability and Disaster Recovery
Streams Historical Growth
• Advanced Replication
• Advanced Queuing
Related Oracle Technologies
• Log Miner
• Standby – Data Guard
Peer Products
• Sybase Replication
• Quest Shareplex
• GoldenGate
• Data Mirror


II Streams Components and Processes
Producer and Consumer
LCR Object
• Row LCR
• DDL LCR
• Additional Attributes
Hot Mining and Cold Mining
Log based Changes
Capture Process
Propagation of Changes
Apply Process
Queuing and Dequeuing
Rules and Rules Engine
• Application of Rules
• Transformation
• Contexts
Streams Tags
Directed Network
DownStreams Capture
Change Data Capture
LogMiner
Supplemental Logging
Sys.Anydata Object
DML Handlers


III Streams Replication
Source
• Database Changes
• User Application Message
Destination Database
Data Types for Replication
Rules
• Rule Set
• Capture Rules
• Propagation Rules
• Apply Rules
• Contexts
• Transformations
Instantiation
• Capture process for Instantiation
• Oracle Data Pump for Instantiation
• Export and Import for Instantiation
The Role of Streams Tags
• How to create
• Utility of Tags
• Tags for Apply Process
Methodology
Examples
IV Capture and Propagation Configuration
Capture Mechanism
• Data Types
• DML Changes and Considerations (I, U, U, D and M)
• Types of DDL(s)
• NoLogging and Unrecoverable
• Supplemental Logging
• Instantiation
• Local v/s DownStream
• The Role of SCN
• In Restricted Session
Capture Process
• Components
• Capture States
• Multiple Processes
• Rule Evaluation
• Parallelism
Propagation and Staging
• Schedules
• Configuration
• Monitoring
Application of Rules
• Rule Set
• Capture Rules
• Propagation Rules

V Apply Configuration
Apply Process
• DML Handlers
Application of Rules
• Rule Set
• Apply Rules
• Contexts
• Transformations
Methodology
Examples


VI Troubleshooting and Monitoring
Conflict Detection
Conflict Resolution
Monitoring Streams Data Flow
Helpful Scenarios


VII Heterogeneous Data Replication
Heterogeneous Data Sharing
Oracle to Non-Oracle
• Capture process
• Instantiation
• Data Types
• Apply process
• Heterogeneous Services
• Database link
Non-Oracle to Oracle
User Application


VIII Event Management - Messaging
Event Propagation
Advanced Queuing

IX Data Loading – Data Warehousing
Data Loading
CDC – Change Data Capture


X Downstream Capture
Log Transportation Services
DBMS_FILE_TRANSFER
XI RAC and Streams
Multiple Instances
Multiple Buffers

XII Using OEM
Oracle Enterprise Manager
Grid Control


Appendix
a) Oracle Supplied Packages
b) Data Dictionary – Views

Index Topics:

add_column
add_global_propagation
add_global_propagation_rules
add_global_rules
add_message_rule
add_schema_propagation_rules
add_schema_rules
add_subset_propagation_rules
add_subset_rules
add_table_propagation_rules
add_table_rules
Advanced Queuing
ALL column logging
all_apply_progress
alter_apply
alter_capture
alter_propagation
alter_queue_table
ALWAYS log group
ANALYZE
ANALYZE SQL
and_condition
applied_message_create_time
applied_message_number
applied_scn
Apply
Apply handlers
Apply process
Apply Process
Apply Servers
apply_captured
apply_database_link
apply_name
apply_tag
apply_time
apply_user
asynchronous replication
atter
Automatic Storage Management
B
base_table_name
base_table_owner
BINARY_DOUBLE
BINARY_FLOAT
buffered queues
Builder server
C
Capture
Capture process
capture_message_create_time
captured_scn
CAPTURING CHANGES
cascade
Change Data Capture
cold mining
column list
column_name
command_type
COMMIT
commit_serialization
COMPARE_OLD_ON_DELETE
COMPARE_OLD_ON_UPDATE
compatible
Conditional Supplemental Log Groups
conflict handler
content based routing
convertdata_type
Coordinator Process
create_apply
create_capture
create_evaluation_context
create_propagation
create_rule
create_rule_set
CREATING LCR
current_schema
current_scn
Custom Apply
D
Data Definition Language
Data Guard
Data Manipulation Language
Data Movement
Data Pump
Data Replication
Data Transformation
Data Warehousing Systems
db_txn_scn
dba_apply
dba_apply_conflict_columns
dba_apply_dml_handlers
dba_apply_enqueue
dba_apply_error
dba_apply_execute
dba_apply_instantiated_objects
dba_apply_key_columns
dba_apply_parameters
dba_apply_progress
dba_apply_table_columns
dba_capture
dba_capture_extra_attributes
dba_capture_parameters
dba_capture_prepared_database
dba_capture_prepared_schemas
dba_capture_prepared_tables
dba_captures_parameters
dba_db_links
dba_evaluation_context_tables
dba_evaluation_context_vars
dba_evaluation_contexts
dba_log_group_columns
dba_log_groups
dba_propagation
dba_queue_schedules
dba_queue_tables
dba_queues
dba_registered_archived_log
dba_rule_set_rules
dba_rule_sets
dba_rules
dba_streams_global_rules
dba_streams_message_consumer
dba_streams_message_rules
dba_streams_newly_supported
dba_streams_rules
dba_streams_schema_rules
dba_streams_table_rules
dba_streams_transform_function
dba_streams_unsupported
dba_type_attrs
dba_type_methods
dba_types
DBArtisan
dbms_apply_adm
dbms_aqadm
dbms_capture
dbms_capture_adm
dbms_file_transfer
dbms_ftp_transfer
dbms_job
dbms_propagation_adm
dbms_redefinition
dbms_rule_adm
dbms_streams
dbms_streams_adm
dbms_streams_auth
dbms_streams_messaging
dbms_streams_messaging_enqueue
dbms_streams_tablespace_adm
DDL See Data Definition Language
DDL handler
DDL Handler
ddl_handler
ddl_rule_name
ddl_text
DELETE
Delete Conflict
delete_all_errors
delete_error
Delivery
destination_queue_name
DICTIONARY INITIALIZATION
dictionary_scn
disable_on_error
disable_on_limit
disable_propagation_schedule
Disaster Recovery
DISCARD
dmbs_aq
DML See Data Manipulation Language
DML Handler
DML handlers
dml_condition
dml_rule_name
Down Stream databases
Down Streams capture
drop_apply
drop_capture
drop_propagation
drop_unused_rule_sets
dual
Dynamic views
 
E
elapsed_apply_time
elapsed_capture_time
elapsed_dequeue_time
elapsed_enqueue_time
elapsed_lcr_time
elapsed_redo_wait_time
elapsed_rule_time
emsg_array
enable_propagation_schedule
enqueue_message_create_time
enqueue_time
ENQUEUING MESSAGE
error handler
error_handler
ERROR_HANDLER
EVALUATING RULE
evaluation_function
event enqueuing latency
Event propagation
execute_all_errors
execute_as_user
execute_error
expdp
Explicit Log Assignment
Extract Transform and Load
F
first_scn
flashback_scn
force
Foreign Key Conflict
FOREIGN KEY logging
G
gateways
get_base_table_owner
get_error_message
get_object_owner
get_scn_mapping
get_streams_name
get_streams_type
get_system_change_number
get_tag
Global rule
global_names
GoldenGate
grant_admin_privilege
gv$_buffered_queues
H
hist_upd
Hot Mining
hwm_message_create_time
hwm_message_number
I
Identification Key Logging
impdp
Implicit Log Assignment
include_ddl
include_dml
include_extra_attribute
include_tagged_lcr
inclusion_rule
Index Organized Tables
Informatica
init.ora
INITIALIZING
inittrans
INSERT
instantiation_scn
Interested Transaction List
J
job_queue_processes
L
LCR See Logical Change Record
lcr$_row_record
lcr_print_error
lcr_print_errors_all
lcr_print_values
LGWR
load_ny_allinsured.sql
LOADING
local_transaction_id
LOG DATA
LOG GROUP
log writer
log_archive_dest_
log_archive_dest_state_
log_archive_format
logfile_assignment
Logical Change Record
LogMiner
LogMiner Data Dictionary
logminer_session_name
logon_user
LONG
LONG RAW
Loose Consistency
M
Manager
max_checkpoint_scn
MAXIMUM
maximum_scn
MERGE
Message Handler
Message Systems
message_handler
message_limit
message_number
Messaging client
method_name
Minimal Logging
MINIMUM
MINING
msg_handler
multi-consumer queues
Multi-Way replication
N
NCLOB
negative_rule_set_name
new_values
nologging
O
Object Instantiation
object_name
object_owner
object_type
old_values
One-Way Replication
open_link
operation_name
OPERATION_NAME
Oracle Transparent Gateway
OVERWRITE
P
parallelism
PAUSED FOR FLOW CONTROL
pre-commit handler
pre-commit handlers
precommit_handler
prepare_global_instantiation
prepare_schema_instantiation
prepare_table_instantiation
Preparer server
PRIMARY KEY logging
primary_instance
producer and consumer
Propagation
Propagation process
publish and subscribe methodology
Q
queue table
R
re$variable_type
Read Consistency Model
Reader Server
Real Application Cluster
redo log scanning latency
remote_archive_enable
remove_apply_tag
remove_ddl_handler
remove_message_handler
remove_negative_rule_set
remove_precommit_handler
remove_queue
remove_rule_set
remove_streams_configuration
required_checkpoint_scn
REQUIRED_CHECKPOINT_ SCN
resolution columns
resolution_column
RMAN
ROLLBACK
row LCR
row_id
Rule Action Context
Rule Condition
Rule Evaluation Context
Rule sets
rule_condition
RULE_CONDITION
rule_set_name
RULE_SET_NAME
 
rule-based transformations
Rules Engine
S
Scalability
Schema rule
schema_name
SCHEMA_NAME
scn
secondary_instance
Secure queues
serial#
server_id
session#
session_privs
set_dml_handler
set_enqueue_destination
set_execute
set_global_instantiation_scn
set_key_columns
set_parameter
set_rule_transform_function
set_schema_instantiation_scn
set_table_instantiation_scn
set_tag
set_up_queue
set_update_conflict_handler
Shared Pool
shared_pool_size
SharePlex
show_capture_details.sql
SHUTTING DOWN
Snapshot based replication
source_database
source_database_name
SQL*Loader
standby_archive_dest
start_apply
start_capture
start_scn
startup_seconds
startup_time
Static views
steams_name
stop_apply
stop_capture
storage_clause
Streams AQ
Streams Clients
Streams pool
Streams Tags
streams_instantiation
streams_pool_size
streams_type
Subset rules
supplemental log group
Supplemental Logging
SYS.AnyData
sys.streams$_evaluation_context
System Change Number
System Global Area
T
Table rule
tag
thread#
Tight Consistency
time_limit
timed_statistics
total_admin
total_applied
total_assigned
total_full_evaluations
total_messages_applied
total_prefilter_discarded
total_prefilter_kept
total_received
trace_level
transaction_id
transaction_limit
transactional queues
transformation handlers
transformations
transport_tablespace
Two-Phase Commit
Two-Way Replication
tx_name
U
Unconditional Supplemental Log Groups
UNIQUE index
Uniqueness Conflict
unrecoverable
UPDATE
Update Conflict
use_database_link
user_procedure
USER_PROCEDURE
user-enqueued events
username
V
v$archived_log
v$buffered_publishers
v$buffered_queues
v$buffered_subscribers
v$capture_process
v$database
v$dblink
v$log
v$logmnr_contents
v$logmnr_dictionary
v$logmnr_logs
v$propagation_receiver
v$propagation_sender
v$queue
v$rule
v$rule_set
v$rule_set_aggregate_stats
v$session
v$streams_apply_coordinator
v$streams_apply_reader
v$streams_apply_server
v$streams_capture
W
WAITING FOR DICTIONARY REDO
WAITING FOR REDO
write_alert_log

Reviews:

 Click here to read the review of Oracle Streams by Lewis Cunningham.


Errata:
 

 

  Hit Counter

   

 Copyright ฉ 1996 -2016 by Burleson. All rights reserved.


Oracleฎ is the registered trademark of Oracle Corporation. SQL Serverฎ is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks