Tag Archives: sql tuning

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