Oracle Team

12c online datafile move and ongoing changes

By Franck Pachot . Here is a long answer for a question on our forum about online move: what is internal mechanism to store/keep ongoing changes in that particular datafile while copying is in progress.

SQL Plan Directives strikes again

By Franck Pachot . 12c SQL Plan Directives, a side effect, a bad application design, a bug... and the occasion to show how to quickly troubleshoot. An application has long response time since 12c migration. No blind guesses, no reason(…)

About OCR backup

By Mouhamadou Diaw Last day Franck and me were discussing about OCR backup Let’s take a 2 nodes RAC. We can see that OCR backup is automatically done by oracle in only one node on local (with a certain frequency(…)

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.

Protect your oracle password function

By Mouhamadou Diaw Every DBA knows the famous oracle password verification script $ORALE_HOME/rdbms/admin/utlpwdmg.sql This function can be used to control password complexity. This script should be protected from unauthorized users. The reason is that by adding an insert(…)

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