CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
HOME | BROWSE | SEARCH | REFERENCE | ADD CODE | LINKS | SPONSORS
SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes. Click here to find out more.
Search the Reference Library pages:  
Help us help you! Take our 1-minute PSOUG survey. Free Oracle Magazines & 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		    
 
 
Contact Us • Legal Notices and Terms of Use • Privacy Statement
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [36 visitors online]    © 2009 psoug.org