Useful links

Interested transaction List
Primary Keys and Non-Unique Indexes (What’s Really Happening ?)

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 –

Bloom Filters


Pagination query with using index and count stopkey

Object/Query Change notification Object Change Notification Query Change Notification

dbms_xplan to display explain 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

Database comparison

Unofficial Windows Binaries for Python Extension Packages==>



Leave a Reply

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

You are commenting using your 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 )

Connecting to %s