Infrastructure at your Service

Tag

Oracle Archives - Blog dbi services

Oct 05 2021
Lazhar Felahi

SELECT FROM DUAL : Oracle Performance And Tuning

By | Database Administration & Monitoring, Development & Performance, Oracle | No Comments

The DUAL table is automatically created by Oracle and contains one column (DUMMY) and one row (x value). This table is often used by SQL developer in PL/SQL code (Package, Functions, Trigger) to initialize variables storing technical information such as for example SYSDATE, USER or HOSTNAME. Querying DUAL table is generally faster  as we can see below: SQL> select sysdate from dual; SYSDATE ——— 05-OCT-21 Elapsed: 00:00:00.01 Execution Plan ———————————————————- Plan hash value: 1388734953 —————————————————————–…

Read More
Aug 12 2021
Marc Wagner

Nutanix Era with oracle databases : Part 1 – Introduction

By | Oracle | No Comments

I’m currently setting up a lab for Nutanix Era in order to be able to provide some presentation on this subject and see how Nutanix Era interacts with Oracle databases. I therefore thought it would be certainly helpful and a good opportunity to share the feedback I’m getting from this experience. The lab has been built using Nutanix Cluster free trial integrated with our AWS Cloud account. This fist blog intends to provide only a…

Read More
May 26 2021
Oracle Team

Amazon RDS Oracle in Multitenant

By | AWS, Oracle | 2 Comments

By Franck Pachot . AWS has just added the possibility to create your oracle Database as as CDB (Container Database), the “new” architecture of Oracle where an instance can manage multiple databases, adding a new level between the heavy instance and lightweight schema: At the time I’m writing this, I see it only in the “old” console (“original interface”) not in “new database creation flow”. It is displayed as a different Edition, however it is…

Read More
May 14 2021
Oracle Team

El Carro: The Oracle Operator for Kubernetes

By | Kubernetes, Oracle | One Comment

By Franck Pachot . Google Cloud, Open Source and Oracle Databases… what seems to be a paradox is possible, thanks to cloud providers who contribute to open infrastructure. The idea is to use Operators (custom resource controllers on Kubernetes) to automate the Oracle Database operations in a standard, open and portable way. If you ever attempted to run Oracle Database on containers, trying to keep up with the DevOps approach, you know that it requires…

Read More
May 05 2021
Oracle Team

Delphix and upgrading the clones (Oracle)

By | Postgres | No Comments

By Franck Pachot . Delphix is a tool for easy cloning of databases. The idea is that all is automated: the user can create a clone, rewind or refresh it with one click. However, I was suprised that the following common scenario is not managed by the Delphix engine: You clone from production, say Oracle 12c You upgrade the clone, say Oracle 19c You test there You refresh the clone from production, obviously being back…

Read More
Apr 30 2021
Oracle Team

An example of ORA-01152: file … was not restored from a sufficiently old backup

By | Oracle | One Comment

By Franck Pachot . Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file … was not restored from a sufficiently old backup ORA-01110: data file … This error is one of the most misunderstood recovery error. It can happen in different case but I have here a simple example to reproduce it, with some comments and queries to see the state. I run an example to avoid long theory…

Read More
Apr 02 2021
Dieter Henig

Rename your DB clone completely

By | Database Administration & Monitoring, Database management, Oracle | 2 Comments

Introduction Have you ever renamed your database? When you cloned a DB, you probably started it with a new name and cloning (duplicating) with RMAN provided a new DBID, right? So why should we need to rename a DB? There may be several reasons: due to changed company rules, you need to rename all your DBs After a restore you need to run the DB with another name After a snapshot clone, (see my recent…

Read More
Apr 01 2021
Oracle Team

Some Artificial Intuition in Oracle SQL_ID?

By | Oracle | One Comment

By Franck Pachot . This post is something I discovered by chance when writing about tagging SQL statement with recognizable comments. We know that Oracle is introducing more and more artificial intelligence and machine learning in the database engine, but here is the first time I see something where random or hash values seems to bring some meaning. There are two common ways to run a query and find it in V$SQL: add some tag…

Read More
Mar 16 2021
Oracle Team

Oracle – testing resource manager plans?

By | Database Administration & Monitoring, Oracle | 3 Comments

By Franck Pachot . I never remember that in order to use instance caging you need to set a Resource Manager Plan but don’t need to set CPU_COUNT explicitly (was it the case in previous versions?). Here is how to test it quickly in a lab. SQL> startup force ORACLE instance started. SQL> show spparameter resource_manager_plan SID NAME TYPE VALUE ——– —————————– ———– —————————- * resource_manager_plan string SQL> show spparameter cpu_count SID NAME TYPE VALUE…

Read More
Mar 02 2021
Oracle Team

Delphix: a glossary to get started

By | Oracle | No Comments

By Franck Pachot . dbi-services is partner of Delphix – a data virtualization platform for easy cloning of databases. I’m sharing a little glossary to get started if you are not familiar with the terms you see in doc, console or logs. Setup console The setup console is the first interface you will access when installing Delphix engine (“Dynamic Data Platform”). You import the .ova and start it. If you are on a network with…

Read More