New In Oracle Database 11.2.0.1
 
Description Link Last Modified
General
ADR (Automatic Diagnostic Repository) Directory Structure Changed ADR 23-Sep-2009
Client Result Cache - Table Annotations Support DBMS_RESULT_CACHE 21-Feb-2010
Hybrid Columnar Compression Advanced Compression 10-Oct-2009
Data Guard: Compressed Table Support in Logical Standby and LogMiner
Data Guard: Integrated Support for Application Failover in a Data Guard Configuration
Data Guard: Real-Time Query Service Level Agreement (SLA)
Data Guard: Support Up to 30 Standby Databases
Data Guard -
Data Pump Legacy Mode and made Edition aware Data Pump 28-Sep-2009
EXECUTE Privilege for DIRECTORY Object EXECUTE Privilege Directories 01-Nov-2009
Edition-Based Redefinition - CREATE, ALTER, DROP EDITION Editions 06-Oct-2009
In Memory Parallel Query Startup Parameters 10-Oct-2009
Set CPU_COUNT Startup Parameters 16-Feb-2010
Minimal Effort Parallel Execution - Auto DOP and Queing - -
RMAN: Automatic Block Repair
RMAN: DUPLICATE New Options
RMAN: DUPLICATE Without Connection to Target Database
RMAN: Enhanced Tablespace Point-In-Time Recovery (TSPITR)
RMAN: New SET NEWNAME Clauses and Format Options
RMAN: Tablespace Checks in DUPLICATE
RMAN -
SecureFiles: Archive Manager - probably the new DBMS_LOB stuff SecureFiles 18-Sep-2009
Table and Tablespace Master Key Re-Key Transparent Data Encryption 28-Sep-2009
Zero-Size Unusable Indexes and Index Partitions Partition Indexes 20-Sep-2010
 
Deprecated
The DB_EXTENDED Audit Syntax, DRS_START, GC_FILES_TO_LOCKS,
MAX_COMMIT_PROPAGATION_DELAY, PLSQL_NATIVE_LIBRARY_DIR, PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT, SQL_VERSION
Auditing & Startup Params 25-Sep-2010
Listener Password Listener 15-Sep-2009
ALTER USER AUTHENTICATED USING PASSWORD Users 06-Oct-2009
XMLSEQUENCE function XML Functions 04-Jan-2012
 
SQL
New ALTER DATABASE LINK syntax Database Link 16-Nov-2009
New LISTAGG Analytic Functions Analytic Functions 01-Sep-2009
New NTH_VALUE Function Analytic Functions 01-Sep-2009
New RESPECT or IGNORE NULLs syntax added to several analytic functions Analytic Functions 01-Sep-2009
Editioning Views Editioning Views 24-Feb-2010
CHANGE_DUPKEY_ERROR_INDEX semantic effect hint for INSERT Statement Hints 22-Nov-2009
IGNORE_ROW_ON_DUPKEY_INDEX semantic effect hint for INSERT Statement Hints 22-Nov-2009
RETRY_ON_ROW_CHANGE semantic effect hint for UPDATE and DELETE Statements Hints 22-Nov-2009
New DATABASE_ROLE parameter FOR SYS_CONTEXT function SYS_CONTEXT 28-Sep-2009
Recursive WITH Clause WITH Clause 01-Nov-2009
Segment Creation On-Demand Tables 01-Nov-2009
External Tables Preprocessor External Tables 06-Feb-2010
 
PL/SQL
New PL/SQL Warnings (5018, 5019, 5020, 6016, 6017, 6018) PL/SQL Warnings 16-Sep-2009
Enhance, Create or Replace Type to Allow FORCE Option Type 20-Sep-2009
PRECEDES Clause Table Triggers 27-Feb-2010
Fine-Grained Dependencies for Triggers Table Triggers 01-Nov-2009
New NO_DATA_NEEDED named exception Exception Handling 10-Nov-2009
 
