Database management, Oracle AWR does not store explain plan predicates 11.11.2014 by Oracle Team By Franck Pachot . What is the most important part in an execution plan? It’s probably the predicate section. It helps to see implicit conversions. It helps to understand why an index is used or not. Or to see(…)
Database management, Oracle 12.1.0.2 CDB views are now using CONTAINERS() 11.11.2014 by Oracle Team By Franck Pachot . I’ve blogged about multitenant internals at the time when 12.1.0.1 was just released. Something has changed in 12.1.0.2 and blogging about it was in my todo list for a long time. Now the occasion(…)
Database management, Oracle Oracle SQL Profile: why multiple OPT_ESTIMATE? 08.11.2014 by Oracle Team By Franck Pachot . In a previous blog I’v shared my script to retrieve the OPT_ESTIMATE hints from a SQL Profile. In the example I made, I had two lines for each table: --- PROFILE HINTS from dbiInSite(…)
Database management, Oracle Oracle SQL Profiles: Check what they do before accepting them blindly 07.11.2014 by Oracle Team By Franck Pachot . People often ask me if I use the SQL Tuning Advisor. The answer is no, at least not through the end of it. But don’t take me wrong. SQL Tuning Advisor is a really nice(…)
Database management, Oracle Using tmux for semi-interactive demos 06.11.2014 by Oracle Team By Franck Pachot . You are a speaker and like to show some demos. Which kind of demo do you do? you script everything so that you just have to press ‘enter’ during the demo you prepare everything in(…)
Database management, Oracle The future of SQL*Plus and some oddities 05.11.2014 by Oracle Team By Franck Pachot . Rumors are coming after OOW14. Oracle is working on a new SQL*Plus version. Not only a new version. It’s a completely new development. Here is what we know currently about the future of sqlplus an(…)
Database management, Oracle How to disable all database links 04.11.2014 by Oracle Team By Franck Pachot . A frequent scenario: you refresh test from production with a RMAN duplicate. Once the duplicate is done, you probably change dblinks so that they address the test environment instead of the production one. But are(…)
Database management, Oracle Oracle cloud control / SQL Details / Statistics 29.10.2014 by Oracle Team By Franck Pachot . A question that I had several times: in Enterprise Manager, in the screen about one SQL statement, the ‘statistics’ tab shows the number of executions, elapsed time, etc. Question is: which time window does it(…)
Database management Oracle Grid Infrastructure: fixing the PRVG-10122 error during installation 28.10.2014 by Oracle Team Making errors is human and when you configure a new Oracle Grid Infrastructure environment (especially one with a large number of nodes), mistakes can happen when configuring ASMLIB on all nodes. If you get an error looking like”PRVG-10122 : ASMLib(…)
Database management SQL Server & memory leak: Are you sure? 28.10.2014 by Microsoft Team I have recently come across an issue with one of my customer that told me that their SQL Server 2008 R2 instance had a memory leak. These are strong words! The server has 64 GB of RAM and the(…)