Infrastructure at your Service

David Barbarin

SQL Saturday Toulouse 2017: SQL Server on Linux – Slide deck

By | Technology Survey | No Comments
 

 #SQLSatToulouse was definitely a great event. Firstly, a big thanks to the organization team (@Guss and @Fredg_31) as well as all the sponsors and attendees (without whom this kind of event would not be possible). As promised, here the slide deck of my session “Introduction to SQL Server on Linux for DBAs“. It was for me a great moment of sharing. Thanks to all!  

Read More
Arnaud Berbier

DOAG IMC Day 2017

By | Application integration & Middleware | No Comments
 

  This year and before taking part to the DOAG in Nuremberg as a referent – Yes I will present at the DOAG this year – I had the opportunity to attend the DOAG IMC Day in Berlin. It was the SIG IMW dedicated to the infrastructure and operating system. It was my first time in Berlin Very nice city. The event was well organized at the DOAG “Diensleistung”. All the facility was there. So…

Read More
Franck Pachot

Active Data Guard services in Multitenant

By | Oracle | No Comments
 

 A database (or the CDB in multitenant) registers its name as the default service. When a standby database is on the same server, or same cluster, you have no problem because this database name is the db_unique_name which is different between the primary and the standby(s). In multitenant, in addition to that, each PDB registers its name as a service. But the PDB name is the same in the primary and the standby database. This…

Read More
Franck Pachot

impdp content=metadata_only locks the stats

By | Oracle | No Comments
 

 With Oracle you can learn something every day. Today, preparing a migration to 12.2, I found all tables had locked statistics. I learned that it is the expected behavior since 10.2 when importing metadata_only including statistics, to avoid that the automatic job gathering comes and replaces the stats by ‘0 rows’.

Read More
Franck Pachot

12c dbms_stats.gather_table_stats on GTT do not commit

By | Oracle | No Comments
 

 In my UKOUG OracleScene article on 12c online statistics and GTT I mentioned the following: A final note about those 12c changes in statistics gathering on GTT. In 11g the dbms_stats did a commit at the start. So if you did gather stats after the load, you had to set the GTT as ON COMMIT PRESERVE ROWS. Or you just vacuum what you’ve loaded. That has changed in 12c. If you now choose to do…

Read More
Franck Pachot

When PDB name conflicts with CDB name

By | Business Intelligence, Oracle | No Comments
 

 Going to multitenant architecture is not a big change. The administration things (DBA, monitoring, backups) connect to the CDB and the application things connect to the PDB. Without the multitenant option, it is still recommended to go to the CDB architecture. The non-CDB is deprecated and the multitenant architecture brings interesting features. People often ask how to name the CDB and the PDB, especially when they have naming rules or policies in the company. My…

Read More
Franck Pachot

Postgres vs. Oracle access paths IX – Tid Scan

By | Oracle, Postgres | No Comments
 

 In the previous post we have seen how Postgres and Oracle finds the table row from the index entry. It uses the TID / ROWID. I’ll focus on this access path and I will have covered all Postgres access paths to table data. Oracle ACCESS BY ROWID I start with Oracle because we already have seen the TABLE ACCESS BY ROWID. I’ll decompose an index acces to the table. The first step is getting the…

Read More
Franck Pachot

Improving Statspack Experience

By | Oracle | No Comments
 

 I’ve published a few month ago an article in the UKOUG OracleScene magazine on Improving Statspack Experience: quick setup script, changing settings, filling Idle Events,etc. In the article, I used dbms_job to schedule the snapshots, because I have this script for years and never took the time to do it with dbms_scheduler. Thanks to Nicolas Jardot here is the equivalent script using dbms_scheduler.

Read More