1 / 46

Oracle 11g New Features | Oracle Database 11g Online Training

Oracle Database 11g New Features - Oracle Database 11g New Features for DBAs and Developers. Oracle Database 11g makes database infrastructure far more efficient, resilient, and manageable. For example, very compelling new features in the realm of partitioning ease the design and management of partitioned tables immensely

Vibloo
Télécharger la présentation

Oracle 11g New Features | Oracle Database 11g Online Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Oracle 11g Database New Features

  2. Oracle 11g expands on the automation and advisor framework of 10g, but also includes a wide range of performance and optimization improvements. This release seems to be more tailored to stability and change management than ever before and there is a huge number of new features to consider. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  3. Oracle 11g New Features By Sections Application Development Availability Database Overall Business Intelligence and Data Warehousing Clustering Content Management Services Fault Diagnosability • Information Integration • Location Services and Specialty Data • Manageability • Performance • Security • Windows www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  4. Application Development Client-Side Query Cache This feature enables caching of query result sets in client memory. The cached result set data is transparently kept consistent with any changes done on the server side. OCI Client Session NLS Character Set Status Information This new feature adds client session NLS and character set information to the V$SESSION_CONNECT_INFO and GV$SESSION_CONNECT_INFO views. Additional Array INSERT and SELECT Syntax Support by Pro*C/C++ and Pro*COBOL In this Oracle Database 11g release, there is added support for IBM DB2 array INSERT and array SELECT syntax for Pro*C/C++ and Pro*COBOL. Dynamic SQL Statement Caching in Pro*C/C++ and Pro*COBOL Application developers can now precompile Pro*C/C++ and Pro*COBOL applications with the new statement caching option. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  5. Fix Execution Plan in Pro*C/C++ and Pro*COBOL This new feature focuses on fixing an execution plan for a Pro*C/C++ and Pro*COBOL application by using the outline feature. Flexible B Area Length for Pro*COBOL The length of B Area for the Pro*COBOL application can now be from 8 to 253 columns. Implicit Buffered Insert in Pro*C/C++ and Pro*COBOL The benefit is that an implicit buffered INSERT provides performance improvement that is comparable to using the pre compiler array interface. Platform Endianness Support by Pro*COBOL When a UTF16 (UCS2) string is fetched in PIC N variable in a Pro*COBOL application running on Little Endian platforms, the application can now be precompiled with the appropriate command-line option to have the correct platform endianness. Scrollable Cursor Support in Pro*COBOL Pro*COBOL now supports scrollable cursors to fetch data in a non sequential manner. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  6. SQL99 Syntax Support by Pro*C/C++ With this enhancement, the SQL99 syntax for SELECT, INSERT, DELETE, and UPDATE statements and the body of the cursor in a DECLARE CURSOR statement is supported by Pro*C/C++. Application and Schema Comparison New application and schema comparison capabilities enable you to identify differences between two selected applications. Drag and Drop Item Layout The Drag and Drop Layout page enables you to interactively reorder items within a given region, change select item attributes, create new items, and delete existing items. Flash Charts Oracle Application Express includes support for 18 different types of Flash charts. You can create Flash charts when creating a new page or by defining a Chart region. Friendly URL Syntax to Facilitate Bookmarks This features makes all public page links consistent, making them easier to bookmark. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  7. Improved Web Services This release also enables you to manually create a Web services reference even if the Application Express engine cannot correctly parse a WSDL document. Improved Workspace Management This release also includes a number of workspace management enhancements. For users requesting new workspaces or requesting additional storage, you can control what sizes display. Microsoft Access Migration This feature provides an easy way to migrate applications from Microsoft Access to Oracle Express. New Password and Account Controls With this new feature, you can configure account login controls and password policies across a development instance in Oracle Application Express Administration Services. You can also specify controls for a specific account under Account Controls on the Edit User page. Page and Region Caching You can improve the performance of your application by taking advantage of page and region caching. New Cache attributes have been added to the Page attributes and Region Definition pages. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  8. PDF Printing The advantage of this feature is that it provides production of high quality, easily printable reports. Create Rules and Actions for DML Events With Rules Manager Rules Manager now adds the ability to treat DELETE and UPDATE operations on a table as events that drive the rule evaluation and action execution (INSERT operations are already supported). In addition to pre-commit evaluation of rules based on trigger, this release supports post-transaction evaluation through use of the Change Notification feature of Oracle Database. Enhanced Rules Manager Rules Manager now includes a PL/SQL API to store reusable and shareable rule conditions in SQL WHERE clause format. Complex rule conditions can be assembled from these shared elements. New Capabilities for Domain Index Operations A new domain index callout updates table and column name metadata for a domain index during an ALTER TABLE ... RENAME or ALTER TABLE ... RENAME COLUMN command to ensure domain index metadata is kept up-to-date. Oracle Text Predicates and Aggregate Operators are Included in Rule Conditions The Rules Manager feature of Oracle Database now supports the use of the Oracle Text CONTAINS operator with the SQL WHERE clause rule conditions. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  9. Oracle Text Predicates Included in Stored Expressions The Expression Filter feature of Oracle Database now supports the use of the Oracle Text CONTAINS operator with the SQL WHERE clause stored expressions. System-Managed Partitioning of Extensible Indexes System-managed partitioning of domain indexes enhances local domain index manageability and performance. Unicode 5.0 Support With this enhancement, Oracle Database conforms to the newest version of the standard. Java in the Database The major enhancements to the Java runtime in this release include performance with a new JIT compiler, ease-of-use with a JDK-like command-line interface, and tooling. Oracle JVM Java/JDK 5.0 Compatibility This feature allows sharing metadata of Java classes loaded by user class loader among different database user sessions. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  10. Oracle JVM JIT Configuration This feature allows fine-grained control on the behavior of the JIT. In addition, you have the ability to query the status of compiled classes and methods. Oracle JVM JIT (Transparent Native Java Compilation Without a C Compiler) The JIT runs as an independent session in a dedicated Oracle server process. There is at most one compiler session per database instance and it is Oracle RAC-aware and amortized over all Java sessions. In addition, this feature removes the need for a C compiler. Oracle JVM Ease-of-Use: JDK-Like Interface This feature makes Java easy to use using command-line syntax, which is similar to the JDK JAVA command line. In addition to database resident Java classes, this feature allows the execution in the database runtime environment of file system resident Java class, using the standard class path syntax. In addition, it allows setting system properties using the standard -D syntax Oracle JVM Ease-of-Use: Property Management Interface This feature provides DBMS_JAVA functions to emulate JDK System property setting for the duration of the session. The settings are set_property, get_property, remove_property, and show_property. Oracle JVM Ease-of-Use: Output Redirect This feature provides DBMS_JAVA functions and procedures for controlling the redirection of Java output www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  11. Oracle JVM Ease of Use: Database Resident Jars This feature allows supporting JAR as a unit of operations (and as a result of support for signed JARs) using new loadjava options, -jarsasdbobjects and -prependjarnames. Oracle JVM Ease of Use: Two-Tier Java Session Termination This feature allows the termination of Java within a database session, with and without retention of system properties, using endsession and endsession_and_related_state. Oracle JVM Utilities Enhancements Enhancements to existing OracleJVM utilities (loadjava, dropjava, and ojvmjava) include the deprecation of least-frequently-used options of loadjava and the ability to load Java classes over the web. Oracle JVM Manageability: JMX Interface This feature provides support for Oracle JVM with the standard JMX interface. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  12. JDBC and SQLJ • For Java developers, this release provides the following enhancements to JDBC and SQLJ APIs: • Support for the latest Java standards including Java SE 1.5 and JDBC 4.0. • A faster protocol for the Streams/AQ Java interface. • Support for Oracle advanced security in JDBC-Thin. • Enhancements to SQLJ code generation and customizer. • Enhancements to XA support. • Support of event notification. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  13. Oracle Developer Tools for Visual Studio .NET • These features enhance developer productivity for building .NET applications with Oracle Database. They provide native integration with ADO.NET 2.0 functionality using Visual Studio development environments with which .NET developers are familiar. In addition, these features reduce the time it takes to develop .NET applications for Oracle. • General Visual Studio 2005 Support • Oracle PL/SQL Debugger in Visual Studio • Support for Visual Studio 2005 Data Sources Window and Designers • Oracle Data Provider for .NET (ODP.NET) • Provider-Independent API Using Base Classes and Factories • Connection String Builder • Oracle Data Adapter Batch Processing • Row-Level Change Notifications • Schema Discovery • Data Source Enumeration • Faster LOB Retrieval • Improved Parameter Context Caching in Statement Caching www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  14. Oracle Provider for OLE DB • These features improve data access performance from Windows clients to Oracle Database. Many of these features are transparent, meaning applications experience faster performance by upgrading the database server and client without any code changes. • Faster Performance • Improved Metadata Caching • Improved Statement Caching www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  15. PHP • The features in the following sections describe the enhancements to Oracle's client-side stack so that data access open source PHP driver performs better than PHP data access drivers for other databases. • Database Resident Connection Pooling (DRCP) • PL/SQL • XA API Available Within PL/SQL • Allow Sequences in PL/SQL Expressions • Enhancements to the Regular Expression Built-Ins • Functional Completeness of Dynamic SQL for PL/SQL • Method Invocation Scoping Operator • Named and Mixed Notation for User-Defined PL/SQL Subprogram in a SQL Statement • New Compound Trigger Type • PL/Scope • PL/SQL CONTINUE Statement • PL/SQL Hierarchical Profiler, PL/SQL Inlining Optimization • SIMPLE_INTEGER Data Type www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  16. XML Application Development • The features described in the following sections ensure that PL/SQL, Java, C and .NET programmers can leverage the full capabilities of Oracle XML DB and the Oracle XML DB repository. These new features also extend the infrastructure components to support Binary XML and provides an efficient method for handling very large XML documents. • Binary XML Support for Java • Binary XML Support for Oracle XML DB • Configurable DOM Support for Java • Event-Based XML Pull Parsing for C • High Performance XPath Query for Java • In-Place XML Schema Evolution • Mid-Tier XQuery Engine Performance Improvements • Pluggable DOM Support for Java • Scalable and High Performance XML Validation for C • Scalable DOM Support for Java • Unified Java API for XML • XML Diff Support for C • XML Index Enhancements www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  17. Availability • Availability Interfaces in Oracle Enterprise Manager • This new feature improves the manageability of Log Miner. The task-based workflows enable log mining and are integrated with Flashback Transactions. • Data Guard Improvements • The features in the following sections describe enhancements to Oracle Data Guard • Fast-Start Failover for Maximum Performance Mode in a Data Guard Configuration • Compression of Redo Traffic (Only for Gap Resolution) Over the Network in a Data Guard Configuration • Real-Time Query Capability of Physical Standby Database • Fast Role Transitions in a Data Guard Configuration • User Configurable Conditions to Initiate Fast-Start Failover in a Data Guard Configuration www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  18. Data Guard Integration, Simplification, and Performance • The new features in the following sections simplify the configuration and use of Oracle Data Guard. For example, some features provide a smaller set of integrated parameters, a unified SQL/Broker syntax, and better integration with other High Availability features like RMAN and Oracle RAC. • Dynamic Setting of Oracle Data Guard SQL Apply Parameters • Enhanced Data Guard Broker Based Management Framework • Enhanced Data Guard Management Interface (Using SQL*Plus) • Histogram for Redo Transport Response Time in a Data Guard Configuration • Snapshot Standby • Strong Authentication for Data Guard Redo Transport • Enhanced DDL Handling in Oracle Data Guard SQL Apply • Enhanced Oracle RAC Switchover Support for Logical Standby Databases www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  19. Data Guard Logical Apply Completeness • The following sections describe features that add support for other database server features that are not currently handled by Oracle Data Guard. • Oracle Scheduler Support in Data Guard SQL Apply • Fine-Grained Auditing (FGA) Support in Data Guard SQL Apply • Support Transparent Data Encryption (TDE) with Data Guard SQL Apply • Support XML Type Data Type (Only CLOB) in Data Guard SQL Apply • Virtual Private Database (VPD) Support in Data Guard SQL Apply • High Availability Improvements • The following sections describe general improvements in High Availability. • Flashback Transaction • SMP Scalable Redo Apply • Transportable Databases Between Linux and Windows www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  20. Information Life Cycle Management • The features described in the following sections provide automated and policy-based movement of data between storage tiers and they provide mechanisms for complying with retention and immutability regulations. • Flashback Data Archive • The historical data store provides the ability to store and track all transactional changes to a record for the duration of its lifetime. • Integration, Simplification, and Performance of Availability Features • These features describe improvements to the interoperability, usability, performance and robustness of existing functionality. • Automatic Reporting of Corrupt Blocks • Block Media Recovery Performance Improvements • Creation and Recovery of Long-Term Backups Improved • End-to-End Redo Validation • Merge Catalogs • Parallel Backup and Restore for Very Large Files www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  21. Intelligent Data Protection and Repair • The following sections describe features that automate the process of determining what kind of recovery is needed and applying that needed recovery. • Data Recovery Advisor • Enhance Log Miner to Support Automatic Data Repair • Integrated Protection From Various Data Corruptions • Lost-Write Detection Using a Physical Standby Database • Online Application Maintenance and Upgrade • The following features can significantly reduce the downtime required to make changes to an application's database objects. • DDL With the WAIT Option, Enhanced ADD COLUMN Functionality • Finer Grained Dependencies, Invisible Indexes • Minimize Dependent PL/SQL Recompilation After Online Table Redefinition • Online Index Creation and Rebuild Enhancements • Online Redefinition for Tables with Materialized View Logs, Read-Only Tables www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  22. RMAN Integration, Simplification, and Performance • The following sections describe RMAN integration, simplification, and performance features for Oracle Database 11g • Archive Log Management Improvements • Fast Incremental Backups on Physical Standby Database • Improved Backup Compression Performance • Improved Integration with Data Guard • Network-Aware DUPLICATE Command • Optimized Undo Backup • Read-Only Transported Tablespaces Backup www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  23. Database Utilities • The database utilities give you the ability to move large volumes of data and metadata into and between Oracle databases with a high degree of performance, reliability, and manageability. • Compressed Dump File Sets • Data Pump API Enhancements • Database Upgrade/Downgrade Enhancements • Direct Path API Multiple Subtype Support • Encrypted Dump File Sets • Enhancements to Metadata API • Oracle Data Pump External Table Enchantement • Single Partition Transportable for Oracle Data Pump • SQL*Plus BLOB Support www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  24. Business Intelligence and Data Warehousing • Complete the Information Cycle • These features tighten the integration of operational and analytical databases, to enable higher quality and more up-to-date information. • Change Data Purge Enhancements • Change Subscription Enhancements • Enabling or Disabling Synchronous Change Data Capture • Enhanced DML Tracking • Enhanced Materialized View Catalog Views • Query Rewrite Enhancement to Support Queries Containing Inline Views • Query Rewrite Support of Queries on Remote Tables • Refresh Performance Improvements www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  25. Enable the Information Grid • The new features in the following sections: • Provide a single source for information, handling both operational and analytic workloads. • Support database systems with hundreds of CPU's, hundreds of TBs, thousands of users, and dozens of applications. • Composite List-Hash Partitioning • Composite List-List Partitioning • Composite List-Range Partitioning • Composite Range-Range Partitioning • Interval Partitioning • Metadata for SQL Built-In Operators and Functions • OLTP Table Compression, Reference Partitioning • SQL PIVOT and UNPIVOT Operators, System Partitioning • Virtual Columns, Virtual Column-Based Partitioning www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  26. OLAP in Every Data Warehouse • The following sections describe the integration of OLAP and relational technology to broaden the appeal of OLAP for relational data warehouses, and also extend core OLAP capabilities • Cost-Based Aggregation of OLAP Cubes • Cube Organized Materialized Views • Fine-Grained Partitioning of OLAP Cubes • OLAP Security Enhancements • SQL Optimizer Support for OLAP Option Cubes and Dimensions • Storage and Access Improvements of Compressed Cubes • Unified OLAP API Metadata Change Management www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  27. Predictive Analytics and Data Mining • Oracle Database 11g simplifies the management of data mining processing, increases the integration of data mining with SQL, and introduces new analytic capabilities. • Automated and Embedded Data Transformations for Mining (Supermodels) • Data Mining Schema Objects • Java API for Oracle Data Mining (JSR-73) • Multivariate Linear Regression • Multivariate Logistic Regression • Predictive Analytics: PROFILE • SQL Prediction Enhancements www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  28. Clustering • Oracle Real Application Clusters Ease-of-Use • The following sections describe Oracle RAC enhancements that make clustering and Oracle RAC setup and installation easier to perform by anyone unfamiliar with both Oracle RAC and clustering. • Enhanced Oracle RAC Monitoring and Diagnostics in Enterprise Manager • Enhanced Oracle Real Application Clusters Configuration Assistants • OCI Runtime Connection Load Balancing • Parallel Execution for Oracle Real Application Clusters • Support for Distributed Transactions in an Oracle RAC Environment www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  29. Content Management Services • Oracle SecureFiles • The following sections describe enhancements to the LOB infrastructure in this release, called Oracle SecureFiles. Enhancements include built-in compression and encryption. • Fast Bulk Data Transfers • LOB Prefetch • SecureFiles • SecureFiles: Compression • SecureFiles: Deduplication • SecureFiles: Encryption • Text Manageability • The following sections describe enhancements to Text Manageability, which include: • Improved Support for Advanced Features in More Languages • Incremental Indexing Enhancements • Oracle Enterprise Manager Support for Text, Re-Create Index Online www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  30. Text Performance and Scalability • The following sections describe feature integration with Oracle RAC for scalability and other subsystems such as the optimizer for performance. • Composite Index • More Types of Operations Allowed on Document Sections • Text Support for Very Large Number of Partitions • User-Defined Score • XML Content Management Platform • The following sections describe enhancements to XML-based Content Management. • Content Repository Management (JSR-170) Support for Java • This feature supports JSR-170 1.0 defined operations on both unstructured and semi-structured content and provides a comprehensive Oracle-proprietary content management platform, which includes • API extensions for access control, based on the DAV Access Control model • Support for type definition and evolution, based on Oracle XML DB support for XML Schema • Support for Oracle XML DB repository events www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  31. XML Database • The following sections describe enhancements to the Oracle XML database technology. • DAV ACL Support, Enable the XDB HTTP Server for SOA • Large Text Node Handling, Oracle XML DB Repository Triggers • Recursive Schema Handling, Repository Performance Improvements • Scalable XSL Output, SQL/XML Standards Compliance and Performance Optimizations • Support for More Types of Links in XDB • XLink Support in XML DB, XML DB Operational Completenes • XML Query Optimization with Schema less or Weakly-Typed Schema-Based XML • XML Translation Support, Performance Optimizations, XMLIndex • XQuery and SQL/XML Performance Improvements • XQuery Standards Conformance • XSLT Performance Improvements www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  32. Fault Diagnosability • Ease Diagnosis • The following sections describe new features for automatic information generation, packaging for problems or errors, and tools to ease diagnosis. • Automatic Inter-Component Deadlock Detection • Hang Manager • Incident Packaging Service (IPS) • SQL Test Case Builder • First-Failure Capture • The following sections describe complete and efficient capture of diagnostic information during failures. • Automatic Diagnostic Repository • Enhanced Network Diagnosability • OCI Diagnosability www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  33. Intelligent Resolution • These features describe the system-guided repair and resolution of problems. • Improved Block Corruption Detection • SQL Repair Advisor • Problem Prevention • The following sections describe features that are proactive in early problem detection to prevent catastrophes and limit damage to your system. • Automatic Health Monitoring • Automatic Quarantine of Corrupt Undo Segments • Fast ANALYZE: Finding Table-Index Corruptions • Holistic Undo Health Monitoring • Support Workbench • The Support Workbench significantly reduces problem resolution time for customers by providing a simple workflow interface to view and diagnose incident data and package it for Oracle Support. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  34. Information Integration • Information Grid: Computation at Scale • The following sections describe information integration features for Oracle Database 11g. • Information Grid: Computation at Scale • Event Notification Grouping and Management • Oracle Scheduler for Streams Jobs • Scalability for Streams Notifications • Information Grid: Heterogeneous Information • New features in the following sections describe: • Messaging Gateway Service-Based Failover • Multiple Messaging Gateway Agents in Oracle RAC Environments • Simplified Messaging Gateway Propagation Job Configuration • Database Gateways: Performance Improvements • Database Gateway for Adabas, IMS and VSAM www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  35. Location Services and Specialty Data • New Capabilities for Management of Geospatial and Multimedia Data • This release further enhances industry-leading spatial and multimedia features used in internet, geospatial, and media-oriented applications. New Web services, XML services, and usability features support mainstream business applications. • Spatial: 3-D Geometry, Surface, and Point Cloud Storage and Indexing Functions • Spatial Web Services • Spatial Routing Engine Enhancements • Spatial Network Data Model Enhancements • Load-On-Demand for Very Large Networks in Oracle Spatial Network Data Model • Spatial GeoRaster: Manageability, Reliability, Usability Enhancements • Enhanced Workspace Manager Performance and Data Storage Options, Security and Administration • Improved Workspace Manager Valid Time Usability • Oracle Multimedia Performance and Scalability www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  36. New Capabilities for Medical Data • This following sections describe new features for the management of DICOM format medical data for health care and life sciences imagery. • Multimedia DICOM Medical Imaging Format Support • ORDDicom Object Type • DICOM Metadata Extraction • DICOM Conformance Validation • DICOM Image Processing • Making DICOM Content Anonymous • Creation of DICOM Content • Runtime Updatable DICOM Data Model • RFID Identity Code Data Type for EPC, DoD, and Custom Sensor Tags • A new Identity Code object type is implemented in Oracle Database to support custom, Electronic Product Code (EPC), and Department of Defense standard tag formats. Metadata is used to define rules for encoding and decoding any tag information into Identity Code objects. All EPC standard tag types and metadata standards are supported. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  37. New Capabilities for Semantic Data • This following sections describe new features and capabilities for semantic data. • Improved Performance for Bulk Loading • Support for Storage and Query of Semantic Content • Manageability • The following sections describe server manageability features for Oracle Database 11g. • Automatic Storage Management • ASM Fast Mirror Resync • ASM Manageability Enhancements • ASM Preferred Mirror Read • ASM Rolling Upgrade • ASM Scalability and Performance Enhancements • Convert Single-Instance ASM to Clustered ASM • New SYSASM Privilege for ASM Administration www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  38. Change Assurance • The following sections describe new features for automatic capture and replay of workloads before and after changes to analyze impact. • Database Replay • SQL Performance Analyzer • Database Control • The following sections describe Enterprise Manager solutions that help ease database management. • Advanced Replication Cutover, ASM Enhancements • Change Manager - Sync and Propagate, Database Cloning Enhancements • Database Configuration (ECM) Collection Enhancements • Database Home Page and Performance Page Improvements • DBCA & DBUA Enhancements • Enhanced Adaptive Metric Thresholds, Fusion Requirements • Management of Oracle Text Indexes, Migrate Database to ASM - Enhancements in Enterprise Manager • Storage / Audit Report and Metric Enhancement, Storage: Schema, Security, and Configuration Enhancements • Wait Activity Detail Enhancement, Workspace Manager www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  39. ADDM for Oracle Real Application Clusters • This feature is particularly helpful in tuning global resources such as I/O and interconnect traffic and makes the tuning of Oracle RAC databases easier and more precise. • Intelligent Infrastructure • This section describes Statistics, Alerts, Advisor and Automated Maintenance Tasks infrastructure that enable self-management. • Auto-Task • Automatic Maintenance Tasks Management • Automatic Workload Repository (AWR) Baselines • Database Statistics Model Consolidation • Enhanced Active Session History • Enhanced Advisor Framework • Lightweight Jobs • Scheduling External Jobs on Multiple Nodes • Simplified Initialization Parameter Management www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  40. Resource Manageability • The following sections describe enhancements to Resource Manageability. • I/O Calibration • I/O Statistics • Per Session I/O Limits • Resource Manager Statistics in AWR • Resource Plans • Enhanced Optimal Flexible Architecture (OFA) Support • This feature improves manageability by making default Oracle Database installations more compliant with Optimal Flexible Architecture (OFA) specifications. • Space, Object and Transaction Manageability • Self-managing database space, object and transaction. • AUM Default Setting and Migration Support • Enhanced Statistics Collection for Partitioned Objects • Simplified Temp Space Management www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  41. SQL Manageability • The following sections describe self-managing query performance and access methods. • Automatic SQL Tuning with Self-Learning Capabilities • Enhanced Optimizer Statistics Maintenance • Multi-Column Statistics • Partition Advisor • SQL Plan Management • Streams Manageability • The following sections describe enhancements to self-managing Streams (replication and AQ) operations. • Automated Alerts for Streams • Divergence Detection and Resolution • Split and Merge of Streams • Streams Message Tracking & Performance Advisor • Streams Topology • Synchronous Streams Capture www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  42. Performance • General Server Performance • The following sections describe general server performance enhancements. • Direct NFS Client • Enhanced Partition Pruning Capabilities • Intelligent Cursor Sharing • NLS Performance Improvements • Improve Basic SQL and PL/SQL • The following sections describe improved performance of basic SQL and PL/SQL statements. • Binding and Defining Multiple Buffers in OCI • Bitmap Join Index Support for Index-Organized Tables • Cost-Based Optimizer Enhancements, Network/OCI Fusion • OCI Descriptor Array Allocation, OCI Implicit ROWID Fetching • PL/SQL Function Result Cache, PL/SQL Native Compilation Without Needing a Third-Party C Compiler • Query Result Cache www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  43. Optimize Key Platforms • The following sections describe platform-specific optimizations on platforms such as Linux, Windows, and Intel. • ODBC Performance Improvement • The Oracle ODBC Driver has been enhanced with the following options that can be set using Setup DDL on Windows or through odbc.ini on Linux and Solaris: • Statement caching • Removal of optimizer hints for catalog functions • Support for column binding for NUMBER columns as FLOAT www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  44. Security • Oracle Advanced Security • The following sections describe Oracle advanced security features. • Kerberos Cross Realm Support • SYSDBA Strong Authentication • Tablespace Encryption • Hardware-Based Master Key Protection • Secure by Default • The following sections describe out-of-the-box secure configuration with increased password protections, secure file permissions, optional default audit settings, and new controls on network callouts from the database. • Audit By Default, Built-in Password Complexity Checker, Built-in User Profile • Fine-Grained Access Control on Network Call-outs from the Database • Improve Security for Network Administration, Registration, and Operation • Parameters for Enhanced Security of Database Communication • Support Non anonymous LDAP Access for Net Naming www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  45. Security Manageability • The following sections describe replacement and integration of Enterprise Security Manager, Oracle Policy Manager, Selective Audit, and Audit Vault UI into a Java/Enterprise Manager SDK. • Integrated Database Security Manageability • Virtual Private Catalog • Standards-Based Password Algorithm • This feature provides stronger protection for stored database passwords based on industry standard algorithms and provides enhanced security for password-based authentication by enabling usage of mixed case in passwords. www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

  46. Windows • Integration with Windows Services • These features provide new and enhanced support for Oracle databases running Windows. They integrate natively with Windows services, including improved integration with Active Directory and Volume Shadow Copy Service support. • Active Directory Security Enhancements • Volume Shadow Copy Service (VSS) Writer Resources http://docs.oracle.com/en/ www.vibloo.com/Oracle-Database-11g-Online-Training Skype Id: info.viblooEmail: info@Vibloo.comUSA: +1-248-809-1418 IND: +91-40-3296-5222

More Related