Category Archives: Oracle DBA

APEX in the Cloud

Oracle APEX in AWS Cloud Continue reading

Posted in Oracle APEX, Oracle DBA | Tagged , , , , | Comments Off on APEX in the Cloud

Oracle XE 18c is available for download

We’ve been waiting a very long time but finally it is: New version of Oracle XE: Oracle XE 18c is available for download (only for Linux now). What is even more important: – limits are extended to 12GB of user … Continue reading

Posted in Oracle, Oracle DBA | Tagged , , , | Comments Off on Oracle XE 18c is available for download

What Developers Should Know … Part 3

If you have read Part 1 and Part 2 of this series, you are now ready to observe parsing (soft and hard), bind peeking, influence them, and observe how Adaptive Cursor Sharing tries to fix it. Literals vs Bind Variables … Continue reading

Posted in Oracle DBA, Oracle SQL Zaawansowany | Tagged , , , | Leave a comment

What Developers Should Know … Part 2

Up to now, we talked about Selectivity / Cardinality Skewed Data / Histograms Displaying Execution Plans with Explain Plan, dbms_xplan package, autotrace feature Introduced bind variables I believe, that for most of you it was quite familiar.. But I also … Continue reading

Posted in Oracle DBA, Oracle DBA Advanced, Oracle SQL Tuning, Oracle SQL Zaawansowany, SQL | Tagged , , , | Leave a comment

What Oracle Developers Should Know … Part 1

Quite often, as Database Administrators we are faced the case,  when our attitude to SQLs, our knowledge of topic, is in contraty to what Developers know.. It all comes from fact, that Developers, do not have some information, and look … Continue reading

Posted in Oracle DBA, SQL | Tagged , , , , , | Leave a comment

Co nowego w Oracle 12.2 – Identyfikatory powyżej 30 znaków?

“The maximum length of identifiers is increased to 128 bytes for most identifiers, up from 30 bytes in previous releases” Brzmi ciekawie 😉

Posted in Oracle, Oracle DBA, Oracle DBA Basic, Oracle SQL, Oracle SQL Zaawansowany | Tagged , | Leave a comment

Feature of our Oracle Databases – Why should we migrate to Multitenant architecture

Hi, Enjoy presentation about new Multitentant architecture offered by Oracle ! Discover prons and cons and “Why should we migrate to Multitenant architecture” Click link below to see the presentation: multitenant_architecture_pros_and_cons

Posted in Oracle, Oracle DBA, Oracle DBA Advanced | Tagged , , | Leave a comment

What is and What is not Exadata Engineered System

Hi, Enjoy presentation about main features of Exadata, distinguishing it from others solutions on market ! Click link below to see the presentation: What_is_and_what_is_not_exadata_db_machine

Posted in Nieokreślona, Oracle DBA | Leave a comment

Darmowe seminaria z Exadaty

Zobacz więcej aby obejrzeć film na temat Exadaty

Posted in Oracle DBA, Oracle DBA Advanced | Tagged , , | 1 Comment

Running exachk when no RAC databases installed, Health Check 11109: Database node IB MTU size should be set to 65520

Does every Database Machine runs RAC databases ? No … ! Lots of consolidated databases run in single instance configuration. Are we able to use the same tools , as for preferred by Oracle RAC configuration ?

Posted in Nieokreślona, Oracle DBA | Leave a comment