Oracle

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,(…)

CPU_COUNT

When you have less CPU threads than the number of processes that has something to run in CPU, the OS will schedule them to share the CPU resource. Increasing the workload at that point will not increase the throughput because(…)

Large Pages on Windows

By Franck Pachot .

Attunity Replicate: additional column on the target

In December 2015, my colleague Vincent did a test with additional column with Oracle GoldenGate 12.2. Hervé & Vincent asked me(…)

Instance Caging and multitenant: do the right setting

When you want to do instance caging, you have to set manually CPU_COUNT and to set a resource manager plan. If you By Franck Pachot . only the CPU_COUNT no instance caging will occur. Except during the maintenance window where(…)

Oracle on Windows Server Core

By Franck Pachot . If SQL Server, the database for GUI fans, goes to Linux then Oracle, the database for command line fans, can go to Windows. Ok, that's not new. But I'm not talking about the Windows with media(…)

EM13c and postgres plugin

As an Oracle DBA I use Enterprise Manager to monitor Oracle databases at my client’s sites. I also administer more and more Postgres databases. I decided to download the Blue Medora plugin in order to monitor the postgresql databases with(…)

EM 13c corrective actions

With Enterprise Manager 13c, we have the possibility to define corrective actions. Let me show you how to use it. From the Enterprise à Monitoring select Corrective Actions : Choose Add Space to Tablespace in the Create Library Corrective(…)