Oracle 11gR2 DBMS_STATS introduced useful function report_col_usage to report column usage i.e if column is being used for equality,like predicates. I came to know it while reading Optimizer whitepaper .As per…
Read Full Recipe
I have been using firefox on a linux desktop since last week. Lot of sites on internet are using flash player on it , so everytime I hit the site,…
Read Full Recipe
Google has published a paper on F1 - The Fault-Tolerant Distributed RDBMS Supporting Google's Ad Business. F1 combines benefit of bigtable (concept from which hadoop is derived) and MySQL database. You can read about…
Read Full Recipe
I am bloging about experience we had using rman incremental backup for syncing standby database. We had a standby database which lagged by considerable time and we decided to use…
Read Full Recipe
Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be found here I have been using SPM and SQL Profiles (using coe_xfr_profile.sql) to fix…
Read Full Recipe
Some time back oracle had announced Oracle Big Data appliance. Along with this Oracle released Big Data Connectors to facilitate data access between data stored in a Hadoop cluster and…
Read Full Recipe