(Oren Nakdimon) In the previous parts of this series I showed that Oracle does a nice optimization – that may save plenty of time – when we add in a single ALTER TABLE statement a new nullable with no default value column and a corresponding:
Tag: Oracle
12c MultiTenant Posts — 5 : Flashback a PDB
(Hemant K Chitale) 12.2 allows FLASHBACK DATABASE for a Pluggable Database.
Oracle Database on the Docker Store
(Gokhan Atil) You probably know that there’s an official github repository storing Dockerfiles and samples to build Docker images for Oracle products and Open Source projects.
Intra-block row chaining optimization in 12.2
(Sayan Malakshinov) I’ve wrote in previous post
Optimistic ORA_ROWSCN 2: the SCN
(stewashton) In my previous post, I covered lost updates. Before saying how ORA_ROWSCN can help avoid them, I need to talk about the SCN. It’s hard to be simple and correct about such a central element of the Oracle database, but I’ll try.
Adding a Datafile to Tablespace
(Zahid Anwar) When monitoring Tablespace Usage (see my Tablespace Usage blog post for more info), there comes a point when you need to add a datafile to a tablespace to allow for growth and more importantly get below a monitoring threshold for example in OEM or OpsView.
ADF BC – Create View Object From Query with Custom Implementation Class
(Andrejus Baranovskis) I had a request to explain how to create dynamic ADF BC VO from SQL statement and set custom VO implementation class for newly created VO instance. Custom VO implementation class extends from ADF BC ViewObjectImpl and overrides super method:
Running any Node application on Oracle Container Cloud Servicer
(Lucas Jellema) In an earlier article, I discussed the creation of a generic Docker Container Image that runs any Node.JS application based on sources for that application on GitHub. When the container is started, the GitHub URL is passed in as a parameter and the container will download the sources
Internal Audit Policies
(Dominic Brooks) The Oracle RDBMS market has long been a-shrinking.
Video Overview of SET SQLFORMAT ANSICONSOLE
(Jeff Smith) Love the command line? Hate ugly, out-of-the-box formatting of your results?
