(Frank Houweling) We have again a major new version of the ADF Performance Monitor available – version 9.5 ! We have added many new valuable features and improvements.
Tag: Oracle
Capture DDL statements in Oracle DB
(Arun Gupta) There are many cases where we need to capture the ddl statements in our production environment where application team have direct access for create or drop any object in the application schema in the production database .
OJVM datapatch fails with ORA-29532 – but the root cause is noncdb_to_pdb.sql
(Mike.Dietrich) Kudos to Robert Ortel who brought this nice misbehavior to my attention. And even though it looks like this would be an OJVM issue, it is caused by noncdb_to_pdb,sql, the script which is used to convert a non-CDB to a PDB.
Extend (Reduce/Contract/Skrink) Function for Oracle
(Simon Greener) Recently I was looking at some cadastral data with a view to working out how to polygonize the linestrings. The data contains this sort of boundary understood anomaly.
SQL Plus … the sweet spot
(Connor McDonald) Need to get a bunch from rows out of the database? Most people are aware of the ARRAYSIZE parameter to improve the fetch performance back to the client, but many people are not aware of the newer ROWPREFETCH parameter.
What’s new with Oracle database 19.7 versus 19.6
(Frits Hoogland) This blogpost takes a look at the technical differences between Oracle database 19 PSU 6 (january 2020) and 7 (april 2020).
Managing Database Users with SQL Developer Web
(Jeff Smith) Someone reminded me that I had yet to show you folks a brand new feature in SQL Developer Web – User Management!
How To Create New Standby Using Active Standby Duplication From Existing Standby
(mdinh) Basically, my insanity is from my experience as Senior Tax Advisor and investment background.
SQL Developer Error
(Michael McLaughlin) It’s been a couple releases trying to fix the following error thrown by SQL Developer on Fedora 30 and shown as the following dialog:
Restoring a lost Datafile on a Standby Database and knowing about V$RECOVER_FILE
(Hemant K Chitale) Continuing with my configured Standby database ….