BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

 

 

 

 

Oracle 11g New RMAN Features

Oracle 11g New Features Tips by Burleson Consulting
July 15, 2008

Oracle 11g SQL New Features Tips

This blog by George Trujillo notes many new 11g features:

  • A Virtual Private Catalog can now make sure an RMAN user can only see databases they are authorized to use.

  • Archive log management for Streams and Data Guard

  • Network aware DUPLICATE

  • Optimized undo backup

  • Improved corrupt block detection

  • Java, PL/SQL, XML, .NET, PHP, APEX

  • PL/SQL Native Compilation without needing a Third-Party C Compiler

  • Native PL/SQL use of Seq.Nextval in a PL/SQL program

  • PL/SQL can use CLOBs to get around 32 KB limitations of SQL character strings.

  • Enhanced PL/SQL warnings and error messages

  • PLSTIMER identifies hotspots and performance tuning opportunities in PL/SQL.

  • New package DBMS_HPROF controls the recording of raw PLSTIMER data.

  • Continued support of standards with JDBC 4.0 and JVM 5.0. Capability to upgrade to JVM 6.0 will be available in the future.

  • Oracle JVM JIT supports transparent native Java compilation without a C Compiler.

  • Significant performance improvements with JDBC performance, especially with Advanced Queuing.

  • JDBC supports server side result cache along  with OCI client side result cache. Also included are big improvements in the JIT and RAC support for JDBC.

  • New command line interface to OracleJVM, thereby making it much easier to work with the JDK in the database.

  • Support for database resident JARs

  • JDBC support for starting and shutting down the database

  • Performance enhancements to XPath query for Java

  • XML applications can now process larger XML documents by loading and saving.

  • DOM nodes in memory and using a page manager for physical binary data management

  • Unified Java API for XML allows mid-tier Java programs to leverage lazily loading by allowing a disconnected mode of operation that allows a XML Type to be used with a session pool model of connection management.

HTML-DB 11g Enhancements

  • APEX will be standard with an embedded PL/SQL gateway.

  • APEX will have an application packager for packing and deployment of APEX applications.

  • Data Pump Enhancements to use when moving data

  • Compression and encryption enhancements

  • Support for XML Schemas and schema-based tables

  • Transportable partitions

  • Change assurance (important for saving money during testing and migration) - Change assurance new features of Database Replay and SQL Replay can play a large role in reducing costs, testing and issues when migrating to Oracle Database 11g. This is one of the best new features in this release.

  • Database replay - captures actual production workload and replays it on a separate system.

  • SQL performance analyzer - finds and fixes SQL performance degradations. 10gR2 has a patch set that allows the replay to occur.

  • Secure Files (next generation LOBS) - Eliminates need for file systems. Very fast access of files. Just as fast as file systems with all the capabilities of the Oracle database since it is a new LOB type. It is very fast at accessing the files from a file system.

  • Store all the data in the database with one consistent:  Security and auditing model

  • Backup and recovery mechanism

  • Storage management (ASM) 

  • Transaction and concurrency model 

  • Interface and protocol 

  • Value-added services like encryption, compression, and de-duplication

 

This is an excerpt from the new book Oracle 11g New Features: Expert Guide to the Important New Features by John Garmany, Steve Karam, Lutz Hartmann, V. J. Jain, Brian Carr.

You can buy it direct from the publisher for 30% off.

Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.

 

 

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.



Hit Counter