Infrastructure at your Service

Oracle Archives - Page 3 of 38 - Blog dbi services

Franck Pachot

ADWC – the hidden gem: Zepplin Notebook

By | Oracle | 3 Comments

In the previous blog posts I explained how to create, and stop/start the Autonomous Data Warehouse Cloud service. And I didn’t show yet how to connect to it. It is easy, from sqlplus or SQL Developer, or SQLcl. But there’s something more exciting to run some SQL queries: the Oracle Machine Learning Notebooks based on Apache Zepplin. At first, I didn’t realize why the administration menu entry to create users in the ADWC service was…

 
Read More
Franck Pachot

ADWC – a Docker container to start/stop Oracle Cloud services

By | Oracle | One Comment

In the previous post, I’ve explained how to start and stop the Autonomous Data Warehouse Cloud service from PSM (PaaS Service Manager). There’s a setup phase, and a run phase starting with service-start and ending with service-stop. And the setup is specific to an Oracle Cloud account, storing information in the local user home. You may want to run different setups, and even provide an easy way to start/stop an Oracle Cloud service without knowing…

 
Read More
Franck Pachot

ADWC: start/stop with PSM Command Line Interface

By | Oracle | No Comments

In the previous post, I explained how to create an Autonomous Data Warehouse with PSM (PaaS Service Manager Command Line Interface). The most common operation you want to do with it is starting and stopping the service. This is the best way to save credits for hourly billed services. And PSM is the easiest: run from everywhere (it is Python 3) and no need to provide credentials each time. In the previous post, I explained…

 
Read More
Franck Pachot

ADWC: Creation of Autonomous Data Warehouse Cloud service

By | Cloud, Oracle | 4 Comments

You want to try the Autonomous Data Warehouse Cloud Service? That’s easy. Here is a Step-by-Step. Cloud Credits First, you need Cloud Credits. You may have bought them (any recent negotiation with Oracle Sales, even for on-premises, involves some Cloud Credits). You can have a free trial with 300$ Cloud Credits available for 1 month. To get another month, you need a different e-mail address and different Credit Card number (not charged). It is quite…

 
Read More
Franck Pachot

Covering indexes in Oracle, and branch size

By | Oracle | No Comments

A covering index is an index that contains all the columns required by your query, so that you don’t have to do a TABLE ACCESS BY INDEX ROWID, which is the major cost of an index range scan. You don’t need any special feature to do that in Oracle. Just add the required columns at the end of the index. In the execution plan you will see the columns used as index keys for the…

 
Read More
Marc Wagner

Dbvisit Standby Archive Log Daemon

By | Database Administration & Monitoring, Oracle | No Comments

Dbvisit Standby version 8 comes with a nice feature, a daemon, which gives the benefit to send and apply the archive log automatically in the background. Bypassing the system scheduling, the daemon will facilitate customer RPO (Recovery Point Objective) and RTO (Recovery Time Objective) fine tuning. Monitoring to apply logs to the Standby only when needed, will also optimize use of resources. Originally available for the Linux based environments, the feature has been made available…

 
Read More
Clemens Bleile

sqlplus and its column output

By | Database Administration & Monitoring, Database management | No Comments

During tuning or normal DBA activities one of the most annoying things is sqlplus with its default column output when running queries. I.e. even after setting a linesize of 1000 and a pagesize of 1000 the output may look as follows in your preferred terminal emulation (putty here): Most people address this by using other tools like sqldeveloper (or sqlcl with sqlformat ansiconsole). However, a lot of people still use sqlplus. How can you address…

 
Read More
Franck Pachot

Docker: efficiently building images for large software

By | Oracle | No Comments

I see increasing demand to build a Docker image for the Oracle Database. But the installation process for Oracle does not really fit the Docker way to install by layers: you need to unzip the distribution, install from it to the Oracle Home, remove the things that are not needed, strop the binaries,… Before addressing those specific issues, here are the little tests I’ve done to show how the build layers increase the size of…

 
Read More
Jérôme Dubar

How reimaging detects the ODA hardware?

By | Database Administration & Monitoring | No Comments

A long time ago, ODA referred to the only model that existed (nearly). Actually, not so long time ago, as ODA X3, X4 and X5 were released between 2013 and 2015. And it was quite the same hardware. Now there is 3 current models in the X7 range, and they were 4 in the previous generation (X6). ODA is now divided in 2 main lines. High Availability models, understand 2 nodes and a shared storage…

 
Read More