Tag Archives: sql tuning

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