Useful links

Interested transaction List http://www.proligence.com/itl_waits_demystified.html
Primary Keys and Non-Unique Indexes (What’s Really Happening ?) https://richardfoote.wordpress.com/2008/06/04/primary-keys-and-non-unique-indexes-whats-really-happening/

NOVALIDATE Constraints – No really https://richardfoote.wordpress.com/2008/07/28/novalidate-constraints-no-really/

Disable No validate – will prevent any DML since index is dropped current data is validated but there is no way to validate new data.

sqld360 Good tool to debug/analyze an sql statement – http://mauro-pagano.com/2015/02/16/sqld360-sql-diagnostics-collection-made-faster/

Bloom Filters http://www.databasejournal.com/features/oracle/oracle-bloom-filters.html

DBMS_COMPARISON DBMS_COMPARISON Demo

Pagination query with using index and count stopkey http://explainextended.com/2009/05/06/oracle-row_number-vs-rownum/

Object/Query Change notification Object Change Notification Query Change Notification

dbms_xplan to display explain predicates http://blog.dbi-services.com/awr-dont-store-explain-plan-predicates/

Parallel Execution Skew Oracle

How to fix a plan for sql id Fix plan using baselines

Nice article series by John lewis related to execution plans http://allthingsoracle.com/execution-plans-part-12-cardinality-feedback/

Database comparison https://kkovacs.eu/cassandra-vs-mongodb-vs-couchdb-vs-redis

https://stackoverflow.com/questions/52383577/installing-ms-c-14-0-for-python-without-visual-studio

Unofficial Windows Binaries for Python Extension Packages==>https://www.lfd.uci.edu/~gohlke/pythonlibs/

 

 

• Uncategorized