Novas Views do Goldengate 12C

Oracle 12c GoldenGate View

Show data dictionary views and x$ tables matching the expression “v$GG”…

TABLE_NAME COMMENTS
—————————— ——————————————————————————–
V$GG_APPLY_COORDINATOR Synonym for V_$GG_APPLY_COORDINATOR
V$GG_APPLY_READER Synonym for V_$GG_APPLY_READER
V$GG_APPLY_RECEIVER Synonym for V_$GG_APPLY_RECEIVER
V$GG_APPLY_SERVER Synonym for V_$GG_APPLY_SERVER
GV$GG_APPLY_COORDINATOR Synonym for GV_$GG_APPLY_COORDINATOR
GV$GG_APPLY_READER Synonym for GV_$GG_APPLY_READER
GV$GG_APPLY_RECEIVER Synonym for GV_$GG_APPLY_RECEIVER
GV$GG_APPLY_SERVER Synonym for GV_$GG_APPLY_SERVER

8 rows selected.

TABLE_NAME USED_IN
—————————— ——————————
GV$GG_APPLY_RECEIVER V$GG_APPLY_RECEIVER
V$GG_APPLY_RECEIVER V$GG_APPLY_RECEIVER
GV$GG_APPLY_COORDINATOR V$GG_APPLY_COORDINATOR
V$GG_APPLY_COORDINATOR V$GG_APPLY_COORDINATOR
GV$GG_APPLY_SERVER V$GG_APPLY_SERVER
V$GG_APPLY_SERVER V$GG_APPLY_SERVER
GV$GG_APPLY_READER V$GG_APPLY_READER
V$GG_APPLY_READER V$GG_APPLY_READER

V$GOLDENGATE_CAPABILITIES Synonym for V_$GOLDENGATE_CAPABILITIES
V$GOLDENGATE_CAPTURE Synonym for V_$GOLDENGATE_CAPTURE
V$GOLDENGATE_MESSAGE_TRACKING Synonym for V_$GOLDENGATE_MESSAGE_TRACKING
V$GOLDENGATE_TABLE_STATS Synonym for V_$GOLDENGATE_TABLE_STATS
V$GOLDENGATE_TRANSACTION Synonym for V_$GOLDENGATE_TRANSACTION
GV$GOLDENGATE_CAPABILITIES Synonym for GV_$GOLDENGATE_CAPABILITIES
GV$GOLDENGATE_CAPTURE Synonym for GV_$GOLDENGATE_CAPTURE
GV$GOLDENGATE_MESSAGE_TRACKING Synonym for GV_$GOLDENGATE_MESSAGETRACKING
GV$GOLDENGATE_TABLE_STATS Synonym for GV_$GOLDENGATE_TABLE_STATS
GV$GOLDENGATE_TRANSACTION Synonym for GV_$GOLDENGATE_TRANSACTION

10 rows selected.

TABLE_NAME USED_IN
—————————— ——————————
GV$GOLDENGATE_CAPABILITIES V$GOLDENGATE_CAPABILITIES
V$GOLDENGATE_CAPABILITIES V$GOLDENGATE_CAPABILITIES
GV$GOLDENGATE_TABLE_STATS V$GOLDENGATE_TABLE_STATS
V$GOLDENGATE_TABLE_STATS V$GOLDENGATE_TABLE_STATS
GV$GOLDENGATE_CAPTURE V$GOLDENGATE_CAPTURE
V$GOLDENGATE_CAPTURE V$GOLDENGATE_CAPTURE
GV$GOLDENGATE_TRANSACTION V$GOLDENGATE_TRANSACTION
V$GOLDENGATE_TRANSACTION V$GOLDENGATE_TRANSACTION
GV$GOLDENGATE_MESSAGE_TRACKING V$GOLDENGATE_MESSAGE_TRACKING
V$GOLDENGATE_MESSAGE_TRACKING V$GOLDENGATE_MESSAGE_TRACKING

