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...
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...
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...
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 is a productivity toolset for database administration and development....
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....
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 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...
We’re throwing you a lifesaver – catch onto the more affordable OEM alternative. Help! I can’t afford Diagnostics and Tuning packs for performance monitoring with Oracle® Enterprise Manager. Really? ...
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...
While I am here to officially announce the availability of the new Stat release (6.0), it seems that I should first introduce myself as the new Product Manager for Stat. I’m pleased to be joining thi...
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...
