Had a very interesting and tricky scenario a few days ago. It was something I never encountered in my DBA career. Hence, thought of sharing the detail of there store here today. Challenge During m...
Hi, This article will focus on a series of good coding tips and coding styles that I have used through the years. These tips will help your code be more consistent and allow others to make changes mor...
Introduction In my previous article, I discussed the use of proxy PDBs with application containers to load balance an application across CDBs by relocating application PDB‘s). In this article, I will ...
In this article series, we are exploring why and how enterprises are starting to use PostgreSQL. The open-source PostgreSQL is a database more than 20 years old and owned by the Postgres foundation. I...
In this article series, we are looking at the detailed steps for setting up the Oracle Hybrid Cloud via the latest version – Oracle Enterprise Manager Cloud Control 13c installed on premises. Our main...
In our article series, we are exploring the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database-as-a-Service (DBaaS) cloud – including the setup of such a cloud. In t...
Last week I was presenting at Oracle Code in New York. I’ve presented at a few Oracle Code events over the past 12 months and it is always interesting to meet and talk with developers from around the ...
How are the sqls performing today? Often, I face this question. First I will try to parse the question into simple terms. The sqls – what sqls? On any given day, the top 10 resource intensive sqls. ...
En este video te presento el Blueprint la nueva forma de crear aplicaciones en Oracle APEX 5.2 Early Adopter. Aquí te dejo los enlaces de referencia: Articulo Oracle APEX 5.2 Early Adopter e...
With each release of the Oracle Database we get new Machine Learning features, under the umbrella term of Oracle Advanced Analytics option (OAA). With Oracle 18c we get the following new features, th...
Oracle 18c has been released and comes with many new features and incremental improvements. At the moment it is currently available on the Oracle Cloud and for Oracle Engineered System. We will have t...
If you used other languages, including Oracle PL/SQL, more than likely you will have experienced having to play buffering the number of records that are returned from a cursor. Typically this is neede...
