Infrastructure at your Service

Tag

Oracle 19c Archives - Blog dbi services

Mouhamadou Diaw

Reimaging an ODA to 19.8 Part II

By | Database Administration & Monitoring, Database management, Operation systems, Oracle | No Comments

In my previous blog, I described the steps to deploy an ODA 19.8 by reimaging. The ODA was reimaged with the latest available version 19.8 but some components were not up-to-dated. [[email protected] ~]# odacli describe-component System Version ————— 19.8.0.0.0 Component Installed Version Available Version —————————————- ——————– ——————– OAK 19.8.0.0.0 up-to-date GI 19.8.0.0.200714 up-to-date DCSAGENT 19.8.0.0.0 up-to-date ILOM 4.0.4.38.a.r132148 4.0.4.51.r134837 BIOS 52020500 52021300 OS 7.8 up-to-date FIRMWARECONTROLLER VDV1RL02 VDV1RL04 FIRMWAREDISK 1120 1102 HMP The patch was…

Read More
Franck Pachot

19c: scalable Top-N queries without further hints to the query planner

By | Oracle | No Comments

By Franck Pachot . The FETCH FIRST … ROWS ONLY syntax arrived in Oracle 12c and is much more convenient than using a subquery with ‘ORDER BY’ wrapped in a “WHERE ROWNUM < …” around it. But as I mentioned in a previous post it required the FIRST_ROWS() hint to get correct estimations. In SQL you don’t want to overload your code for performance, right? The RDBMS optimizer does the job for you. This was…

Read More
Franck Pachot

No{Join,GroupBy}SQL – Analytic Views for BI

By | Cloud, Oracle | No Comments

By Franck Pachot . Advocates of NoSQL can query their structures without having to read a data model first. And without writing long table join clauses. They store and query a hierarchical structure without the need to follow relationships, and without the need to join tables on a foreign key name, in order to get a caption or description from a lookup table. The structure, like an XML or JSON document, provides metadata to understand…

Read More
Franck Pachot

Oracle Standard Edition on AWS ☁ socket arithmetic

By | AWS, Cloud, Oracle | No Comments

By Franck Pachot . Note that I’ve written previously about Oracle Standard Edition 2 licensing before but a few rules change. This is written in May 2020. TL;DR: 4 vCPU count for 1 socket and 2 sockets count for 1 server wherever hyper-threading is enabled or not. The SE2 rules I think the Standard Edition rules are quite clear now: maximum server capacity, cluster limit, minimum NUP, and processor metric. Oracle has them in the…

Read More
Franck Pachot

20c: AWR now stores explain plan predicates

By | Oracle | No Comments

By Franck Pachot . In a previous post https://blog.dbi-services.com/awr-dont-store-explain-plan-predicates/ I explained this limitation in gathering filter and access predicates by Statspack and then AWR because of old bugs about reverse parsing of predicates. Oracle listens to its customers through support (enhancement requests), though the community (votes on database ideas), and through the product managers who participate in User Groups and ACE program. And here it is: in 20c the predicates are collected by AWS and…

Read More
Mouhamadou Diaw

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

By | Database Administration & Monitoring, Oracle | No Comments

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 dbvist1 : primary server dbvist 2 : standby server orcl : oracle 19c database We suppose that the dbvisit environment is already set and the replication is going fine. See previous blog for setting up dbvisit standby First there…

Read More
Clemens Bleile

Oracle 19c

By | Database Administration & Monitoring, Oracle | No Comments

Oracle 19c has been released quite a while ago already and some customers already run it in Production. However, as it is the long term supported release, I thought I blog about some interesting information and features around 19c to encourage people to migrate to it. Download Oracle 19c: https://www.oracle.com/technetwork/database/enterprise-edition/downloads or https://edelivery.oracle.com (search e.g. for “Database Enterprise Edition”) Docker-Images: https://github.com/oracle/docker-images/tree/master/OracleDatabase Oracle provides different offerings for 19c: On-premises: – Oracle Database Standard Edition 2 (SE2) –…

Read More
Mouhamadou Diaw

Oracle 19c : Point-In-Time Recovery in a PDB

By | Database Administration & Monitoring, Oracle | 2 Comments

Point-In-Time Recovery is also possible in a multitenant environment. As in Non-CDB, a recovery catalog can be used or not. In this blog we will see how to recover a dropped tablespace in a PDB. We will also see the importance of using a recovery catalog or not. A PITR of a PDB does not affect remaining PBDs. That means that while doing a PITR in PDB, people can use the other PDBs. In this…

Read More
Mouhamadou Diaw

RMAN in a Multitenant Environment

By | Database Administration & Monitoring, Oracle | One Comment

The Oracle Multitenant architecture came with Oracle 12c a few years ago. For people usually working with traditional Non-CDB database it might be confusing the first time to do Backup and Recovery with pluggable databases (PDBs) In this document we are trying to explain how to use RMAN backup and recovery in a multitenant environment for an oracle 19c database with 2 pluggable databases. Below the configuration we are using. SQL> show pdbs CON_ID CON_NAME…

Read More
Mouhamadou Diaw

dbvisit 9: Automatic Failover

By | Database Administration & Monitoring | 3 Comments

dbvisit 9 is released since a few months. And one new feature I tested is the Automatic Failover. In this blog I suppose that dbvisit 9 is already installed and that the standby database is already created. Indeed I will not describe nor dbvisit installation neither the standby creation as it is the same as the previous versions. For more info about dbvisit installation and/or dbvisit standby creation please see these steps in my previous…

Read More