RDBMS Server

Oracle RDBMS Server Articles

DB 21c available for download


As from this weekend, it is here:


I'll certainly install it in the next few days, there are a few features I want to experiment with and I know our developers want to check out the new JSON features. Production use? I'm not sure. It being an "innovation" release only with no extended support makes me a bit dubious.

database block size - does it really matter?


What block size should you use? For what purpose? How about tablespaces in different block sizes? Any opinions?

Installing database 19c on Oracle Linux 8


Database release 19.7 (ie, 19c with the April 2020 RU) is at last certified for OL8, but there may be some hacking needed to get it installed.

This certification is long overdue: our security admin has been pushing for the 5.x kernel for some time, and OL7 still only supports kernel 4.x. I'm starting to move some production systems over now using the July RUR, which takes the release to 19.7.1.

Begin by installing the Oracle Validated rpm from the ol8_UEKR6 repository:

yum install oracle-database-preinstall-19c

Database 20c docs


Now available!

Going through the New Features guide, there is a shed load of wonderful enhancements. Then you look at the Licensing guide, and most of them require Exadata or Oracle Cloud or both.

Recover a database using RMAN but failing to open redo


When using RMAN to restore and recover the database, it seems to work OK - no obvious errors during the restore / recovery, as far as I can see. The issue seems to be when I try to 'alter database open resetlogs'... after this the database shuts down. At this point, I don't really care about losing some of our data, this is just a test system, my main concern is how to get the database working again.

Oracle version 12.1.0.

1. I startup with nomount.

RMAN> startup nomount;



Written JP Vijaykumar
Date Jan 4th 2020
Modified Jan 5th 2020
This article/script is provided for educational purpose ONLY.
The readers are advised to make necessary changes to the script as may be required for their use in their respective environments.
Pls test these scripts thoroughly in a lower environment, ONLY if you are satisfied with the tests' results, then ONLY use in any

How to move a table from one schema to another


Many times I've seen the question on forums "How can I move a table from one schema to another?" and the answer is always that you can't. You have to copy it. Or export/import it. Well, here's a way. It assumes that you are on release 12.x and have the partitioning option.

19c Standard Edition permits 3 PDBs per CDB


A very nice licensing change in 19c: you can now have up to three PDBs in a Standard Edition Multitenant database.

Compression test, 12cR2


Just how effective is Hybrid Columnar Compression? This test shows that HCC is impressive, but that thought needs to be put into choice of compression algorithm.


Subscribe to RSS - RDBMS Server