Category Archives: Oracle

Free Oracle APEX training course materials

Posted on 31 May 2017 by Przemysław Kantyka

Here you can find free APEX training for download and self learning. Package of files contains: Presentations with detailed comments Hands-on Lab Guide with description of workshops APEX source files, SQL files and data files for preparing of environment You … Continue reading →

Posted in Oracle, Oracle APEX, Oracle APEX Advanced, Oracle APEX Fundamentals | Tagged , , , | Leave a comment

What Developers Should Know … Part 3

Posted on 26 January 2017 by Radosław Cisz

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

Posted on 25 January 2017 by Radosław Cisz

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

Posted on 25 January 2017 by Radosław Cisz

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?

Posted on 9 November 2016 by Rafal Stryjek

“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

Oracle 12.2 – dokumentacja

Posted on 8 November 2016 by Rafal Stryjek

Ukazała się dokumentacja do Oracle 12.2. Możemy zapoznać się między innymi z nowymi cechami 12.2, dzięki “What’s new”. http://docs.oracle.com/database/122/index.htm

Posted in Oracle, Oracle SQL, PL/SQL | Tagged , | Leave a comment

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

Posted on 24 September 2016 by Radosław Cisz

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

APEX 5.1 Early Adopter 2 Available

Posted on 23 September 2016 by Przemysław Kantyka

After a long (but I’m sure well worth it) wait, Oracle just announced APEX 5.1 Early Adopter 2 is available. Head over to https://apexea.oracle.com/ to sign up and request a Workspace. The two big items everyone has been waiting for … Continue reading →

Posted in Oracle APEX | Tagged , , , , | 2 Comments

What is and What is not Exadata Engineered System

Posted on 8 June 2016 by Radosław Cisz

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

Posted on 21 May 2016 by Przemysław Kantyka

Zobacz więcej aby obejrzeć film na temat Exadaty

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