TOI

DEFAULT_CACHE_SIZE mentioned in alert.log of an #Oracle database

Today, I got this message in my alert.log file: Full DB Caching disabled: DEFAULT_CACHE_SIZE should be at least 709 MBs bigger than current size. When I look at the datafile sizes and compare them with the buffer cache size, it shows:   SYS@cloudcdb > select name,bytes/1024/1024 as mb from v$sgainfo; NAME MB ————————————————– ———- Fixed […]

#Oracle University Expert Summit Berlin 2016

Join us in Berlin, 18th – 20th April. The event will take place at the Adlon Hotel with Jonathan Lewis, Pete Finnigan, Christian Antognini, Javier de la Torre Medina and myself as speakers. We have over 70 enrollments already, so take action to secure your seat in time! My topic will be Rolling Upgrade from […]

Happy New Year 2016!

Another year has passed. I take the opportunity to thank you for visiting and to wish you a Happy New Year 2016! In case you didn’t recognize: That is supposed to look like fireworks, The Oracle Instructor style 😉 2015 was a great year for uhesse.com with 345,000+ views and the crossing of the one […]

Full Database Caching in #Oracle 12c

If your Oracle Database fits into the buffer cache, we will put all segments into it now upon access – no more direct reads: SQL> connect / as sysdba Connected. SQL> select banner from v$version; BANNER ——————————————————————————– Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production PL/SQL Release 12.1.0.2.0 – Production CORE 12.1.0.2.0 Production […]

Auto optimizer stats after CTAS or direct loads in #Oracle 12c

Less famous 12c New Feature: If you do Create Table As Select (CTAS) or a direct load into an empty table, we will automatically collect optimizer statistics: SQL> select banner from v$version; BANNER ——————————————————————————– Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production PL/SQL Release 12.1.0.2.0 – Production CORE 12.1.0.2.0 Production TNS for Linux: […]

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569