Persistent, cross database and cross region pipe in Oracle Database 23ai
We know pipes in Oracle Database to be an in memory mechanism, ephemeral with loss of data when the database instance is stopped. With limitations on size of messages …
Tag: oracle database
Multi-read Large Message Singleton Oracle Database Pipe– cache for shared context
Database Pipes have been around in Oracle Database since release 7. In memory, light weight, non-persistent, fast and a little low level. Somewhat brittle: the contents of a pipe …
Getting started with Oracle Database 23ai – in five minutes and for free
Yesterday I noticed an announcement of the latest Oracle Database release: 23ai. A long term support release – so one we will be able to use for many years. …
Automated and Rapid Creation of Non-Production Oracle Databases for Test and Development
The production database is the holy grail of any organisation or at least any microservice or business application. The data and the current structures and definitions of the database …
Oracle Database 23c as Graph Database–SQL Property Graph for network style querying
I bet you are used to relational data structures that you query using SQL. And so do I. And there is nothing in terms of data that a good …
Live Handson Environment for Modern Oracle Database Programming
My fellow Oracle ACE Directors and former AMIS-colleagues Patrick Barel and Alex Nuijten have co-authored an impressive book: The book discusses many of the wonders of SQL and PL/SQL …
Oracle Database 23c–Fine Grained Locking–Lock Free Reservations
This should surprise if not baffle you. Session 1 inserts a record and commits it. Session 1 performs an update on this record. And does not yet commit its …
Get going with Oracle Database 23c Free
A new major Oracle Database release is a special occasion. I joined Oracle in May 1994 just after the Oracle7 release (December 1993) although I worked with Oracle6 for …
Unified Auditing not possible for Oracle Database XE (Express Edition)
I recently tried to get Unified Auditing going for Oracle Database XE. I could not really find instructions – not even through ChatGPT – and finally reached out to …
One click free browser based Oracle Database environment with Gitpod
This article describes how you can run your very own Oracle Database from your browser using Gitpod. With a free account (50 hours Gitpod use per month), you can …
Oracle Database 23c–new feature highlights (release February 2023?)
Based on the fascinating Twitter thread by Philipp Salvisberg covering the presentation by Gerald Venzl at DOAG 2022 I would like to mention a few of the features that …
Delay in establishing RAC Database connections after upgrading from Oracle 11g.
After upgrading to Oracle 12c, 19c, database connections take a long time (10 sec or more), before the connections are established. The connection time was less than 0.5 sec …
Executing JavaScript from PL/SQL in Oracle Database 21c with Multi Language Engine
Oracle Database Release 7 – end of 1993 – introduced PL/SQL as language for Stored Procedures, Functions and Triggers. This was just before I joined Oracle Corporation, in May …
SQL–Only Counting Records Sufficiently Spaced apart using Analytics with Windowing Clause and Anti Join
A nice SQL challenge was presented to me by a colleague. The challenges basically consisted of this table. A table contains records that describe login events. Each record has …
First code and cli free steps with Oracle Database 21c in Oracle Cloud
Oracle Database 21c has been released – for now only in the cloud. Starting to explore – that is what we call playing with it – it easy and …
Oracle Database – more value for money and more value for free
Oracle is not known for low prices or free products. However, when it comes to the Oracle Database there are some developments that might be of interest to you. …
Oracle Cloud Always Free Autonomous Data Warehouse – steps to get going
Last month, Oracle announced it’s Cloud Free Tier on Oracle Cloud Infrastructure (OCI). This free tier offers several services (compute, storage, network, monitoring & notifications, serverless functions and Autonomous …
Monitoring Oracle Database using Prometheus
Prometheus is a very popular framework for gathering metrics from a plethora of runtime components, recording, analyzing, visualizing them and making them available for companion technologies such as Grafana. …
Extremely convenient way to run free Oracle Database 18c on your laptop – or anywhere else – using Vagrant & Virtual Box
Oracle Database 18c XE (eXpress Edition) is the free community edition of the enterprise edition of Oracle Database. Oracle Database XE has almost all features of Oracle Database; however, …
CQRS through Twitter – more fun than meaning
As part of my 50 Shades of Data presentation, I talk about CQRS – Command Query Responsibility Segregation. The idea that you can have one or more read only …
Quickly spinning up Docker Containers with baseline Oracle Database Setup – for performing automated tests
Here is a procedure for running an Oracle Database, preparing a baseline in objects (tables, stored procedures) and data, creating an image of that baseline and subsequently running containers …
Dbvisit Standby upgrade
Upgrading to Dbvisit Standby 8.0.x Dbvisit provides upgrade documentation which is detailed and in principle correct but only describes the upgrade process from the viewpoint of an installation on …
Getting started with Oracle Database in a Docker container!
One of the benefits of using Docker is quick and easy provisioning. I wanted to find out first-hand if this could help me get an Oracle Enterprise Edition database …
Oracle Database standard Geo Location Support using Locator (included in every edition!)
Many databases have native support for locations en geodata – and determining distance and closest locations (within a certain perimeter). Oracle Database has the Spatial Option – that supports …
Fastest creation of a Lean VirtualBox VM Image with Oracle Database 11gR2 XE, the Node.JS 7.x and the Oracle DB Driver for Node
For a workshop on Node.js I needed a VM to demonstrate and students try out the Oracle DB Driver for Node. I wanted a lean VM with the bare …
Oracle Database 12c Release 2 is out – just only on the cloud
The next major release of the Oracle Database has always been a big thing. Last year at Oracle OpenWorld , a lot of sessions were dedicated to Release 2 …
New PL/SQL pragma (12cR2) to deprecate program units – sign of a modern programming language
Bryn Llewellyn (Distinguished Product Manager, Database Division, Oracle) presented at OOW2016 on new features in PL/SQL in Oracle Database 12cR2. One of the features that stood out was a …
Set values for bind parameters in a database view using application context – single round-trip context manipulation and querying
While writing an article on database session context for the OTech Magazine’s Spring issue, I tried out whether I can send a SQL statement from a database consumer such …
When to use the Oracle Database In-Memory option?
September 22, 2014
Architecture, Data Warehousing & BI, Databases, Digtial Innovation, Oracle 12
1 Comment
The application and usage of the Oracle Database In-Memory has been described by Pom Bleeksma in this post. Oracle Database In-Memory can result in huge improvement in application query …
Quick generation of a VirtualBox VM with Oracle Database 12.1.0.2 EE on CentOS 5.6
A short time ago, Oracle released Oracle Database 12c – release 12.1.0.2. With a bunch of goodies that I would like to try out. This release can be downloaded …
Using Oracle’s Edition-Based Redefinition to support multiple SOA Suite revisions with the database adapter
When using the Oracle SOA Suite for web service development, chances are that you are also using an Oracle database and that you are at some point in need …
OOW 2012 – Larry Ellison’s Keynote Announcements: Exa, Cloud, Database
Last night, Oracle Open World 2012 kicked off with the keynote session by Larry Ellison. In just under one hour, and with a novelty for Larry watchers (no more …