Database management, Oracle Thinking about downgrading from Oracle Enterprise to Standard Edition? 16.09.2014 by Oracle Team By Franck Pachot . You are using an Oracle Enterprise Edition and thinking about downgrading to the Standard Edition? In this case, you must be sure that your applications are compatible. It’s not something easy to check. Here are(…)
Database management, Oracle Oracle: How to move OMF datafiles in 11g and 12c 10.09.2014 by Oracle Team By Franck Pachot . With OMF datafiles, you don’t manage the datafile names. But how do you set the destination when you want to move them to another mount point? Let’s see how easy (and online) it works in(…)
Database management, Oracle Resize your Oracle datafiles down to the minimum without ORA-03297 08.09.2014 by Oracle Team By Franck Pachot . Your datafiles have grown in the past but now you want to reclaim as much space as possible, because you are short on filesystem space, or you want to move some files without moving empty(…)
Database management, Oracle What’s the consequence of NOLOGGING loads? 04.09.2014 by Oracle Team By Franck Pachot . When you load data in direct-path and have the NOLOGGING attribute set, you minimize redo generation, but you take the risk, in case of media recovery, to loose the data in the blocks that you’ve(…)
Database management, Oracle Oracle 12.1.0.2.1 Set to Join Conversion 21.08.2014 by Oracle Team By Franck Pachot . Recently, I described the Partial Join Evaluation transformation that appeared last year in Oracle 12c. I did it as an introduction for another transformation that appeared long time ago in 10.1.0.3 but was not(…)
Database Administration & Monitoring, Oracle Oracle 12.1.0.2: Wait event histograms in μs 04.08.2014 by Oracle Team By Franck Pachot . When an Oracle Database spends a high percentage of its DB time in User I/O, I usually check the wait event histograms in order to see if the storage system is working well. But today,(…)
Database management, Oracle PDB media failure may cause the whole CDB to crash 28.07.2014 by Oracle Team By Franck Pachot . Do you remember last year, when 12c arrived with multitenant, David Hueber warned us about the fact that a single PDB can, under certain conditions, generate a complete system downtime? We are beta testers(…)
Database management, Oracle SQL monitoring 12.1.0.2 shows adaptive plans 25.07.2014 by Oracle Team By Franck Pachot . In a previous post, I have described Adaptive Plans. Even if I prefer to show plans with the SQL Monitor active html format, I had to stick with the dbms_xplan for that because SQL(…)
Database management, Oracle Beyond In-Memory, what’s new in 12.1.0.2 ? 22.07.2014 by Oracle Team By Franck Pachot . It’s just a patchset. The delivery that is there to stabilize a release with all the bug fixes. But it comes with a lot of new features as well. And not only the one that(…)
Database management, Oracle Drilling down V$RECOVERY_AREA_USAGE 18.07.2014 by Oracle Team By Franck Pachot . In a previous post I used X$KCCAGF to get more information about reclaimable archived logs in FRA, because there is a bug in standby (not opened) databases where archivelog deletion policy is ignored. I(…)