XML
Binary XML Enhancements - -
Metadata SXML Comparison Tool - -
XML Index Enhancements - -
XMLType Partitioning Partitioning 21-Sep-2009
 
New Built-in Packages
AS_REPLAY AS_REPLAY 18-Oct-2010
DBMS_APBACKEND - -
DBMS_APPLY_HANDLER_ADM - -
DBMS_AQ_EXP_DEQUEUELOG_TABLES DBMS_AQ_EXP_DEQUEUELOG_TABLES 02-Oct-2011
DBMS_AWR_REPORT_LAYOUT DBMS_AWR_REPORT_LAYOUT 02-Oct-2011
DBMS_CACHEUTIL DBMS_CACHEUTIL 03-Oct-2011
DBMS_CLIENT_RESULT_CACHE DBMS_CLIENT_RESULT_CACHE 03-Oct-2011
DBMS_COMPRESSION DBMS_COMPRESSION 01-Mar-2010
DBMS_CUBE_LOG DBMS_CUBE_LOG 16-Nov-2009
DBMS_DBFS_CONTENT (some formerly dbms_archive_provider)   -
DBMS_DBFS_CONTENT_ADMIN   -
DBMS_DBFS_CONTENT_SPI   -
DBMS_DBFS_HS   -
DBMS_DBFS_SFS DBMS_DBFS_SFS 27-Feb-2011
DBMS_DBFS_SFS_ADMIN DBMS_DBFS_SFS_ADMIN 09-Jan-2011
DBMS_DST DBMS_DST 18-Jan-2011
DBMS_FLASHBACK_ARCHIVE DBMS_FLASHBACK_ARCHIVE 13-Mar-2011
DBMS_PARALLEL_EXECUTE DBMS_PARALLEL_EXECUTE 12-Feb-2011
DBMS_PARALLEL_EXECUTE_INTERNAL PARALLEL_EXECUTE_INTERNAL 12-Feb-2011
DBMS_STREAMS_HANDLER_ADM - -
DBMS_STREAMS_MC - -
DBMS_XQUERY DBMS_XQUERY 01-Mar-2010
DBMS_XSTREAM_ADM DBMS_XSTREAM_ADM 01-Nov-2009
DBMS_XSTREAM_ADM_UTL DBMS_XSTREAM_ADM_UTL 01-Nov-2009
PRVT_COMPRESSION PRVT_COMPRESSION 09-Mar-2010
WWV_DBMS_SQL - -
 
