Oracle Streams基础元素与任务概述.pdfVIP

Objectives

Aftercompletingthisson,youshouldbeabletodothe

following:

•DescribetheOracleStreamsenvironment

•Listthethreebasictasks(capture,propaion,and

apply)forevents

•ObtainanoverviewofOracleStreamsimplementation

OracleStreams:BasicElements

•Astreamisaflowofinformationeitherwithina

databaseorfromonedatabasetoanother.

•OracleStreamsisasetofprocessesanddatabase

structuresthatenableyoutosharedataandmessages

inadatastream.

•Theunitofinformationthatisputintoastreamis

calledanevent:

–DDLorDMLchanges,formattedasanLCR

–User-createdevents

•Eventsarestagedinandpropaedweenqueues.

OracleStreams:BasicElements

•Threebasictasksofastream:

–Capture

–Staging

–Apply(consumption)

•Astreamcanperformmultipletasksacrossmultiple

databases.

CaptureStagingApply

Capture

YoucanceeventsinOracleStreams:

•Implicitly:Locallog-basedcaptureofDMLandDDL

changeseitherlocalorremote

•Explicitly:Directenqueueofusermessages

Capture

EventStaging

OracleStreamsusesastagingareathat:

•Isimplementedasaqueueinaqueuetable

•Supportstheself-describingdatatypeSYS.AnyData

•Stagescapturedeventsanduser-createdeventsinthe

samequeue

•Retainseventsuntiltheyareconsumedbyall

applicabletasks,processes,orapplications

Staging

Staging-AreaPropaion

Staging•Otherstagingareas

canreceiveevents:

–Fromaremote