SQL Performance Tips (@sqlperftips) 's Twitter Profile
SQL Performance Tips

@sqlperftips

Tips to get best SQL performance.
Covering all major SQL databases.
sql-performance-explained.com is my book.

ID: 287049865

linkhttp://SQL-Performance-Explained.com/l/ calendar_today24-04-2011 06:36:45

4,4K Tweet

54,54K Takipçi

2 Takip Edilen

SQL Performance Tips (@sqlperftips) 's Twitter Profile Photo

The Oracle DB maintains some information either on block or on row level ([NO]ROWDEPENDENCIES). dbaora.com/ora_rowscn-nor… The default (NOROWDEPENDENCIES) may cause ORA-08177: can't serialize access for this transaction even if there is no problem on row level.