CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

New In 11gR1
 
Description Link Last Modified
BDUMP is gone (RIP)   09-Aug-2007
UDUMP is gone (RIP)   09-Aug-2007
Navigate to /oracle/diag/rdbms/<sid>/trace   09-Aug-2007
ADR Command Interpreter ADRCI 23-Sep-2007
Case sensitive passwords Security 26-Dec-2007
Two New Object Privileges (USE and FLASHBACK ARCHIVE) Object Privileges 23-Dec-2007
Many New System Privileges System Privileges 23-Dec-2007
New create SPFILE from memory option SPFILE 29-Dec-2007
PL/SCOPE PL/SCOPE 02-Feb-2008
 
SQL
Flashback Archive Flashback Archive 09-Aug-2007
Invisible Indexes Indexes 09-Aug-2007
LOB Compression, Deduplication, and Encryption SecureFiles 06-Sep-2007
New table compression mechanisms and capabilities Table Compression 11-Aug-2007
New PREDICTION_BOUNDS Data Mining Function Data Mining Functions 05-Oct-2007
New regular expression REGEXP_COUNT Regular Expressions 29-Dec-2007
READ ONLY tables Table 11-Aug-2007
Virtual Columns Tables 09-Aug-2007
Virtual Column Constraints Constraints 29-Feb-2008
SELECT FOR UPDATE SKIP LOCKED supported Deadlocks 01-Aug-2007
Pivot operator PIVOT 14-Aug-2007
Unpivot operator UNPIVOT 14-Aug-2007
Composite Partitioning (including range-range) Partition Tables 03-Oct-2007
Interval Partitioning Partition Tables 03-Oct-2007
Reference Partitioning Partition Tables 03-Oct-2007
System Partitioning Partition Tables 29-Dec-2007
 
PL/SQL
Compound table trigger Compound Table Triggers 12-Aug-2007
Continue Statement Continue 09-Aug-2007
Greatly improved ease of native compilation Native Compilation 09-Aug-2007
Pragma Inlines PL/SQL code improving performance Pragma Inline 02-Oct-2007
Sequences: New PL/SQL Usage Syntax Sequences 11-Aug-2007
SIMPLE_INTEGER data type Data Types 09-Aug-2007
Table trigger FOLLOWS clause Table Triggers 12-Aug-2007
 
XML
XMLCAST Function XML Functions 05-Oct-2007
XMLEXISTS Function XML Functions 05-Oct-2007
XMLPATCH Function XML Functions 05-Oct-2007
 
Built-in Packages
New ADD_MDATA_COLUMN procedure CTX_DDL 26-Dec-2007
New ADD_NDATA_SECTION procedure CTX_DDL 26-Dec-2007
New ADD_SDATA_COLUMN procedure CTX_DDL 26-Dec-2007
New ADD_SDATA_SECTION procedure CTX_DDL 26-Dec-2007
New CREATE_SHADOW_INDEX procedure CTX_DDL 26-Dec-2007
New DROP_SHADOW_INDEX procedure CTX_DDL 26-Dec-2007
New EXCHANGE_SHADOW_INDEX procedure CTX_DDL 26-Dec-2007
New POPULATE_PENDING procedure CTX_DDL 26-Dec-2007
New RECREATE_INDEX_ONLINE procedure CTX_DDL 26-Dec-2007
New SYNC_INDEX parameter CTX_DDL 26-Dec-2007
New Package: Automated Diagnostic DBMS_ADDM 16-Nov-2007
New ADD_SQLWKLD_REF parameter DBMS_ADVISOR 01-Feb-2008
New ADD_STS_REF procedure DBMS_ADVISOR 01-Feb-2008
New COPY_SQLWKLD_TO_STS procedure DBMS_ADVISOR 01-Feb-2008
New DELETE_SQLWKLD_REF parameter DBMS_ADVISOR 01-Feb-2008
New DELETE_STS_REF procedure DBMS_ADVISOR 01-Feb-2008
New EVALUATE_DIRECTIVE procedure DBMS_ADVISOR 01-Feb-2008
New EXECUTE_TASK overload DBMS_ADVISOR 01-Feb-2008
New FORMAT_MESSAGE_GROUP parameter DBMS_ADVISOR 01-Feb-2008
New GET_TASK_REPORT parameter DBMS_ADVISOR 01-Feb-2008
New GET_TASK_SCRIPT parameters DBMS_ADVISOR 01-Feb-2008
New INSERT_DIRECTIVE procedure DBMS_ADVISOR 01-Feb-2008
Changes to SCHEDULE_PROPAGATION DBMS_AQADM 12-Dec-2007
? DBMS_AQADM 12-Dec-2007
  DBMS_AQADM 12-Dec-2007
New Procedure: GET_MAILHOST DBMS_AQELM 08-Oct-2007
New Procedure: GET_MAILPORT DBMS_AQELM 08-Oct-2007
New Procedure: GET_PROXY DBMS_AQELM 08-Oct-2007
New Procedure: GET_SENDFROM DBMS_AQELM 08-Oct-2007
New Procedure: HTTP_SEND DBMS_AQELM 08-Oct-2007
New Procedure: GET_DEQ_SORT DBMS_AQIN -
New Procedure: SET_DEQ_SORT DBMS_AQIN -
New Procedure: SEND_PROXY DBMS_AQELM 08-Oct-2007
New Package: Auto task administration internal DBMS_AUTO_TASK 24-Aug-2007
New Package: Auto task administration DBMS_AUTO_TASK_ADMIN 10-Oct-2007
New Package: Auto task administration DBMS_AUTO_TASK_EXPORT 10-Oct-2007
New Package: Auto task administration DBMS_AUTO_TASK_IMMEDIATE 10-Oct-2007
New Procedure: ADVISE_PARTITIONING_DIMENSION DBMS_AW 15-Feb-2008
New Procedure: ADVISE_PARTITIONING_LEVEL DBMS_AW 15-Feb-2008
New Procedure: CLEAN_ACCESS_TRACKING DBMS_AW 15-Feb-2008
New Procedure: DISABLE_ACCESS_TRACKING DBMS_AW 15-Feb-2008
New Procedure: ENABLE_ACCESS_TRACKING DBMS_AW 15-Feb-2008
New Procedure: GATHER_STATS DBMS_AW 15-Feb-2008
New Procedure: OLAP_ACTIVE DBMS_AW 15-Feb-2008
New Package DBMS_AW_STATS 15-Feb-2008
New ABORT_SYNC_INSTANTIATION procedure DBMS_CAPTURE_ADM 26-Dec-2007
New ALTER_SYNC_CAPTURE procedure DBMS_CAPTURE_ADM 26-Dec-2007
New CREATE_SYNC_CAPTURE procedure DBMS_CAPTURE_ADM 26-Dec-2007
New PREPARE_SYNC_INSTANTIATION procedure with 2 overloads DBMS_CAPTURE_ADM 26-Dec-2007
New ALTER_CHANGE_TABLE parameter DBMS_CDC_PUBLISH 26-Dec-2007
New CREATE_CHANGE_TABLE parameter DBMS_CDC_PUBLISH 26-Dec-2007
New GET_DDLOPER procedure DBMS_CDC_PUBLISH 26-Dec-2007
New PURGE_CHANGE_SET parameter DBMS_CDC_PUBLISH 26-Dec-2007
New PURGE_CHANGE_TABLE parameter DBMS_CDC_PUBLISH 26-Dec-2007
New Parameter for EXTEND_WINDOW procedure DBMS_CDC_SUBSCRIBE 19-Oct-2007
New Parameter for PURGE_WINDOW procedure DBMS_CDC_SUBSCRIBE 19-Oct-2007
New CQ_NOTIFICATION_QUERYID function DBMS_CHANGE_NOTIFICATION 07-Apr-2008
New Package DBMS_COMPARISON 26-Oct-2007
New Package DBMS_CONNECTION_POOL 12-Aug-2007
New PAD_ORCL padding algorithm DBMS_CRYPTO 11-Aug-2007
New Package: Transportable Tablespaces with binary information DBMS_CSX_ADMIN 20-Aug-2007
New DBMS_CUBE package DBMS_CUBE 15-Feb-2008
New ADD_FILE parameter DBMS_DATAPUMP 27-Dec-2007
New CLIENT_LOB_APPEND procedure DBMS_DATAPUMP 27-Dec-2007
New CLIENT_LOB_DELETE procedure DBMS_DATAPUMP 27-Dec-2007
New CLIENT_LOB_GET function DBMS_DATAPUMP 27-Dec-2007
New DATA_FILTER overload DBMS_DATAPUMP 27-Dec-2007
New DATA_REMAP procedure DBMS_DATAPUMP 27-Dec-2007
New METADATA_FILTER overload DBMS_DATAPUMP 27-Dec-2007
New SET_DEBUG overload DBMS_DATAPUMP 27-Dec-2007
New START_JOB parameters DBMS_DATAPUMP 27-Dec-2007
New Package: Data Guard DBMS_DG 24-Aug-2007
New GEN_NEW_OBJECT_ID function DBMS_DDL_INTERNAL 18-Aug-2007
New SWAP_BOOTSTRAP procedure DBMS_DDL_INTERNAL 18-Aug-2007
New Procedure FS_FAILOVER_FOR_HC_COND with 2 overloads DBMS_DRS 14-Dec-2007
New Procedure INITIATE FS_FAILOVER DBMS_DRS 14-Dec-2007
New OUT parameter in PING procedure DBMS_DRS 14-Dec-2007
New IN parameter in READY_TO_FAILOVER procedure DBMS_DRS 14-Dec-2007
New package created to support future functionality DBMS_EDITIONS_UTILITIES 11-Aug-2007
New ADD_ELEMENTARY_ATTRIBUTE (new parameter and new overload) DBMS_EXPFIL 26-Dec-2007
New SYNC_TEXT_INDEXES procedure DBMS_EXPFIL 26-Dec-2007
New CHECK_CSX_CLOSURE procedure DBMS_EXTENDED_TTS_CHECKS 07-Dec-2007
New VERIFY_XML_SCHEMA procedure DBMS_EXTENDED_TTS_CHECKS 07-Dec-2007
New TRANSACTION_BACKOUT procedure with 4 overloads DBMS_FLASHBACK 14-Sep-2007
New GET_SEVERITY procedure DBMS_HA_ALERTS 14-Aug-2007
New PL/SQL Hierarchical Profiler package DBMS_HPROF 23-Aug-2007
New database health management package DBMS_HM 18-Aug-2007
New GET_DOM_IDX_PARAM_STR procedure DBMS_I_INDEX_UTL 09-Aug-2007
New IS_DOMAIN_INDEX procedure DBMS_I_INDEX_UTL 09-Aug-2007
New RMAN repair package DBMS_IR 13-Sep-2007
New GET_DEDUPLICATE_REGIONS procedure DBMS_LOB 25-Sep-2007
New ISSECUREFILE function DBMS_LOB 25-Sep-2007
New internal package for securefiles DBMS_LOBUTIL 26-Sep-2007
New ADD_DOCUMENT procedure DBMS_METADATA 11-Aug-2007
New COMPARE_ALTER function DBMS_METADATA 11-Aug-2007
New COMPARE_ALTER_XML function DBMS_METADATA 11-Aug-2007
New COMPARE_SXML function DBMS_METADATA 11-Aug-2007
New CONVERT overload DBMS_METADATA 11-Aug-2007
New CONVERT_TO_CANONICAL function DBMS_METADATA 11-Aug-2007
New FETCH_CLOB overload DBMS_METADATA 11-Aug-2007
New FETCH_XML_CLOB overload DBMS_METADATA 11-Aug-2007
New GET_DEPENDENT_SXML function DBMS_METADATA 11-Aug-2007
New GET_EDITION function DBMS_METADATA 11-Aug-2007
New GET_EDITION_ID function DBMS_METADATA 11-Aug-2007
New GET_SXML function DBMS_METADATA 11-Aug-2007
New GET_VERSION function DBMS_METADATA 11-Aug-2007
New IS_OBJECT_XDB_GENERATED procedure DBMS_METADATA 11-Aug-2007
New OPENC function DBMS_METADATA 11-Aug-2007
2 New SET_FILTER overloads DBMS_METADATA 11-Aug-2007
New SET_PARSING procedure DBMS_METADATA 11-Aug-2007
New CLIENT_ID_TRACE_ENABLE parameter DBMS_MONITOR 01-Feb-2008
New SERV_MOD_ACT_TRACE_ENABLE parameter DBMS_MONITOR 01-Feb-2008
New SESSION_TRACE_ENABLE parameter DBMS_MONITOR 01-Feb-2008
New security for network access DBMS_NETWORK_ACL_ADMIN 09-Aug-2007
New security for network access DBMS_NETWORK_ACL_UTILITY 09-Aug-2007
New Cleanup Procedure DBMS_ODCI 09-Aug-2007
New GetMetaData Procedure DBMS_ODCI 09-Aug-2007
New GetTableNames Procedure DBMS_ODCI 09-Aug-2007
New PROFILE Procedure DBMS_PREDICTIVE_ANALYTICS 13-Aug-2007
New CREATE_PROPAGATION parameters DBMS_PROPAGATION_ADM 30-Mar-2008

Finish

DBMS_RCVMAN 26-Dec-2007
New COPY_MVLOG parameter added to COPY_TABLE_DEPENDENTS DBMS_REDEFINITION 25-Dec-2007
New ADD parameters DBMS_REFRESH 20-Aug-2007
New DELETE_PROGRESS_ACTION procedure DBMS_REGISTRY 09-Aug-2007
New GET_DEPENDENT_COMPS DBMS_REGISTRY 09-Aug-2007
New GET_DEPENDENT_COMPS_REC DBMS_REGISTRY 09-Aug-2007
New GET_PROGRESS_STEP DBMS_REGISTRY 09-Aug-2007
New GET_PROGRESS_VALUE DBMS_REGISTRY 09-Aug-2007
New GET_REQUIRED_COMPS DBMS_REGISTRY 09-Aug-2007
New GET_REQUIRED_COMPS_REC procedure DBMS_REGISTRY 09-Aug-2007
New SET_PROGRESS_ACTION procedure DBMS_REGISTRY 09-Aug-2007
New SET_PROGRESS_STEP procedure DBMS_REGISTRY 09-Aug-2007
New SET_REQUIRED_COMPS procedure DBMS_REGISTRY 09-Aug-2007
New CALIBRATE_IO procedure DBMS_RESOURCE_MANAGER 26-Dec-2007
New CREATE_CATEGORY procedure DBMS_RESOURCE_MANAGER 26-Dec-2007
New CREATE_CONSUMER_GROUP parameter DBMS_RESOURCE_MANAGER 26-Dec-2007
New CREATE_PLAN parameters DBMS_RESOURCE_MANAGER 26-Dec-2007
New CREATE_PLAN_DIRECTIVE parameters DBMS_RESOURCE_MANAGER 26-Dec-2007
New CREATE_SIMPLE_PLAN parameters DBMS_RESOURCE_MANAGER 26-Dec-2007
New DELETE_CATEGORY procedure DBMS_RESOURCE_MANAGER 26-Dec-2007
New UPDATE_CATEGORY procedure DBMS_RESOURCE_MANAGER 26-Dec-2007
New UPDATE_CONSUMER_GROUP parameters DBMS_RESOURCE_MANAGER 26-Dec-2007
New UPDATE_PLAN parameters DBMS_RESOURCE_MANAGER 26-Dec-2007
New UPDATE_PLAN_DIRECTIVE parameters DBMS_RESOURCE_MANAGER 26-Dec-2007
New package and functionality DBMS_RESULT_CACHE 09-Aug-2007
New CONVERT_DBMS_JOB procedure DBMS_SCHEDULER 18-May-2008
New CREATE_CREDENTIAL procedure DBMS_SCHEDULER 18-May-2008
New CREATE_JOB parameters DBMS_SCHEDULER 18-May-2008
New CREATE_JOBS procedure DBMS_SCHEDULER 18-May-2008
New DROP_CREDENTIAL procedure DBMS_SCHEDULER 18-May-2008
New ENABLE parameter DBMS_SCHEDULER 18-May-2008
New END_DETACHED_JOB_RUN procedure DBMS_SCHEDULER 18-May-2008
New GET_FILE procedure with 3 overloads DBMS_SCHEDULER 18-May-2008
New  PUT_FILE procedure with 3 overloads DBMS_SCHEDULER 18-May-2008
New REGISTER_REMOTE_DATABASE procedure DBMS_SCHEDULER 18-May-2008
New SET_AGENT_REGISTRATION_PASS procedure DBMS_SCHEDULER 18-May-2008
New SET_JOB_ATTRIBUTES procedure DBMS_SCHEDULER 18-May-2008
New SHOW_ERRORS procedure DBMS_SCHEDULER 18-May-2008
New STOP_JOB parameter DBMS_SCHEDULER 18-May-2008
New SUBMIT_REMOTE_EXTERNAL_JOB procedure DBMS_SCHEDULER 18-May-2008
New UNREGISTER_REMOTE_DATABASE procedure DBMS_SCHEDULER 18-May-2008
New DISCONNECT_SESSION parameter DBMS_SERVICE 26-Dec-2007
New SESSION_TRACE_ENABLE parameter DBMS_SESSION 26-Aug-2007
New SET_EDITION procedure DBMS_SESSION 26-Aug-2007
New Package (undocumented  by Oracle) DBMS_SESSION_STATE 14-Dec-2007
New PURGE procedure DBMS_SHARED_POOL 20-Nov-2007
New NGLOB_VERIFY procedure DBMS_SPACE_ADMIN 23-Aug-2007
New package for SQL Plan Management DBMS_SPM 13-Sep-2007
New DESCRIBE_COLUMNS3 procedure DBMS_SQL 14-Apr-2008
New TO_CURSOR_NUMBER function DBMS_SQL 14-Apr-2008
New TO_REFCURSOR function DBMS_SQL 14-Apr-2008
New TO_REFCURSOR function DBMS_SQL 07-Dec-2008
New package for Diagnosing SQL related issues DBMS_SQLDIAG 28-Sep-2007
New package to predict the impact of environment changes DBMS_SQLPA 13-Sep-2007
New ADD_SQLSET_REFERENCE parameter DBMS_SQLTUNE 08-Dec-2008
New CAP_STS_CBK procedure DBMS_SQLTUNE 08-Dec-2008
New CHECK_SQL_PROFILE_PRIV procedure DBMS_SQLTUNE 08-Dec-2008
New CHECK_SQLSET_PRIVS procedure DBMS_SQLTUNE 08-Dec-2008
New EXECUTE_TUNING_TASK parameter and overloaded function DBMS_SQLTUNE 08-Dec-2008
New EXTRACT_BIND procedure DBMS_SQLTUNE 08-Dec-2008
New EXTRACT_BINDS procedure DBMS_SQLTUNE 08-Dec-2008
New IMPLEMENT_TUNING_TASK procedure DBMS_SQLTUNE 08-Dec-2008
New PREPARE_AWR_STATEMENT procedure DBMS_SQLTUNE 08-Dec-2008
New PREPARE_SQLSET_STATEMENT procedure DBMS_SQLTUNE 08-Dec-2008
New REMOVE_SQLSET_REFERENCE parameter DBMS_SQLTUNE 08-Dec-2008
New REPORT_AUTO_TUNING_TASK procedure DBMS_SQLTUNE 08-Dec-2008
New REPORT_SQL_MONITOR procedure DBMS_SQLTUNE 08-Dec-2008
New REPORT_SQL_MONITOR_LIST_XML procedure DBMS_SQLTUNE 08-Dec-2008
New REPORT_SQL_MONITOR_XML procedure DBMS_SQLTUNE 08-Dec-2008
New REPORT_TUNING_TASK parameters DBMS_SQLTUNE 08-Dec-2008
New SCRIPT_TUNING_TASK parameter DBMS_SQLTUNE 08-Dec-2008
New SET_TUNING_TASK_PARAMETER procedure DBMS_SQLTUNE 08-Dec-2008
New SQLSET_PROGRESS_STATS procedure DBMS_SQLTUNE 08-Dec-2008
New SQLTEXT_TO_SIGNATURE overload DBMS_SQLTUNE 08-Dec-2008
New TRANSFORM_SQLSET_CURSOR procedure DBMS_SQLTUNE 08-Dec-2008
New UPDATE_SQLSET overload and parameters DBMS_SQLTUNE 08-Dec-2008
New undocumented CLEANUP_STATS_JOB_procedure DBMS_STATS 09-Aug-2007
New COPY_TABLE_STATS procedure DBMS_STATS 09-Aug-2007
New CREATE_EXTENDED_STATS proc. for virtual columns DBMS_STATS 02-Mar-2008
New CREATE_STAT_TABLE parameter DBMS_STATS 09-Aug-2007
New DELETE_COLUMN_STATS parameter DBMS_STATS 09-Aug-2007
New DELETE_DATABASE_PREFS procedure DBMS_STATS 09-Aug-2007
New DELETE_DATABASE_STATS parameter DBMS_STATS 09-Aug-2007
New DELETE_INDEX_STATS parameter DBMS_STATS 09-Aug-2007
New DELETE_PENDING_STATS procedure DBMS_STATS 09-Aug-2007
New DELETE_SCHEMA_PREFS procedure DBMS_STATS 09-Aug-2007
New DELETE_SCHEMA_STATS parameter DBMS_STATS 09-Aug-2007
New DELETE_TABLE_PREFS procedure DBMS_STATS 09-Aug-2007
New DELETE_TABLE_STATS parameter DBMS_STATS 09-Aug-2007
New DIFF_TABLE_STATS_IN_HISTORY procedure DBMS_STATS 09-Aug-2007
New DIFF_TABLE_STATS_IN_PENDING procedure DBMS_STATS 09-Aug-2007
New DIFF_TABLE_STATS_IN_STATTAB procedure DBMS_STATS 09-Aug-2007
New DROP_EXTENDED_STATS procedure DBMS_STATS 02-Mar-2008
New EXPORT_DATABASE_PREFS procedure DBMS_STATS 09-Aug-2007
New EXPORT_PENDING_STATS procedure DBMS_STATS 09-Aug-2007
New EXPORT_SCHEMA_PREFS procedure DBMS_STATS 09-Aug-2007
New EXPORT_TABLE_PREFS procedure DBMS_STATS 09-Aug-2007
New GATHER_DATABASE_STATS parameters DBMS_STATS 09-Aug-2007
New GATHER_DICTIONARY_STATS parameter DBMS_STATS 09-Aug-2007
New GATHER_INDEX_STATS parameter DBMS_STATS 09-Aug-2007
New GATHER_SCHEMA_STATS parameters DBMS_STATS 09-Aug-2007
New GATHER_SYSTEM_STATS new default DBMS_STATS 09-Aug-2007
New GATHER_TABLE_STATS parameter DBMS_STATS 09-Aug-2007
New GET_INDEX_STATS new overloads DBMS_STATS 09-Aug-2007
New GET_PREFS new procedure DBMS_STATS 09-Aug-2007
New IMPORT_DATABASE_PREFS procedure DBMS_STATS 09-Aug-2007
New IMPORT_SCHEMA_PREFS procedure DBMS_STATS 09-Aug-2007
New IMPORT_TABLE_PREFS procedure DBMS_STATS 09-Aug-2007
New LOCK_SCHEMA_STATS parameter DBMS_STATS 09-Aug-2007
New PUBLISH_PENDING_STATS procedure DBMS_STATS 09-Aug-2007
New RESET_GLOBAL_PREF_DEFAULTS procedure DBMS_STATS 09-Aug-2007
New RESUME_GATHER_STATS procedure DBMS_STATS 09-Aug-2007
New SET_DATABASE_PREFS procedure DBMS_STATS 09-Aug-2007
New SET_GLOBAL_PREFS procedure DBMS_STATS 09-Aug-2007
New SET_SCHEMA_PREFS procedure DBMS_STATS 09-Aug-2007
New SET_TABLE_PREFS procedure DBMS_STATS 09-Aug-2007
New SHOW_EXTENDED_STATS_NAME procedure DBMS_STATS 02-Mar-2008
New TO_CASCADE_TYPE procedure DBMS_STATS 09-Aug-2007
New TO_DEGREE_TYPE procedure DBMS_STATS 09-Aug-2007
New TO_ESTIMATE_PERCENT_TYPE procedure DBMS_STATS 09-Aug-2007
New TO_INVALIDATE_TYPE procedure DBMS_STATS 09-Aug-2007
New TO_PUBLISH_TYPE procedure DBMS_STATS 09-Aug-2007
New UNLOCK_SCHEMA_STATS parameter DBMS_STATS 09-Aug-2007
New UNLOCK_TABLE_STATS parameter DBMS_STATS 09-Aug-2007
New COMPATIBLE_11_1 function DBMS_STREAMS 01-Apr-2008
New GET_MESSAGE_TRACKING parameter DBMS_STREAMS_ADM 01-Apr-2008
New MERGE_STREAMS procedure DBMS_STREAMS_ADM 01-Apr-2008
New MERGE_STREAMS_JOB procedure DBMS_STREAMS_ADM 01-Apr-2008
New SET_MESSAGE_TRACKING parameter DBMS_STREAMS_ADM 01-Apr-2008
New SPLIT_STREAMS procedure DBMS_STREAMS_ADM 01-Apr-2008
New Storage Mapping API to FMON DBMS_STORAGE_MAP 19-Aug-2007
New ADD_PARAMETER_VALUE procedure DBMS_SYSTEM 28-Mar-2008
New REMOVE_PARAMETER_VALUE procedure DBMS_SYSTEM 28-Mar-2008
New CHECKTABLESPACE procedure DBMS_TTS 07-Apr-2008
New INSERT_ERROR function DBMS_TTS 07-Apr-2008
New VALIDATE parameter (not used) DBMS_UTILITY 26-Dec-2007
New PL/SQL Warnings DBMS_WARNING 09-Aug-2007
New PL/SQL package related to Workload Management DBMS_WLM 19-Sep-2007
New package for capturing workload DBMS_WORKLOAD_CAPTURE 07-Sep-2007
New package for replaying captured workload DBMS_WORKLOAD_REPLAY 07-Sep-2007
New ADD_COLORED_SQL procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New ASH_REPORT_HTML procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New ASH_REPORT_TEXT procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New AWR_DIFF_REPORT_HTML procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New AWR_DIFF_REPORT_TEXT procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New SQL_DIFF_REPORT_HTML procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New SQL_DIFF_REPORT_TEXT procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New CREATE_BASELINE parameter DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New CREATE_BASELINE_TEMPLATE procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New DROP_BASELINE_TEMPLATE procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New MODIFY_BASELINE_WINDOW_SIZE procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New REMOVE_COLORED_SQL procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New RENAME_BASELINE procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New SELECT_BASELINE_DETAILS procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New SELECT_BASELINE_METRICS procedure DBMS_WORKLOAD_REPOSITORY 16-Aug-2007
New package containing the XA/Open interface (save session state) DBMS_XA 13-Aug-2007
New CLEANUP_EXPIRED_NFSCLIENTS procedure DBMS_XDBUTIL_INT 26-Dec-2007
New FIXACL function DBMS_XDBUTIL_INT 26-Dec-2007
New FIXACL_DOWNGRADE function DBMS_XDBUTIL_INT 26-Dec-2007
New FLUSHSESSION procedure DBMS_XDBUTIL_INT 26-Dec-2007
New GETNEWOID function DBMS_XDBUTIL_INT 26-Dec-2007
New NUMTOHEX2 function DBMS_XDBUTIL_INT 26-Dec-2007
New RAWTONUM2 function DBMS_XDBUTIL_INT 26-Dec-2007
New SETLINKPARENTS procedure DBMS_XDBUTIL_INT 26-Dec-2007
New BUILD_PLAN_XML procedure DBMS_XPLAN 15-Aug-2007
New DISPLAY_PLAN procedure DBMS_XPLAN 15-Aug-2007
New DISPLAY_SQL_PLAN_BASELINE procedure DBMS_XPLAN 15-Aug-2007
New FORMAT_NUMBER function DBMS_XPLAN 15-Aug-2007
New FORMAT_NUMBER2 function DBMS_XPLAN 15-Aug-2007
New FORMAT_SIZE function DBMS_XPLAN 15-Aug-2007
New FORMAT_SIZE2 function DBMS_XPLAN 15-Aug-2007
New FORMAT_TIME_S function DBMS_XPLAN 15-Aug-2007
Modified to use DBMS_ASSERT to prevent SQL Injection OWA_OPT_LOCK 26-Dec-2007
New package UTL_SPADV 18-Mar-2008
New COMPARE procedure UTL_XML 01-Apr-2008
New ISNAMEOMF procedure UTL_XML 01-Apr-2008
New PARSEEXPR procedure UTL_XML 01-Apr-2008
New PARSEQUERY procedure UTL_XML 01-Apr-2008
New XMLGETTABLEFROMDOC procedure UTL_XML 01-Apr-2008
New in the 11.1.0.7 Patch
New DBMS_AUDIT_MGMT package DBMS_AUDIT_MGMT 29-Dec-2008
New BACKUPCONTROLFILE overload DBMS_BACKUP_RESTORE 03-Jan-2009
New CLEANUPFOREIGNARCHIVEDLOGS procedure DBMS_BACKUP_RESTORE 02-Jan-2009
New REEVALUATEOPENFAILURES overload DBMS_IR 03-Jan-2009
New IS_APPLY_SERVER function DBMS_LOGSTDBY 01-Jan-2009
New GET_INDEX_INTCOL function DBMS_METADATA 30-Dec-2008
New GET_STAT_COLNAME function DBMS_METADATA 30-Dec-2008
New GET_STAT_INDNAME procedure DBMS_METADATA 30-Dec-2008
New DBMS_METADATA_DIFF package DBMS_METADATA_DIFF 22-Dec-2008
New GET_HASHCODE DBMS_METADATA_UTIL 30-Dec-2008
New GET_INDEX_INTCOL DBMS_METADATA_UTIL 30-Dec-2008
New CREATE_JOBS overload DBMS_SCHEDULER 03-Jan-2009
New REMOTE_PROCESS_SQL DBMS_SQLPA 31-Dec-2008
New SELECT_SQL_TRACE function DBMS_SQLTUNE 31-Dec-2008
New MERGE_COL_USAGE procedure DBMS_STATS 01-Jan-2009
New CLIENT_VITALS procedure DBMS_WORKLOAD_REPLAY 03-Jan-2009
New GET_ADVANCED_PARAMETER function DBMS_WORKLOAD_REPLAY 03-Jan-2009
New PAUSE_REPLAY procedure DBMS_WORKLOAD_REPLAY 03-Jan-2009
New PROCESS_CAPTURE parameter DBMS_WORKLOAD_REPLAY 03-Jan-2009
New PROCESS_CAPTURE_COMPLETION function DBMS_WORKLOAD_REPLAY 03-Jan-2009
New PROCESS_CAPTURE_REMAINING_TIME function DBMS_WORKLOAD_REPLAY 03-Jan-2009
New RESET_ADVANCED_PARAMETERS procedure DBMS_WORKLOAD_REPLAY 03-Jan-2009
New RESUME_REPLAY procedure DBMS_WORKLOAD_REPLAY 03-Jan-2009
New SET_ADVANCED_PARAMETER procedure DBMS_WORKLOAD_REPLAY 03-Jan-2009
New CONTROL_RESTRICTED_SNAPSHOT procedure DBMS_WORKLOAD_REPOSITORY 02-Jan-2009
New PREPARE_PLAN_XML_QUERY function DBMS_XPLAN 01-Jan-2009
New UTL_XML.GETHASHCODE procedure UTL_XML 31-Dec-2008
New UTL_XML.TYPEHASHCODEEQ function UTL_XML 31-Dec-2008
New Functions and Procedures in 11.1.0.7 Added To Existing Packages
DBMS_AQADM_SYS.SCHEDULE_PROPAGATION
DBMS_AQADM_SYS.UNSCHEDULE_PROPAGATION
DBMS_ASH_INTERNAL.GET_BLK_STR
DBMS_AW.GET_OBJ_PROTECT
DBMS_AW.SET_OBJ_PROTECT
DBMS_AW_EXP.IMPORT_BEGIN112
DBMS_AW_EXP.IMPORT_CALLOUT112
DBMS_AW_EXP.IMPORT_CHUNK112
DBMS_AW_EXP.IMPORT_FINISH112
DBMS_AW_EXP.SCHEMA_CALLOUT
DBMS_HS_PARALLEL_METADATA.DELETE_VIEWOBJ
DBMS_HS_PARALLEL_METADATA.INSERT_VIEWOBJ
DBMS_JAVA.DBMS_FEATURE_OJVM
DBMS_JAVA_DEFINERS Package
DBMS_LOGREP_UTIL.SET_CCA_MAX_PERCENTAGE
DBMS_REPCAT_DECL.LOCAL_MATCH
DBMS_REPCAT_DECL.LOCAL_NODE
DBMS_SCHED_MAIN_EXPORT.TS_TO_CHAR
DBMS_SQLTUNE_UTIL1.ALTER_SESSION_PARAMETER
DBMS_SQLTUNE_UTIL1.CHECK_QA_LRG_TYPE
DBMS_SQLTUNE_UTIL1.RESTORE_SESSION_PARAMETER
DBMS_STATS_INTERNAL.AGGREGATE_INDSTATS
DBMS_STATS_INTERNAL.COLHASBASESTATS
DBMS_STATS_INTERNAL.COLHASHISTOGRAM
DBMS_STATS_INTERNAL.GET_BLKCNT
DBMS_STATS_INTERNAL.GET_TABLE_GSTATS
DBMS_STATS_INTERNAL.INDHASGLOBALSTATS
DBMS_STATS_INTERNAL.INDPARTSHAVESTATS
DBMS_STATS_INTERNAL.TABPARTSHAVESTATS
DBMS_STREAMS_ADV_ADM_UTL.COLLECT_COMPONENT_EVENT_LOCAL
DBMS_STREAMS_ADV_ADM_UTL.TRACE_COMPONENT_EVENTS
DBMS_STREAMS_ADV_ADM_UTL.TRACE_COMPONENT_PROPS
DBMS_SWRF_REPORT_INTERNAL.ASH_BUILD_REPORT_CHAPTERS
DBMS_SWRF_REPORT_INTERNAL.ASH_BUILD_REPORT_SECTIONS
DBMS_SWRF_REPORT_INTERNAL.AWR_BUILD_REPORT_CHAPTERS
DBMS_SWRF_REPORT_INTERNAL.AWR_BUILD_REPORT_SECTIONS
DBMS_SWRF_REPORT_INTERNAL.DBFUS_BUILD_REPORT_CHAPTERS
DBMS_SWRF_REPORT_INTERNAL.DBFUS_BUILD_REPORT_SECTIONS
DBMS_SWRF_REPORT_INTERNAL.DIFF_BUILD_REPORT_CHAPTERS
DBMS_SWRF_REPORT_INTERNAL.DIFF_BUILD_REPORT_SECTIONS
DBMS_SWRF_REPORT_INTERNAL.SQL_BUILD_REPORT_CHAPTERS
DBMS_SWRF_REPORT_INTERNAL SQL_BUILD_REPORT_SECTIONS
DBMS_SWRF_REPORT_INTERNAL.WCR_BUILD_REPORT_CHAPTERS
DBMS_SWRF_REPORT_INTERNAL.WCR_BUILD_REPORT_SECTIONS
DBMS_WRR_INTERNAL.ACQUIRE_WRR_LOCK
DBMS_XMLTABLEINDEX.ALTERINDEXADDCOLUMN
DBMS_XMLTABLEINDEX.ALTERINDEXDROPCOLUMN
DBMS_XMLTABLEINDEX.ALTERINDEXRENAMECOLUMN
DBMS_XMLTABLEINDEX.CREATEINDEX
JOB_DEFINITION.JOB_DEFINITION
KUPD$DATA_INT.CONVENTIONAL_LOAD
KUPV$FT_INT.CHECK_USER_VALID
ODM_MODEL_UTIL.VALIDATE_SQLNAME_NOQUOTES
PRVT_ADVISOR.ADJUST_STRING
PRVT_ADVISOR.GATHER_STATISTICS
XMLTABLEINDEXMETHODS.ODCIINDEXEXCHANGEPARTITION
XMLTABLEINDEXMETHODS.ODCIINDEXUPDPARTMETADATA
   
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [108 users online]    © 2010 psoug.org