(Michael Dinh) This post will demonstrate the procedure for testing Oracle Data Guard Fast-Start Failover by shutting down the server where the standby database is running from.
Tag: Oracle
5 Minutes Demo: Using Liquibase in SQLcl to version Oracle Database
(Jeff Smith) I previously talked about our new Liquibase support in SQLcl, so you may want to start there if it’s brand new to you.
Analysing Database Time with Active Session History for Statements with Online Optimizer Statistics Gathering Operations
(David Kurtz) I have been looking into the performance of online statistics collection. This feature was introduced in 12c. When statistics are collected online there is an extra OPTIMIZER STATISTICS GATHERING operation in the execution plan.
Add a deployment to Oracle GoldenGate 19c Microservices
(Bobby Curtis) Once you have an up and running Oracle GoldenGate Microservices environment, there may come a time when you need to add another deployment to the enviornment. Adding deployments is easily done using Oracle GoldenGate Configuration Assistant (OGGCA).
Excel/CSV Import to a new TABLE in SQL Developer Web
(Jeff Smith) You have some data, but not in your trusty Oracle Database yet.
ORA-00942: table or view does not exist
(Satishbabu Gunukula) When calling a table directly or through procedure/function…etc user may receive error “ORA-00942: table or view does not exist”.
Print PDF from Oracle APEX to Local or Remote Printer
(Dimitri Gielis) On Twitter, I got a lot of reactions on my previous blog post Printing to local (Zebra) printer from Oracle APEX in the Cloud.
Response to Make database simpler
(John Hallas) I read an interesting and thought provoking blog this morning Make Oracle database simple again
OEM 13c Monitoring Features – Part 3, Reports Based On Metric Data
(Fernando Salgado) As mentioned in the previous post, historical data collection can be kept in the Oracle Enterprise Manager (OEM) repository for reporting purposes, depending on the metric settings.
Installing Oracle GoldenGate 19c Microservices – Binaries Only
(Bobby Curtis) It has taken me some time to get around to doing more videos; mostly because I don’t like the way that I sound when I hear my voice.