Infrastructure at your Service

Category

Database Administration & Monitoring

Oracle Team

GoldenGate Studio 12.2 – Installation

By | Database Administration & Monitoring | No Comments

Today I will present you the new product GoldenGate Studio which was announced at the last Oracle Open World. This product allows to design the replication flows and deploy a solution with a graphical tool. Download The first step is to download GoldenGate Studio. It is available here. Installation The second step is to install the product. After you have transferred the installer to the server decompress it. [email protected]:/tmp/goldengate_studio/ [rdbms12102] ll total 2035484 -rw-r–r– 1…

Read More
Franck Pachot

Adaptive Plan: How much can STATISTICS COLLECTOR buffer?

By | Database Administration & Monitoring | 7 Comments

By Franck Pachot . The 12c adaptive plan prepares two join methods (Hash Join and Nested Loop), actives the one that has the better cost for the estimated cardinality and computes the point of inflection in cardinality estimation where the best cost changes to the other join method. At execution time, rows are buffered by a STATISTICS COLLECTOR operation in order to see if the point of inflection is reached. If it doesn’t, the plan…

Read More
Franck Pachot

When a query has read 350TB after 73K nested loops

By | Database Administration & Monitoring | No Comments

By Franck Pachot . According that you have Tuning Pack, SQL Monitor is the right way to see what a query is currently doing. A query was running for days and the first figure I see is that it has read 350TB. This is not the kind of thing you do in only one operation, so I immediately checked the ‘executions’ columns: 73K table scans. So that’s finally only 5GB. The problem is not the…

Read More
Microsoft Team

SQL Server: switch partition and metadata inconsistency issue

By | Database Administration & Monitoring | No Comments

In this blog post, I would like to share with you a weird issue I faced when I implemented a sliding Windows partition scenario on SQL Server 2014 SP1 at one of my customer. The idea was to keep SQL Server audit records from several SQL Server instances into a global archiving table during two years in order to meet the customer audit specifications. Data older than year – 2 should be deleted. Based on…

Read More
Franck Pachot

Testing Oracle on exoscale.ch

By | Database Administration & Monitoring | One Comment

By Franck Pachot . My last post came from a discussion at SITB with exoscale. They are doing Cloud hosting with datacenters in Switzerland. In Switzerland a lot of companies cannot host their data outside of the country, which is a no-go for the big Cloud providers. After the discussion they gave me a coupon for a trial IaaS instance. And if you follow my blog you should know that when I have a trial…

Read More
Franck Pachot

Can you become a PaaS provider for an Oracle Database service?

By | Database Administration & Monitoring | No Comments

By Franck Pachot . This post is not about technical limitations: Oracle Database is supported in most hypervisors (certified or not) so anybody can provide a DBaaS through a virtual machine as long as it run a supported OS, has enough CPU, memory, and storage, and open the required ports to access to the database (ssh and listener). But you cannot do what you want when you install a software, and you must agree with…

Read More
Nathan Courtine

The (almost) same sample schema for all major relational databases (4) – MSSQL

By | Database Administration & Monitoring | No Comments

In previous posts, my colleague Daniel Westermann explained how to install the “Dell DVD Store Database Test Suite” into PostgreSQL, Oracle and MySQL. This time, this is my job to present you how to proceed with a SQL Server instance 😉 I will proceed this installation on SQL Server 2014 running under Windows Server 2012 R2. To be coherent with the other RDBMS examples, all the manipulation will be made on Windows core. Yes, it…

Read More