Stack Overflow
Stack Overflow

Questions tagged [oracle-streams]

22 questions
12
votes
2 answers

What is the difference between Oracle Streams and Change Data Capture?

There are several similar Oracle technologies - Oracle Streams, Oracle Change Data Capture and Database Change Notification. What are the differences between these? Are they related to Oracle Advanced Queueing?
Petr Sturc
7
votes
2 answers

Show me an simple example of Oracle Streams?

I am just getting started with on a project and hope to use Oracle streams. I am looking for a straight-forward, hello-world type of example using Oracle Streams. Can you point me to a tutorial or show me an example? Thanks
jeph perro
  • 6,242
  • 26
  • 90
  • 124
3
votes
2 answers

How to integrate Oracle and Kafka

I've been trying to find the most efficient/effective way capture change notifications in a single Oracle 11g R2 instance and deliver those events to an Apache Kafka queue, but I haven't been able to find any simple examples or tutorials along these…
rcurrie
  • 329
  • 1
  • 3
  • 17
3
votes
3 answers

Is Oracle AQ/Streams of any use in my situation?

I'm writing a workflow system that is driven entirely at each step by explicit human interaction. That is, a task is assigned to a person, that person selects from a few limited options {approve, reject, forward}, and then it is either sent along…
aw crud
  • 8,791
  • 19
  • 71
  • 115
3
votes
1 answer

Sending a JMS Message from Oracle Database on DML Event

I'm trying to determine if it is possible to configure Oracle Database 11g to send a JMS message to a broker (ActiveMQ in my case) when a particular DML event (say an insert or update to a particular table) occurs so that I can process this event in…
Andre
  • 1,601
  • 3
  • 15
  • 15
2
votes
2 answers

Using Oracle Streams to implement audit trails

I'm going to implement asynchronous audit trails functionality for highly loaded system with using of Oracle Streams (for log mining on redo and archive logs). Audit trails in my case mustn't slow down any DML operations over set of my tables. Also…
Volodymyr Frolov
  • 1,256
  • 5
  • 16
  • 25
2
votes
2 answers

Selective dequeue of unrelated messages in Oracle Advanced Queueing

This question refers to the dequeueing of messages in Oracle Streams Advanced Queueing. I need to ensure that the messages which are related to each other are processed sequentially. For example, assume the queue is seeded with the four messages…
Synesso
  • 37,610
  • 35
  • 136
  • 207
2
votes
1 answer

Oracle streams and denormalization

I intend to use Oracle Streams for replication from Source to Target. The Target will be used mainly to run Reports. Earlier, all the reports used to run on the Source itself. Therefore, this arrangement gives better performance as all report…
Sathya
  • 2,371
  • 5
  • 19
  • 27
1
vote
2 answers

Oracle Streams error logs not showing timestamp values

When outputting a log of streaming errors on Oracle 10g, the log does not show values for timestamp fields; instead it simply shows "timestamp is SYS.TIMESTAMP" as the old and new value. Is there any way to configure Oracle streams to show the…
Templar
  • 5,067
  • 7
  • 34
  • 39
1
vote
0 answers

Oracle database changes to some MQ client

Hi Oracle DB guys out there, Is there a way to propagate DML changes in database to some MQ server(Kafka in my case). I have read about following but coulnt find any concrete implementation oracle streams:- which are for database to database…
maverick
  • 1,458
  • 5
  • 20
  • 28
1
vote
1 answer

Replicated database for storing historical data

Only part of the data in the database is being processed by the application, the rest is necessary for reporting purposes, but it causes poor application performance. I would like to archive historical data without modifying database schema. Is…
kar8o
  • 41
  • 5
0
votes
0 answers

RMAN does not delete archive logs not applied on GG Downstream

There is an issue in a topology of 3 hosts. Primary has a scheduled OS-task (every hour) to delete archive logs older 3 hours with RMAN. Archivelog deletion policy is configured to "Applied on all standby". There are 2 remote log_archive_dest…
WareNick
  • 1
  • 2
0
votes
1 answer

How do we determine if the size of the payload/message exceeds 32K?

According to Oracle's Streams Advanced Queuing User's Guide and Reference: "To store a payload of type RAW, Oracle Streams AQ creates a queue table with LOB column as the payload repository. The maximum size of the payload is determined by which…
PurpleGreen
  • 39
  • 8
0
votes
0 answers

The proper way to record DML and DDL changes to specified tables, schemas or entire oracle database

I am finding a resolution to record DML and DDL changes made to specified Oracle schemas or tables dynamically, which meaning that schemas and tables monitored can be changed in application run time. In a word, I am going to achieve an Oracle…
ZanXus
  • 1
  • 2
0
votes
1 answer

Can't create a JMS stream in Oracle Stream Analytics

I'm trying out Oracle Stream Analytics 12.2.1 and want to create a stream to receive JMS messages from my ActiveMQ broker in the standalone server domain that I set up. I have a minimal setup with Java 8 on Windows Server 2012 R2 (only installed…
natonic
  • 39
  • 1
  • 3
1
2