Uwe Hesse's Blog (56)

The impact, Exadata will have on your IT’ s organizational structure can range from ‘None at all’ to ‘Significantly’. I’ll try to explain which kind of impact will likely be seen under which circumstances:

http://uhesse.com/2013/02/20/appliance-how-exadata-will-impact-your-it-organization/

Partitioning is a great way to deal with large tables. This post will give you a quick start with examples that you can reproduce easily for yourself. Focus will be on Range-Partitioning, which is still the most popular kind:

http://uhesse.com/2013/01/25/brief-introduction-into-partitioning-in-oracle/

You can now finally access my recorded presentation Exadata Smart Scan: What is so smart about it? Oracle University Free On Demand Mini-LVC 

How to write SQL in a way that supports Partition-Pruning – and what should be avoided:

http://uhesse.com/2012/12/13/partition-pruning-do-dont/

A lesser known 11g New Feature is the option to backup and restore single large datafiles with multiple channels in parallel, which can speed up these processes dramatically. This posting is supposed to give an example for it:

http://uhesse.com/2012/12/12/backup-restore-one-datafile-in-parallel/

On a Single-Instance Oracle Database, Application Services offer benefits for Performance Monitoring & Tracing. That’s the focus of this posting:

http://uhesse.com/2012/10/31/why-you-should-use-application-services-with-your-oracle-database/

http://uhesse.com/2012/10/01/exadata-x3-key-points/

http://uhesse.com/2012/09/19/auditing-alter-system-commands/

http://uhesse.com/2012/09/12/accelerated-space-reclamation-on-exadata-cells/

http://uhesse.com/2012/09/05/retrieve-sessions-with-divergent-optimizer-settings-using-vses_optimizer_env/

http://uhesse.com/2012/08/20/multiple-dbverify-sessions-accessing-one-large-datafile-in-parallel/

http://uhesse.com/2012/08/03/automatic-block-media-recovery-in-action-on-video/

http://uhesse.com/2012/06/13/drop-an-asm-disk-that-contains-a-voting-disk/

http://uhesse.com/2012/06/01/the-making-of-training-on-demand/

http://uhesse.com/2012/05/29/what-is-so-smart-about-exadata-smart-scan-presentation/

http://uhesse.com/2012/04/23/diff_table_stats_in_history-example/

http://uhesse.com/2012/04/05/materialized-views-partition-change-tracking/

/http://uhesse.com/2012/03/28/auditing-for-physical-standby-databases-with-real-time-query/

Just a little script that I use in my courses to see who I am:

http://uhesse.wordpress.com/2012/03/01/oracle-database-whoami/

I was delivering an 11gR2 New Features course, followed by an 11gR2 RAC accelerated course. That lead me to combine the not so widely known new view v$iostat_function with the RAC area:

http://uhesse.wordpress.com/2012/02/01/monitor-rac-io-with-gviostat_function/