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

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s