Expanded Supplied Packages with 10g – Part I

Beside New Dictionary Enhancements with 10g Series I will start to write on Expanded Supplied Packages with 10g. With 10g several packages upgraded and enhanced, also documentation is upgraded. “catproc.sql” can be used to identify these packages installed by default.

- Oracle 9iR2 Supplied PL/SQL Packages & Types Reference Covers 101 Packages
- Oracle 10gR1 PL/SQL Packages & Types Reference Covers 166 Packages
- Oracle 10gR2 PL/SQL Packages & Types Reference Covers 180 Packages

- New Oracle9i Oracle Supplied Packages (19)

DBMS_APPLY_ADM	DBMS_CAPTURE_ADM
DBMS_FGA	DBMS_FLASHBACK
DBMS_LDAP	DBMS_LIBCACHE
DBMS_LOGMNR_CDC_PUBLISH	DBMS_LOGMNR_CDC_SUBSCRIBE
DBMS_METADATA	DBMS_ODCI
DBMS_OUTLN_EDIT	DBMS_REDEFINITION
DBMS_TRANSFORM	DBMS_WM
DBMS_XMLGEN	DBMS_XMLQUERY
DMBS_XMLSAVE	UTL_ENCODE
UTL_URL

- New Oracle9i R2 Oracle Supplied Packages (18)

DBMS_APPLY_ADM	DBMS_CAPTURE_ADM
DBMS_LOGSTDBY	DBMS_MGWADM
DBMS_MGWMSG	DBMS_PROPAGATION_ADM
DBMS_RULE	DBMS_RULE_ADM
DBMS_STORAGE_MAP	DBMS_STREAMS
DBMS_STREAMS_ADM	DBMS_XDB
DBMS_XDBT	DBMS_XDB_VERSION
DBMS_XMLDOM	DBMS_XMLPARSER
DBMS_XPLAN	DBMS_XSLPROCESSOR

- New Oracle10g R1 Oracle Supplied Packages (51) and 60 Packages Updates in Oracle10gR1

DBMS_ADVANCED_REWRITE	DBMS_SERVICE
DBMS_ADVISOR	DBMS_SQLTUNE
DBMS_CRYPTO	DBMS_STAT_FUNCS
DBMS_DATAPUMP	DBMS_STREAMS_AUTH
DBMS_DATA_MINING	DBMS_STREAMS_MESSAGING
DBMS_DATA_MINING_TRANSFORM	DBMS_STREAMS_TABLESPACE_ADM
DBMS_DIMENSION	DBMS_WARNING
DBMS_FILE_TRANSFER	DBMS_WORKLOAD_REPOSITORY
DBMS_FREQUENT_ITEMSET	DBMS_XDBZ
DBMS_JAVA	DBMS_XMLSTORE
DBMS_MONITOR	HTF
DBMS_SCHEDULER	HTMLDB_APPLICATION
DBMS_SERVER_ALERT	HTMLDB_CUSTOM_AUTH
HTMLDB_ITEM	SDO_GEOR
HTMLDB_UTIL	SDO_GEOR_UTL
HTP	SDO_NET
OWA_CACHE	SDO_SAM
OWA_COOKIE	SDO_TOPO
OWA_CUSTOM	SDO_TOPO_MAP
OWA_IMAGE	UTL_COMPRESS
OWA_OPT_LOCK	UTL_DBWS
OWA_PATTERN	UTL_I18N
OWA_SEC	UTL_LMS
OWA_TEXT	UTL_MAIL
OWA_UTIL	WPG_DOCLOAD
SDO_GCDR

- New Oracle10g R2 Oracle Supplied Packages (14) and 53 Packages Updates in Oracle10gR2

DBMS_AQELM	DBMS_FILE_GROUP
DBMS_AQIN	DBMS_PREDICTIVE_ANALYTICS
DBMS_CHANGE_NOTIFICATION	DBMS_PREPROCESSOR
DBMS_DB_VERSION	DBMS_RLMGR
DBMS_EPG	DBMS_TDB
DBMS_ERRLOG	SDO_NET_MEM
DBMS_EXPFIL	UTL_NLA

PL/SQL has grown tremendously with Oracle 10g R1 and R2. This growth includes a wide range of both DBA and Developer enhancements. We need to learn these features and make sure thoroughly understand these prior to start using. Knowing what Oracle has provided will expand your arsenal, utilize your cost and get you a competitive advantage especially in terms of being time-to-market. These packages are all supported by Oracle and tested over and over again, so dont reinvent the wheel and get rid of the maintenance costs of a newly developed applications ;)

Continue reading with Part 2

References used :
“The PL/SQL Grid: Time to Expand to 10g R1 & 10g R2¨ presentation by Joe Trezzo
What’s New in PL/SQL in Oracle Database 10g? Oracle Technology Network(OTN) Paper