(David Fitzjarrell) The predominance of business applications designed with no particular database in mind is growing/ With that growth arises an interesting issue: designing tables to contain various types of data in a single column.
Tag: Oracle
How can we add custom code to existing triggers?
(Patch72) We have bought an application that runs on an Oracle database. There are triggers defined on the tables, but we want to add our own code to these triggers, but we don’t have access to the source code. What is the approach we should follow to accomplish this?
Data denormalization … another take
(connormcdonald) I read an interesting article the other day about data modelling and data denormalization.
12.2 New Features — 1 : Separate Undo Tablespace for each PDB
(Hemant K Chitale) Unlike 12.1 MultiTenant, 12.2 introduces a separate Undo Tablespace for each PDB.
Fabric … Simple #GoldenGate Administration over SSH
(Bobby Curtis) For awhile now, I’ve been looking at different approaches for automating some of my GoldenGate monitor tasks. Yes, there are tools out there that provide a wide variety of ways for interaction and monitoring of Oracle GoldenGate.
Keep your Service Directory valid
(Martien van den Akker) To day I ran into a trap that trapped me before…
Big Data SQL Quick Start. My query is running too slow or how to tune Big Data SQL. – Part13.
(Alexey Filanovskiy) In my previous posts, I was talking about different features of the Big Data SQL. Everything is clear (I hope), but when you start to run real queries you may have doubts – is it a maximum performance which I could get from this Cluster? In this article, I would like to explain
Explore more about 12c Multitenant with useful MOS Docs
(The Human Fly) As part of an ongoing Exadata migration assignment, we have been exploring Oracle 12c multitenant capabilities a lot. I would like to share here some of selected useful MOS Doc about 12c multitenant concepts:
Oracle 12.2 Sharding Option
(amitzil) Lately I wrote a post about 12.2 new features. In the post I didn’t list sharding (probably one of the biggest features in this version), as I wanted to dedicate an entire post for it.
Use WLST to test all your datasources
(Martien van den Akker) To day I had some problems with deploying my composite to the server of my current customer. Apparently the Server had some problems with datasources.