TABLE_NAME COMMENTS
—————————— ——————————————————————————–
DBA_HIST_APPLY_SUMMARY Streams/Goldengate/XStream Apply Historical Statistics Information
DBA_HIST_REPLICATION_TBL_STATS Replication Table Stats For GoldenGate/XStream Sessions
DBA_HIST_REPLICATION_TXN_STATS Replication Transaction Stats For GoldenGate/XStream Sessions
DBA_HIST_CAPTURE Streams/GoldenGate/XStream Capture Historical Statistics Information
DBA_HIST_SESS_SGA_STATS SGA Usage Stats For High Utilization GoldenGate/XStream Sessions
DBA_HIST_SESS_TIME_STATS CPU And I/O Time For High Utilization Streams/GoldenGate/XStream sessions

Replication System Resource Usage

System resource usage of GoldenGate/XStream processes aggregated by Session Type and Session Module
Data is ordered by CPU Time in descending order, followed by Session Type and Session Module in ascending order

Session Type Session Module First Logon CPU Time(s) User IO Wait Time(s) System IO Wait Time(s)
Capture GoldenGate 25-Oct-13 13:54:43 17.60 2.20 0.00
Apply Receiver GoldenGate 25-Oct-13 11:51:56 4.33 0.60 0.00
Apply Reader GoldenGate 25-Oct-13 11:51:56 3.60 0.00 0.00
Logminer Preparer GoldenGate 25-Oct-13 13:54:44 0.40 0.11 0.00
Apply Server GoldenGate 25-Oct-13 11:51:56 0.34 0.13 0.00
Logminer Builder GoldenGate 25-Oct-13 13:54:44 0.32 0.04 0.00
Logminer Reader GoldenGate 25-Oct-13 13:54:44 0.20 0.00 0.02
Apply Coordinator GoldenGate 25-Oct-13 11:51:56 0.00 0.00 0.00

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

Replication SGA Usage

SGA usage of Streams Pool for GoldenGate/XStream processes ordered by SGA Used %Diff, SGA Allocated %Diff, Component in descending order
For each Capture (Object Name), reporting memory used by Capture and Logminer processes at the Begin and End snapshots
For each Apply (Object Name), reporting memory used by each Apply process at the Begin and End snapshots
% SGA Util refers to the percentage of allocated memory used at the End snapshot
Memory usage is displayed in Megabytes

Component Session Module Object Name SGA Used Begin Snap SGA Used End Snap SGA Used %Diff SGA Allocated Begin Snap SGA Allocated End Snap SGA Allocated %Diff % SGA Util
Logminer GoldenGate OGG$CAP_EXT1 4.17 4.25 1.92 199.00 199.00 0.00 2.14
Capture GoldenGate OGG$CAP_EXT1 4.18 4.26 1.91 199.00 199.00 0.00 2.14
Apply GoldenGate OGG$RPEE1 3.01 3.00 -0.33 3.02 3.04 0.66 98.

Sobre Alexandre Pires

ORACLE OCS Goldengate Specialist, OCE RAC 10g R2, OCP 12C, 11g, 10g , 9i e 8i - Mais de 25 anos de experiência na área de TI. Participei de projetos na G&P alocado na TOK STOK, EDINFOR alocado na TV CIDADE "NET", 3CON Alocado no PÃO DE AÇUCAR, DISCOVER alocado na VIVO, BANCO IBI e TIVIT, SPC BRASIL, UOLDIVEO alocado no CARREFOUR e atualmente na ORACLE ACS atendendo os seguintes projetos: VIVO, CLARO, TIM, CIELO, CAIXA SEGUROS, MAPFRE, PORTO SEGURO, SULAMERICA, BRADESCO SEGUROS, BANCO BRADESCO, BASA, SANTANDER, CNJ, TSE, ELETROPAULO, EDP, SKY, NATURA, ODEBRESHT, NISSEI, SICREDI, CELEPAR, TAM, TIVIT, IBM, SMILES, CELEPAR, SERPRO,OKI,BANCO PAN, etc
Nota | Esse post foi publicado em GOLDENGATE. Bookmark o link permanente.

Deixe uma resposta

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s