Oracle

awrrpt and spreport in multitenant

By Franck Pachot . Yesterday I was giving my 'Interpreting AWR Reports' Prezi at Oracle Midlands. There is a point where I explain that I always check the 'Captured SQL account for ...% of Total DB Time (s)' in order(…)

OFE – Optimizer Features Enable

By Franck Pachot . Do you know the optimizer_features_enable parameter? What do you think about it? Good or bad to use it? If I tell you to set optimizer_features_enable parameter=11.2.0.4 when you upgrade to 12c, do you think it's a(…)

Execution Plan with ASH

By Franck Pachot . Here is a query I use when I'm on a system that has Diagnostic Pack (ASH) but no tuning Pack (SQL Monitor). It displays the execution plan with dbms_xplan.display_cursor and adds the % of ASH samples(…)

DataPump ‘Processing object type’ misleading messages

By Franck Pachot . You've started a long DataPump and see it stuck on TABLE/STATISTICS/TABLE_STATISTICS, but you don't expect that step to take a long time. Let's see if we can rely on that message.

About SSH keys in Oracle Public Cloud

When working with resources on the Oracle public cloud, whatever it is IaaS or PaaS, the principle access method is based on SSH keys exchange. Once our instance is created this is going to be the first and only way(…)

log file sync / user commits

By Franck Pachot . When presenting 'Interpreting AWR Reports - Straight to the Goal' at UKOUG TECH15 I had a very good question about the Statspack report I read which had log file sync much smaller than user commits. I(…)

Flashback table after multiple drop

By Franck Pachot . FLASHBACK TABLE restores the latest version that is available in recycle bin. If you did multiple drop / create you may want to restore oldest versions. Of course it's documented - everything(…)

PDB Snapshot using dbms_dnfs.clonedb_renamefile

By Franck Pachot . In the previous post I've explained how to use 'snapshot copy' PDB creation for thin provisioning and quick restore of initial state for continuous integration tests. If you don't have the multitenant(…)

PDB snapshot copy for continuous integration testing

By Franck Pachot . How do you manage your continuous integration tests on the database? You need to restart at the same state for probably a hundred of tests. Recreating the schema and test data takes too long. Oracle is(…)

Phantom session environment in multitenant?

By Franck Pachot . In multitenant a session can switch from one container to another. There are a few restrictions such as a transaction cannot span multiple containers. But how do sessions parameters behave? It seems that there is a(…)