Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Solutions › Topic Id: 3051 | Permalink

Oracle Database 10g: Top Features for DBAs

Topic ID: 3051
Created By: 2008-FEB-22 20:46:47 [Vitaliy]
Updated By: 2008-FEB-22 20:57:58 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
8940
2008-FEB-22 20:46:47
Moderator
 
 
Registered On: Mar 2006
Total Posts: 267
2008-FEB-22 20:48 Vitaliy 10gdba_complete.pdf 2672153 Bytes    
I just stumbled upon a series of great articles on oracle.com which give a very 
good overview of the new 10gR2 features for Oracle DBAs (see below).  These 
articles are an R2 addendum to the initial series called "Oracle Database 10g: 
Top Features for DBAs" which covered all of the new features of 10GR1.

I've saved the the 10gR1 PDF file here (10gdba_complete.pdf) because ORACLE.COM 
has a tendency to drop content for no apparent reason.  But before you download 
it from here try it on oracle.com first:

   Oracle Database 10g: The Top 20 Features for DBAs - (Complete PDF file)
10GR2 Addendum Feature List
Part 1—SQL and PL/SQL Features
   - Transparent Data Encryption
   - XML Query
   - Enhanced COMMIT
   - Error-Logging Clause
   - WRAP Package
   - Conditional Compilation
   - Unlimited DBMS Output

Part 2—Manageability Features
   - ASM Command Line Tool
   - Drop Empty Datafiles
   - Direct SGA Access for Hung/Slow Systems
   - Redefine a Partition Online
   - Block Integrity Checking in Memory, Not Just on Disk
   - Online Limit Changes
   - Faster Startup
   - Manage Multiple Objects in Oracle Enterprise Manager
   - Automatic Segment Advisor
   - Event-Based Scheduling

Part 3—Performance Features
   - Hung But Not Paralyzed: Memory-Attached SGA Query
   - Interruptible SQL Access Advisor
   - Check for Tracing Enabled
   - Activity Session History
   - Optimizer Statistics Management
   - Transporting AWR Data
   - Compare Periods Report

Part 4—Data Warehousing and Integration Features
   - Partition Change-Tracking Without MV Logs
   - Query Rewrite with Multiple MVs
   - Transportable Tablespace From Backup
   - Quick Partition Split for Partitioned Index-Organized Tables
   - LONG to LOB Conversion via Online Redef
   - Online Reorg of a Single Partition
   - Partition-by-Partition Table Drop

Part 5—Backup and Availability Features
   - Oracle Secure Backup
   - Dynamic RMAN Views for Past and Current Jobs
   - Dynamic Channel Allocation for Oracle RAC Clusters
   - Tempfiles Recovery via RMAN
   - Flashback Database/Query Through RESETLOGS
   - Flashback Database Restore Points
   - Flash Recovery Area View 
[edited by: Vitaliy at 20:57 (CST) on Feb. 22, 2008]