Database Administration & Monitoring

SQL Server 2016: Always Encrypted

One of the top new features of SQL Server 2016 is the Always Encrypted functionality. Always Encrypted provides that data, store in a database, remains encrypted the all times there are in the database. There is a complete separation between(…)

Question is: upgrade now to 12.1.0.2 or wait for 12.2 ?

By Franck Pachot . Let's look at Release Schedule of Current Database Releases (Doc ID 742060.1) 12.2.0.1 is planned for 2HCY2016 on platforms Linux x86-64, Oracle Solaris SPARC (64-bit), Oracle Solaris x86-64 (64-bit). 2HCY2016 starts next(…)

ODA X6-2S and ODA X6-2M for EE and SE2

By Franck Pachot . After the announcement of the death of SE1 and SE we wondered what Oracle will do for Small and Medium Enterprises and entry level products. The answer was postgres the Oracle Cloud Services, but that's for(…)

Adaptive Plans and SQL Baselines

By Franck Pachot . I encountered recently an issue with Adaptive Plan and SPM. Documentations says that it works perfectly together but I remembered a presentation from Nelson Calero at UKOUG TECH15 mentioning strange behavior. I reproduced the issue and(…)

ORA-01775: looping chain of synonyms

By Franck Pachot . This error message is misleading. You may encounter it when you expect ORA-00942: table or view does not exist. Let's explain(…)

When changing CURSOR_SHARING takes effect?

By Franck Pachot . I usually don't advice to set CURSOR_SHARING=FORCE but imagine your application requires it, you forgot it (or tried to do without) on migration and then everything is slow. You want to change it, but when does(…)

ASM iostats

By Franck Pachot . A few screenshots and a link here. Sysadmins do not like ASM because they don't have the tools they like to manage the disks. For example, they don't want to run SQL queries to check performance,(…)

SQL Server 2016 AlwaysOn: distributed availability groups

This time, I will talk about distributed availability groups. What’s that? In short, a group of availability groups. Sounds good right? But in which cases may we need such architecture? Firstly, let’s say that(…)

SQL Server 2016 AlwaysOn: Add DBs in AGs with direct seeding

In this blog I would like to talk about two new features shipped with SQL Server 2016 for AlwaysOn availability groups. The first one concerns the new direct seeding capability and the seconde one introduces distributed availability groups(…)

12c online datafile move and resize

By Franck Pachot . I've described in previous posts how the 12c online datafile move works: your session process do the copy and tells other writers (dbwr and direct-path inserts) to write blocks to both files (old one and new(…)