TDP is EDC!
TDP is EDC!
What is EDC or “Every Day Carry”? Wikipedia describes EDC as items that are carried on a consistent basis to assist in dealing with normal everyday needs of modern society, including possible emergenc...
How to UPDATE Nested Object and Table Columns, Part 1
How to UPDATE Nested Object and Table Columns, Part 1
This two-part series covers how you update User-Defined Types (UDTs) and Attribute Data Types (ADTs). There are two varieties of UDTs. One is a column of a UDT object type and the other a UDT collecti...
A first look at Amazon Aurora with PostgreSQL compatibility – Benefits and Drawbacks – Part III
A first look at Amazon Aurora with PostgreSQL compatibility – Benefits and Drawbacks – Part III
In the previous parts of this article series, we started to look at Amazon AWS and the Relational Database Service (Amazon RDS) that it offers to customers around the world. We learned that Amazon’s o...
OUG Ireland Meetup 11th May
OUG Ireland Meetup 11th May
The next OUG Ireland Meetup is happening on 11th May, in the Bank of Ireland Grand Canal Dock. This is a free event and is open to every one. You don’t have to be a member to attend. Following on fro...
Partitioned Tables and ColumnStore
Partitioned Tables and ColumnStore
ColumnStore indexes are all the rage with data warehouses. They’re fast, they’re new(ish) and they solve all sorts of problems when dealing with massive amounts of data. However they can cause some i...
Toad for SQL Server – Using Log Reader
Toad for SQL Server – Using Log Reader
Toad for SQL Server is a productivity toolset for database administration and development....
Consolidation Planning for the Cloud – Part IX
Consolidation Planning for the Cloud – Part IX
We started to detail the concept and workings of Consolidation Planning for the Cloud, using Oracle Enterprise Manager Cloud Control 13c, in the previous parts of this article series. This is Part IX....
What’s New in Benchmark Factory 7.6
What’s New in Benchmark Factory 7.6
We are pleased to announce the availability of Benchmark Factory 7.6! There are many enhancements/fixes in this release, but below are a few of which I want to point out. REST API With this releas...
The pg_rewind Improvements in PostgreSQL 9.6
The pg_rewind Improvements in PostgreSQL 9.6
The pg_rewind tool was first introduced in PostgreSQL 9.5. This is best used in a situation when a standby becomes a master, then the old master can be reattached to the new master as a standby withou...
Using EMCLI for Mass Update a Property Value
Using EMCLI for Mass Update a Property Value
Here’s a quick and simple script which can help you to update a target property value of all targets running on a specific host. The script will expect you to enter 3 parameters: host name, property n...
ODM Model View Details Views in Oracle 12.2
ODM Model View Details Views in Oracle 12.2
A new feature for Oracle Data Mining in Oracle 12.2 is the new Model Details views. In Oracle 11.2.0.3 and up to Oracle 12.1 you needed to use a range of PL/SQL functions (in DBMS_DATA_MINING package...
How to stabilize, improve and tune Oracle EBS Payroll and Retropay process
How to stabilize, improve and tune Oracle EBS Payroll and Retropay process
Visited few customers off late to review the performance issues pertaining to their Oracle EBS Payroll and Retro-pay processes. Not sure if many are aware of the tools Oracle has to analyze and improv...