|
Pub Date
|
Title
|
Description
|
|
January/February 2014
|
Hide from Prying Eyes
|
Use Data Redaction in Oracle Database 12c to hide sensitive data automatically.
|
|
November/December 2013
|
Automatic Data Optimization
|
Learn how to enable information lifecycle management to automatically move data to lower-cost storage tiers and compress it.
|
|
September/October 2013
|
Many in One
|
Create many databases in one database instance with the Oracle Database 12c multitenant architecture.
|
|
January/February 2013
|
Beginning Performance Tuning: Active Session History
|
Identify the root cause of performance issues at a precise point in the past.
|
|
November/December 2012
|
Beginning Performance Tuning: Diagnose the Past
|
Take the next step in diagnosing Oracle Database performance issues.
|
|
July/August 2012
|
Beginning Performance Tuning
|
Resolve session performance issues in Oracle Database.
|
|
May/June 2011
|
Smart Scans Meet Storage Indexes
|
Understand how Oracle Exadata uses storage indexes to speed I/O.
|
|
March/April 2011
|
Preprocess External Tables
|
Use inline preprocessing on external tables to simplify extract, transform, and load operations.
|
|
January/February 2011
|
Simulation Demonstrates Performance
|
Use Oracle Exadata simulation in SQL Performance Analyzer to help predict how your application will perform on Oracle Exadata.
|
|
November/December 2010
|
Managing Audit Trails
|
Relocate the audit trail to a different tablespace and set up an automatic purge process to keep its size under control.
|
|
September/October 2010
|
Building on Storage
|
Create sophisticated, feature-rich clustered file systems on Oracle Automatic Storage Management disk groups.
|
|
July/August 2010
|
Automating Parallelism
|
Take the guesswork out of setting the degree of parallelism for queries.
|
|
March/April 2010
|
Partition Virtually
|
Save space by deactivating index partitions, and use virtual columns to partition more logically.
|
|
January/February 2010
|
Compressing Columns
|
Compress more with Oracle Exadata Hybrid Columnar Compression.
|
|
September/October 2009
|
Scripting Oracle RMAN Commands
|
Learn how to create and automate scripts to execute common recovery tasks.
|
|
July/August 2009
|
A Refreshing Move
|
Encrypt, compress, mask, and deliver information with Oracle Data Pump.
|
|
March/April 2009
|
Baselines and Better Plans
|
Use SQL plan management in Oracle Database 11gto optimize execution plans.
|
|
January/February 2009
|
Encrypting Tablespaces
|
Encrypt tablespaces transparently—without affecting performance.
|
|
November/December 2008
|
Keeping Active
|
Use Oracle Active Data Guard to set up a physical standby database for reporting and recovery.
|
|
July/August 2008
|
Compress to Impress
|
Use Oracle Advanced Compression to conserve resources and improve performance.
|
|
March/April 2008
|
Performing Through Changes
|
Measure the impact of changes on SQL workload with SQL performance analyzer.
|
|
January/February 2008
|
Better Workload, Better Testing
|
Use database replay to record and replay database activities for better testing.
|
|
September/October 2007
|
More Partitioning Choices
|
Learn when and how to use new partitioning schemes in Oracle Database 11g.
|
|
January/February 2007
|
Recover in a Flash
|
Reduce database recovery time, using the Oracle flash recovery area.
|
|
November/December 2006
|
Restore to the Point
|
Use named points in time to roll your database back by using flashback technology
|
|
September/October 2006
|
Partition Decisions
|
Understand your partition choices, and choose the best partition and key for your data.
|
|
July/August 2006
|
Archiving Data Using XML
|
Build a powerful, flexible data archive.
|
|
March/April 2006
|
Commanding ASM
|
Access, transfer, and administer ASM files without SQL commands.
|
|
January/February 2006
|
Auditing in XML
|
Create database audit trails in XML.
|
|
September/October 2005
|
Transparent Data Encryption
|
Encrypt sensitive data transparently without writing a single line of code.
|
|
July/August 2005
|
Mining for Clues
|
Use Oracle LogMiner to recreate transactions and undo damage.
|
|
March/April 2005
|
Room with a Better View
|
Get a good, fast look at your data with materialized views.
|
|
January/February 2005
|
Encrypt Your Data Assets
|
Build a flexible infrastructure to protect sensitive data.
|
Oadba's Blog 