Intermediate SQL Color Coded SQL, UNIX and Database Essays

Presentations

Central Florida ORACLE Users Group, Orlando, FL June 2009
The What How and Why of RMAN

No comments yet.

Want to copy data faster than SCP ? Check out my new blog entry: http://t.co/nTpI4jfx 07:05:17 PM May 16, 2012 from web Reply Retweet Favorite
Validate constraint in PARALLEL: alter table PARALLEL + alter table ENABLE VALIDATE constraint 01:35:54 AM June 26, 2011 from web Reply Retweet Favorite
You can active duplicate from physical STANDBY database, if you set state=APPLY-OFF on standby 12:57:34 AM May 08, 2011 from web Reply Retweet Favorite
Golden rule of PAGINATION INDEXING - Either "fix" leftmost columns (c=v) OR include them in ORDER BY 08:39:27 PM April 21, 2011 from web Reply Retweet Favorite
Golden rule of PARTITIONING - If you can't make 99% of your SQLs hit a single partition -> don't do it ! 08:37:15 PM April 21, 2011 from web Reply Retweet Favorite