(amitzil) In February ’17 I participated in Mike Dietrich’s upgrade workshop and it was great! I don’t want to repeat stuff that he said there, you can read everything on his blog. This workshop made me think about upgrades I did in the past (and I did quite a few) and important things to think abou
Tag: Oracle
Taming XML data in the v$cell% family of Exadata views
(Martin Bach) While researching Exadata 12.2 features that have been introduced with Oracle 12.2.1.1.0 I ran into an old problem of mine, querying the v$cell% views that are new with Exadata 12.1.1.1.0 and Oracle RDBSM 12c Release 1 in a meaningful way.
ODM Model View Details Views in Oracle 12.2
(Brendan Tierney) A new feature for Oracle Data Mining in Oracle 12.2 is the new Model Details views.
Transportable Tablespace–part 2
(connormcdonald) I did a little demo of sharing a tablespace between two databases a few days back – you can see the details here or by just scrolling down Smile if you’re on the home page.
Reverese tunneling for DBA’s
(Dbaharrison) After quite a long time I’m finally writing up a new post for your digestion. The reason for the long gap is that I’m going through something of a career change at the moment and I’m essentially walking away from DBA work to go forth as a cloud guy – more on that in a later post……
(Lack of) Optimization of Unique Constraint Creation
(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:
How to find the object that caused ORA-08103 error
(Bobby Durrett) A developer told me that two package executions died with ORA-08103 errors and he didn’t know which object caused the errors.
Be Prepared When Using DBFS
(mdinh) Goldegate 12c implementation for 2-node RAC with XAG from Grid Home using DBFS.
OBIEE 11G RPD bypass using Private Variable Columns
(Vishal Pathak) We had a requirement where the user wanted to be able to get into the tool and change his formula and also wanted the change to be reflected across all his reports.
Oracle Latches
(David Fitzjarrell) Latches can be confusing. Sessions can wait for them and when those waits become excessive performance degrades.