Built-in Packages with new Functions and Procedures
New GET_ASH_QUERY procedure in DBMS_ADDM DBMS_ADDM 27-Sep-2011
New MOVE_DBAUDIT_TABLES procedure DBMS_AUDIT_MGMT 27-Sep-2011
New CLEAR procedure DBMS_AW_STATS 01-Oct-2011
DBMS_BACKUP_RESTORE BMRRESTOREFROMSTANDBY DBMS_BACKUP_RESTORE 14-Sep-2009
DBMS_BACKUP_RESTORE CANKEEPDATAFILES DBMS_BACKUP_RESTORE 14-Sep-2009
DBMS_BACKUP_RESTORE CHECKCOMPRESSIONALG DBMS_BACKUP_RESTORE 14-Sep-2009
DBMS_BACKUP_RESTORE CLEARCONTROLFILE DBMS_BACKUP_RESTORE 14-Sep-2009
DBMS_BACKUP_RESTORE DUPLICATEFILEEXISTS DBMS_BACKUP_RESTORE 14-Sep-2009
DBMS_BACKUP_RESTORE FLASHBACKCONTROLFILE DBMS_BACKUP_RESTORE 14-Sep-2009
DBMS_BACKUP_RESTORE GETDUPLICATEDDATAFILECOPY DBMS_BACKUP_RESTORE 14-Sep-2009
DBMS_BACKUP_RESTORE REMOVEDUPLICATEFILE DBMS_BACKUP_RESTORE 14-Sep-2009
DBMS_BACKUP_RESTORE SETDBUNIQNAMETSPITR DBMS_BACKUP_RESTORE 14-Sep-2009
DBMS_BACKUP_RESTORE WRITEDUPLICATEDDATAFILECOPY DBMS_BACKUP_RESTORE 14-Sep-2009
New CREATE_MVIEW function DBMS_CUBE 16-Nov-2009
New DERIVE_FROM_MVIEW function DBMS_CUBE 16-Nov-2009
New DROP_MVIEW procedure DBMS_CUBE 16-Nov-2009
New EXPORT_XML_TO_FILE procedure with 2 overloads DBMS_CUBE 16-Nov-2009
New INITIALIZE_CUBE_UPGRADE procedure with 2 overloads DBMS_CUBE 16-Nov-2009
New REFRESH_MVIEW procedure DBMS_CUBE 16-Nov-2009
New DBMS_DATAPUMP SET_REMOTE_WORKER procedure DBMS_DATAPUMP 19-Nov-2010
New DBMS_DATAPUMP TEST_REMOTE_CONTEXT1120 procedure DBMS_DATAPUMP 19-Nov-2010
New DBMS_DDL_INTERNAL COMPAT_OK procedure DBMS_DDL_INTERNAL 10-Jan-2010
New DBMS_FEATURE_SYSTEM_OJVM DBMS_JAVA 02-Apr-2011
New DUMP_NATIVE_MACHINE_CODE DBMS_JAVA 02-Apr-2011
New SET_RUNTIME_EXEC_CREDENTIALS DBMS_JAVA 02-Apr-2011
New COPY_DBFS_LINK procedure DBMS_LOB 14-Sep-2011
New COPY_FROM_DBFS_LINK procedure DBMS_LOB 14-Sep-2011
New DBFS_LINK_GENERATE_PATH DBMS_LOB 14-Sep-2011
New GETCONTENTTYPE DBMS_LOB 14-Sep-2011
New GET_DBFS_LINK DBMS_LOB 14-Sep-2011
New GET_DBFS_LINK_STATE DBMS_LOB 14-Sep-2011
New MOVE_TO_DBFS_LINK DBMS_LOB 14-Sep-2011
New SETCONTENTTYPE DBMS_LOB 14-Sep-2011
New SET_DBFS_LINK procedure DBMS_LOB 14-Sep-2011
New DB_IS_LOGSTDBY function DBMS_LOGSTDBY 21-Feb-2010
New EDS_ADD_TABLE DBMS_LOGSTDBY 21-Feb-2010
New EDS_EVOLVE_TABLE DBMS_LOGSTDBY 21-Feb-2010
New EDS_REMOVE_TABLE DBMS_LOGSTDBY 21-Feb-2010
New GET_CHECK_CONSTRAINT_NAME function DBMS_METADATA 19-Mar-2010
New GET_FK_CONSTRAINT_NAME function DBMS_METADATA 19-Mar-2010
New  GET_HASHCODE function DBMS_METADATA 19-Mar-2010
New GET_SXML_DDL function DBMS_METADATA 19-Mar-2010
New OPEN_GET_FK_CONSTRAINT_NAME function DBMS_METADATA 19-Mar-2010
New PARSE_CONDITION function DBMS_METADATA 19-Mar-2010
New PARSE_DEFAULT function DBMS_METADATA 19-Mar-2010
New PARSE_QUERY function DBMS_METADATA 19-Mar-2010
New SET_FK_CONSTRAINT_COL_PAIR procedure DBMS_METADATA 19-Mar-2010
New SET_PARAMETER procedure DBMS_METADATA 19-Mar-2010
New DELETE_XMLSCHEMA procedure DBMS_METADATA_UTIL 22-Mar-2010
New LOAD_XSD procedure DBMS_METADATA_UTIL 22-Mar-2010
New ASSIGN_WALLET_ACL procedure DBMS_NETWORK_ACL_ADMIN 02-Sep-2009
New UNASSIGN_WALLET_ACL procedure DBMS_NETWORK_ACL_ADMIN 02-Sep-2009
New CONTAINS_HOST procedure DBMS_NETWORK_ACL_UTILITY 02-Sep-2009
New EQUALS_HOST procedure DBMS_NETWORK_ACL_UTILITY 02-Sep-2009
New GETMAXSCN function with two overloads DBMS_RCVMAN 02-Sep-2009
DBMS_REGXDB VALIDATEXDB_OBJS procedure DBMS_REGXDB 02-Sep-2009
New DELETE_DEPENDENCY function and procedure with four overloads DBMS_RESULT_CACHE 07-Oct-2009
New CREATE_FILE_WATCHER DBMS_SCHEDULER 25-Mar-2010
New DROP_FILE_WATCHER DBMS_SCHEDULER 16-Nov-2009
New GET_AGENT_VERSION DBMS_SCHEDULER 16-Nov-2009
New GET_PACKAGE_MEMORY_UTILIZATION function DBMS_SESSION 03-Sep-2009
New SET_EDITION_DEFERRED procedure DBMS_SESSION 03-Sep-2009
New SEGMENT_EXTEND procedure DBMS_SPACE_ADMIN 24-Oct-2009
New SEGMENT_REPAIR procedure DBMS_SPACE_ADMIN 24-Oct-2009
New DROP_MIGRATE_STORED_OUTLINE procedure DBMS_SPM 21-Nov-2009
New MIGRATE_STORED_OUTLINE function DBMS_SPM 21-Nov-2009
New DBMS_SQLDIAG DUMP_TRACE procedure DBMS_SQLDIAG 24-Oct-2009
New GET_FIX_CONTROL function DBMS_SQLDIAG 24-Oct-2009
New GET_SESS_OPTIMIZER_ENV function DBMS_SQLPA 24-Oct-2009
New CREATE_SQLPLAN_BASELINE procedure DBMS_SQLTUNE 03-Sep-2009
New SET_AUTO_TUNING_TASK_PARAMETER procedure DBMS_SQLTUNE 03-Sep-2009
New SEED_COL_USAGE procedure DBMS_STATS 14-Aug-2010
New COMPATIBLE_11_2 function DBMS_STREAMS 03-Sep-2009
New MAX_COMPATIBLE function DBMS_STREAMS 03-Sep-2009
New KEEP_COLUMNS procedure DBMS_STREAMS_ADM 07-Sep-2009
New WAIT_ON_PENDING_DML function DBMS_UTILITY 21-Mar-2010
New ABORT_WLMPLAN DBMS_WLM 04-Sep-2009
New CHECK_RM_PLAN DBMS_WLM 04-Sep-2009
New CHECK_WLMPLAN DBMS_WLM 04-Sep-2009
PURGETABLE procedure DBMS_WLM 20-Sep-2009
RENAMESAVEPOINT procedure DBMS_WLM 20-Sep-2009
New RENAMEWORKSPACE procedure DBMS_WLM 20-Sep-2009
New EXPORT_UC_GRAPH DBMS_WORKLOAD_CAPTURE 04-Sep-2009
New GET_CAPTURE_PATH DBMS_WORKLOAD_CAPTURE 17-Feb-2010
New IMPORT_UC_GRAPH DBMS_WORKLOAD_CAPTURE 04-Sep-2009
New USER_CALLS_GRAPH DBMS_WORKLOAD_CAPTURE 04-Sep-2009
New ADD_FILTER DBMS_WORKLOAD_REPLAY 17-Feb-2010
New COMPARE_PERIOD_REPORT DBMS_WORKLOAD_REPLAY 17-Feb-2010
New CREATE_FILTER_SET DBMS_WORKLOAD_REPLAY 17-Feb-2010
New DELETE_FILTER DBMS_WORKLOAD_REPLAY 17-Feb-2010
New DIVERING_REPLAY_INFO DBMS_WORKLOAD_REPLAY 17-Feb-2010
New EXPORT_UC_GRAPH DBMS_WORKLOAD_REPLAY 04-Sep-2009
New GET_DIVERGING_STATEMENT DBMS_WORKLOAD_REPLAY 04-Sep-2009
New GET_PROCESSING_PATH DBMS_WORKLOAD_REPLAY 17-Feb-2010
New GET_REPLAY_PATH DBMS_WORKLOAD_REPLAY 17-Feb-2010
New IMPORT_UC_GRAPH DBMS_WORKLOAD_REPLAY 04-Sep-2009
New INITIALIZE_REPLAY_INTERNAL DBMS_WORKLOAD_REPLAY 17-Feb-2010
New IS_REPLAY_PAUSED DBMS_WORKLOAD_REPLAY 04-Sep-2009
New POPULATE_DIVERGENCE DBMS_WORKLOAD_REPLAY 04-Sep-2009
New POPULATE_DIVERGENCE_STATUS DBMS_WORKLOAD_REPLAY 17-Feb-2010
New PROCESS_REPLAY_GRAPH DBMS_WORKLOAD_REPLAY 17-Feb-2010
New USER_CALLS_GRAPH DBMS_WORKLOAD_REPLAY 04-Sep-2009
New USE_FILTER_SET DBMS_WORKLOAD_REPLAY 17-Feb-2010
New AWR_GLOBAL_DIFF_REPORT_HTML pipelined table function with 2 overloads DBMS_WORKLOAD_REPOSITORY 04-Sep-2009
New AWR_GLOBAL_DIFF_REPORT_TEXT pipelined table function with 2 overloads DBMS_WORKLOAD_REPOSITORY 04-Sep-2009
New AWR_GLOBAL_REPORT_HTML function with two overloads DBMS_WORKLOAD_REPOSITORY 04-Sep-2009
New AWR_GLOBAL_REPORT_TEXT function with two overloads DBMS_WORKLOAD_REPOSITORY 04-Sep-2009
New AWR_SET_REPORT_THRESHOLDS procedure DBMS_WORKLOAD_REPOSITORY 04-Sep-2009
New PURGE_SQL_DETAILS procedure DBMS_WORKLOAD_REPOSITORY 04-Sep-2009
New DIFF_PLAN function DBMS_XPLAN 01-Nov-2009
New DIFF_PLAN_AWR function DBMS_XPLAN 01-Nov-2009
New DIFF_PLAN_CURSOR function DBMS_XPLAN 01-Nov-2009
New DIFF_PLAN_OUTLINE function DBMS_XPLAN 01-Nov-2009
New DIFF_PLAN_SQL_BASELINE function DBMS_XPLAN 01-Nov-2009
New GET_PLANDIFF_REPORT_XML function DBMS_XPLAN 01-Nov-2009
New CREATE_REQUEST_CONTEXT function UTL_HTTP 04-Sep-2009
New DESTROY_REQUEST_CONTEXT procedure UTL_HTTP 04-Sep-2009
New SET_AUTHENTICATION_FROM_WALLET procedure UTL_HTTP 04-Sep-2009
New SET_PROPERTY procedure UTL_HTTP 04-Sep-2009
New CLOSE_CONNECTION procedure UTL_SMTP 26-Apr-2010
New HasTSTZ function UTL_XML 22-Oct-2009
 
