My Oracle Support Banner

RDBPROD: Are record changes made in my previous READ WRITE transaction visible in my new READ ONLY transaction? (Doc ID 1592384.1)

Last updated on APRIL 18, 2022

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0.1 and later
HP OpenVMS Alpha
HP OpenVMS Itanium

Goal

Rdb provides additional concurrency by using snapshot copies, stored in separate files, but how up-to-date is the data in a READ ONLY transaction? For example, if I perform a series of updates in a READ WRITE transaction will these be available when I start a READ ONLY immediately after?
 

NOTE: The data used below are not actual PRODUCTION or Customer Data.  They are being used ONLY to demonstrate the problem discussed in this note.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.