NEW 10g UTILITIES

Oracle 10g Utilities - NASHIM

**************************************************

dbms_file_transfer:

There are three procedures within the dbms_file_transfer package:

COPY_FILE: This is useful for copying files locally on the database server.

GET_FILE: This is useful when a file on a remote database is to be transferred to a local file system through the local database connection.

PUT_FILE: Reads a local file and contacts a remote database to create a copy of the file in the remote file system

Assume that the tablespace containing a data file with excessive IO was created as follows:

CREATE TABLESPACE ts_hotspot LOGGING
DATAFILE '/usr/oracle/databases/mid101so/datafiles/hotspot.dbf' SIZE 5120K REUSE
BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO;

The following SQL demonstrates how he can move the datafile from a hotspot to a different location without executing an OS command. As the DBA user, execute the following command.

CREATE DIRECTORY DEST_DIR AS '/tmp';
CREATE DIRECTORY SOURCE_DIR AS '/usr/oracle/databases/mid101so/datafiles';

As user SYS, create the necessary grants.

GRANT EXECUTE ON DBMS_FILE_TRANSFER to DBA
GRANT READ ON DIRECTORY SOURCE_DIR to DBA
GRANT WRITE ON DIRECTORY DEST_DIR to DBA

.As the DBA user, execute the following command.

ALTER TABLESPACE ts_hotspot READ ONLY;
BEGIN
dbms_file_transfer.copy_file( source_directory_object => 'SOURCE_DIR',
source_file_name => 'hotspot.dbf',
destination_directory_object => 'DEST_DIR',
destination_file_name => 'hotspot.dbf');
END;
/
ALTER TABLESPACE ts_hotspot OFFLINE;
ALTER TABLESPACE ts_hotspot RENAME datafile '/usr/oracle/databases/mid101so/datafiles/hotspot.dbf' TO '/tmp/hotspot.dbf';
ALTER TABLESPACE ts_hotspot ONLINE;
ALTER TABLESPACE ts_hotspot READ WRITE;

 

New 10g packages

The following packages are new in Oracle 10G. Note that some may be included in this list that have existed in prior versions of the database- they just were not installed by default and required running additional scripts from ORACLE_HOME/rdbms/admin (like DBMS_PROFILER). The ones listed below are the new ones installed by default in Oracle 10G.

CONNECTIONINTERFACE
CURSORMANAGERINTERFACE
DATABASEINTERFACE
DATAPROVIDERINTERFACE
DBMSHSXP
DBMS_ADVANCED_REWRITE
DBMS_ADVISOR
DBMS_AQ_BQVIEW
DBMS_CDC_DPUTIL
DBMS_CDC_EXPDP
DBMS_CDC_EXPVDP
DBMS_CDC_IMPDP
DBMS_CDC_IPUBLISH
DBMS_CDC_ISUBSCRIBE
DBMS_CRYPTO
DBMS_CRYPTO_FFI
DBMS_CRYPTO_TOOLKIT
DBMS_CRYPTO_TOOLKIT_FFI
DBMS_DATAPUMP
DBMS_DBUPGRADE
DBMS_DBVERIFY
DBMS_DIMENSION
DBMS_FBT
DBMS_FEATURE_USAGE
DBMS_FEATURE_USAGE_INTERNAL
DBMS_FILE_TRANSFER
DBMS_FREQUENT_ITEMSET
DBMS_INDEX_UTL
DBMS_INTERNAL_SAFE_SCN
DBMS_ISCHED
DBMS_I_INDEX_UTL
DBMS_JAVA
DBMS_JAVA_DUMP
DBMS_JMS_PLSQL
DBMS_LDAP
DBMS_LDAP_API_FFI
DBMS_LDAP_UTL
DBMS_LOGREP_UTIL_INVOK
DBMS_LOGSTDBY_PUBLIC
DBMS_MONITOR
DBMS_PROFILER
DBMS_PRVT_TRACE
DBMS_REGISTRY_SERVER
DBMS_REPCAT_EXP
DBMS_REPCAT_MIGRATION
DBMS_RULE_EXP_UTLI
DBMS_SCHEDULER
DBMS_SCHED_CLASS_EXPORT
DBMS_SCHED_EXPORT_CALLOUTS
DBMS_SCHED_JOB_EXPORT
DBMS_SCHED_MAIN_EXPORT
DBMS_SCHED_PROGRAM_EXPORT
DBMS_SCHED_SCHEDULE_EXPORT
DBMS_SCHED_WINDOW_EXPORT
DBMS_SCHED_WINGRP_EXPORT
DBMS_SCHEMA_COPY
DBMS_SERVER_ALERT
DBMS_SERVER_ALERT_EXPORT
DBMS_SERVER_TRACE
DBMS_SERVICE
DBMS_SQLTUNE
DBMS_SQLTUNE_INTERNAL
DBMS_STAT_FUNCS
DBMS_STAT_FUNCS_AUX
DBMS_STREAMS_ADM_UTL_INVOK
DBMS_STREAMS_AUTH
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_DATAPUMP
DBMS_STREAMS_DATAPUMP_UTIL
DBMS_STREAMS_LCR_INT
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_ADM
DBMS_STREAMS_TBS_INT
DBMS_STREAMS_TBS_INT_INVOK
DBMS_SUM_RWEQ_EXPORT
DBMS_SUM_RWEQ_EXPORT_INTERNAL
DBMS_SWRF_INTERNAL
DBMS_SWRF_REPORT_INTERNAL
DBMS_TRANSFORM_INTERNAL
DBMS_UNDO_ADV
DBMS_UPGRADE_INTERNAL
DBMS_WARNING
DBMS_WARNING_INTERNAL
DBMS_WORKLOAD_REPOSITORY
DBMS_XMLQUERY
DBMS_XMLSAVE
DBMS_XMLSTORE
DBMS_XSOQ
DBMS_XSOQ_ODBO
DBMS_XSOQ_UTIL
DEFINITIONMANAGERINTERFACE
EXF$DBMS_EXPFIL_SYSPACK
GENCONNECTIONINTERFACE
GENCURSORMANAGERINTERFACE
GENDATABASEINTERFACE
GENDATAPROVIDERINTERFACE
GENDATATYPEIDCONSTANTS
GENDEFINITIONMANAGERINTERFACE
GENFUNCTIONIDCONSTANTS
GENINTERRUPTABLEINTERFACE
GENMDMCLASSCONSTANTS
GENMDMOBJECTIDCONSTANTS
GENMDMPROPERTYIDCONSTANTS
GENMETADATAPROVIDERINTERFACE
GENPARAMETERIDCONSTANTS
GENSERVERINTERFACE
GENSNAPIINTERFACE
GET_ERROR$
INITJVMAUX
INTERRUPTABLEINTERFACE
JAVA_XA
KUPC$QUEUE
KUPC$QUEUE_INT
KUPC$QUE_INT
KUPD$DATA
KUPD$DATA_INT
KUPF$FILE
KUPF$FILE_INT
KUPM$MCP
KUPP$PROC
KUPV$FT
KUPV$FT_INT
KUPW$WORKER
LT
LTADM
LTAQ
LTDDL
LTDTRG
LTPRIV
LTRIC
LTUTIL
LT_CTX_PKG
LT_EXPORT_PKG
METADATAPROVIDERINTERFACE
OLAP_API_SESSION_INIT
OWM_9IP_PKG
OWM_BULK_LOAD_PKG
OWM_DDL_PKG
OWM_IEXP_PKG
OWM_MIG_PKG
OWM_MP_PKG
OWM_REPUTIL
OWM_VT_PKG
PRVT_ACCESS_ADVISOR
PRVT_ADVISOR
PRVT_DIMENSION_SYS_UTIL
PRVT_HDM
PRVT_SYS_TUNE_MVIEW
PRVT_TUNE_MVIEW
PRVT_UADV
PRVT_WORKLOAD
RMJVM
SERVERINTERFACE
SQLJUTL
SQLJUTL2
UD_TRIGS
UTL_COMPRESS
UTL_DBWS
UTL_I18N
UTL_LMS
UTL_RECOMP
UTL_SYS_COMPRESS
WM_DDL_UTIL
WM_ERROR
XML_SCHEMA_NAME_PRESENT
 

New Oracle 10g binary utilities

The list below displays the new OS files in 10G ($ORACLE_HOME/bin) as compared to 9.2.  Most of these binaries are completely uninteresting although a few warrant additional research, mainly trcsess. 

agentok.buf

cemutls

clscfg

clsfmt

clsid

cmadmin

cmctl

cmgw

cmmigr

crsctl

ctxlc

dsm121dif

e2eme

emagent

emagtm

emctl

emtgtct1

emtgtct12

emutil

emwd

expdp

extjob

extproc32

genezi

impdp

isqlplusctl

kfod

lbuilder

lcsscan

localconfig

lsnodes

makeserverwlt

mkstore

netlaunch

nmb

nmei

nmo

nmocat

nmuct

nmupm

nmus

ocrcheck

ocrconfig

ocrdump

ocssd

oidca

olsadmintool

olsoidsync

onsctl

orajaxb

orapipe

orapki

osdbagrp

proc

proxyserv

rawutl

repo_mig

runclass

searchctl

sslsetup

trcsess

xsl

xvm