Built-in Packages with new Overloads
New BACKUPBACKUPPIECE overload 5 DBMS_BACKUP_RESTORE 01-Nov-2009
New BACKUPPIECECREATE overload 13 DBMS_BACKUP_RESTORE 01-Nov-2009
New GENPIECENAME overload 4 DBMS_BACKUP_RESTORE 01-Nov-2009
New INSPECTDATAFILECOPY overload 2 DBMS_BACKUP_RESTORE 01-Nov-2009
New NETWORKFILETRANSFER overload 2 DBMS_BACKUP_RESTORE 01-Nov-2009
New IMPORT_XML overload 4 DBMS_CUBE 16-Nov-2009
New VALIDATE_XML overload 2 DBMS_CUBE 16-Nov-2009
New GET_STATUS overload 4 DBMS_DATAPUMP 24-Oct-2009
New SET_TRIGGER_FIRING_PROPERTY overload and new pragma DBMS_DDL 24-Oct-2009
New FETCH_OBJNUMS overload DBMS_METADATA 19-Mar-2010
New SET_DEBUG overload DBMS_METADATA 19-Mar-2010
 
Built-in Packages with new Parameters
New EIF_BLOB_IN, EIF_BLOB_OUT api parameter DBMS_AW 02-Sep-2009
Many new parameters in many objects contained in the DBMS_BACKUP_RESTORE package DBMS_BACKUP_RESTORE 14-Sep-2009
New COLCOUNT parameter in COUNT_EXISTING_COL and COUNT_OBJECT_COL procedures DBMS_CDC_UTILITY 22-Mar-2010
New AS_IS parameter for the CLIENT_LOB_APPEND procedure DBMS_DATAPUMP 24-Oct-2009
New WORKER_ID parameter for ESTABLISH_REMOTE_CONTEXT procedure DBMS_DATAPUMP 24-Oct-2009
New POLICY_OWNER parameter for the ADD_POLICY procedure DBMS_FGA 02-Sep-2009
New PROFILE_UGA and PROFILE_PGA parameters for the ANALYZE and START_PROFILING procedures DBMS_HPROF 21-Feb-2010
New INCARN parameter for the procedure TRANSLATEARCHIVEDLOGTIMERANGE DBMS_RCVMAN 02-Sep-2009
New MAX_UTILIZATION_LIMIT parameter for CREATE_PLAN_DIRECTIVE & UPDATE_PLAN_DIRECTIVE DBMS_RESOURCE_MANAGER 02-Sep-2009
New SESSION  parameter for BYPASS procedure DBMS_RESULT_CACHE 14-Apr-2010
New GLOBAL parameter for FLUSH procedure and function DBMS_RESULT_CACHE 14-Apr-2010
New CREDENTIAL_NAME and DESTINATION_NAME parameters for numerous procedures DBMS_SCHEDULER 10-Dec-2009
New OTHER_XML parameter for the REMOTE_PROCESS_XML procedure DBMS_SQLPA 01-Nov-2009
New BUCKET_INTERVAL, BASE_PATH, and LAST_REFRESH_TIME parameters for REPORT_SQL_MONITOR DBMS_SQLTUNE 03-Sep-2009
New BASE_PATH parameter for REPORT_SQL_MONITOR_LIST_XML DBMS_SQLTUNE 03-Sep-2009
Two new parameters for REPORT_SQL_MONITOR_XML function DBMS_SQLTUNE 03-Sep-2009
New ORDER_SEQ parameter for the ADD_WLMCLASSIFIERS procedure in DBMS_WLM DBMS_WLM 04-Sep-2009
New REPLY_TO parameter for the all procedures UTL_MAIL 04-Sep-2009
New FLAG parameter for the GETHASHCODE procedure UTL_XML 22-Oct-2009
 
Built-in Packages with new Constants and Types
OPEN and CLOSED constants renamed to ENABLED and DISABLED DBMS_RESULT_CACHE 14-Apr-2010
New XDS package constants DBMS_RLS 02-Sep-2009
New E-Mail Notification Constants DBMS_SCHEDULER 16-Nov-2009
New WCR and WRC package constants DBMS_SERVER_ALERT 03-Sep-2009
New definition for VARCHAR2_TABLE DBMS_SQL 03-Sep-2009
 
Related Topics
New in 11.2.0.2
New in 11.2.0.3
New in 12.1
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved