Oracle

How SQL Server MVCC compares to Oracle and PostgreSQL

By Franck Pachot . Microsoft SQL Server has implemented MVCC in 2005, which has been proven to be the best approach for transaction isolation (the I in ACID) in OLTP. But are you sure that writers do not block readers(…)

Running SQL Server on the Oracle Free tier

By Franck Pachot The Oracle Cloud is not only for Oracle Database. You can create a VM running Oracle Linux with full root access to it, even in the free tier: a free VM that will be always up, never(…)

NVMe the afterburner for your database

Over 1 million IOPS (@8 KByte) and more than 26 GByte/s (@1MByte): Read more to see all impressive benchmark figures from a server with 14 NVMe drives and read why this is still not the best you could get...

Should I go for ODA 19.5 or should I wait until 19.6?

Introduction As you may know, Oracle Database 19c is available for new (X8-2) or older Oracle Database Appliances since several weeks. Current version is 19.5. But when you go to the official ODA documentation , it(…)

ROLLBACK TO SAVEPOINT;

By Franck Pachot . I love databases and, rather than trying to compare and rank them, I like to understand their difference. Sometimes, you make a mistake and encounter an error. Let's take the following example: create table DEMO (n(…)

Make Oracle database simple again!

Introduction Let’s have a look at how to make Oracle database as simple as it was before. Oracle database is a great piece of software, yes it’s quite expensive, but it’s still the reference and most of the companies can(…)

Dbvisit 9: Adding datafiles and or tempfiles

By Mouhamadou Diaw One question I was asking is if the standby_file_management parameter is relevant in a Dbvisit environment with Oracle Standard Edition. I did some tests and I show here what I did. We suppose that the Dbvisit(…)

Dbvisit Standby 9 : Do you know the new snapshot feature?

By Mouhamadou Diaw Dbvisit snapshot option is a new feature available starting from version 9.0.06. I have tested this option and in this blog I am describing the tasks I have done. The configuration I am using is following(…)

ARRAYSIZE or ROWPREFETCH in sqlplus?

ARRAYSIZE or ROWPREFETCH in sqlplus? What is the difference between the well known sqlplus-setting arraysize and the new sqlplus-12.2.-feature rowprefetch? In Blog https://www.dbi-services.com/blog/oracle-fasttrue-in-sqlplus-some-thoughts-about-rowprefetch/ I showed a case, which helps to reduce the logical IOs when(…)

Oracle FAST=TRUE in sqlplus? Some thoughts about rowprefetch

During my time as a Consultant working on Tuning Tasks I had the feeling that many people think that there is an Oracle-parameter “FAST=TRUE” to speed up the performance and throughput of the database calls. Unfortunately such a parameter is(…)