Miesięczne archiwum: Styczeń 2017

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 … Czytaj dalej

Opublikowano Oracle DBA, Oracle SQL Zaawansowany | Otagowano , , , | Skomentuj

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 … Czytaj dalej

Opublikowano Oracle DBA, Oracle DBA Zaawansowany, Oracle SQL Tuning, Oracle SQL Zaawansowany, SQL | Otagowano , , , | Skomentuj

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 … Czytaj dalej

Opublikowano Oracle DBA, SQL | Otagowano , , , , , | Skomentuj