Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

 


The best of IOUG 2005


Oracle 10g Utilities - Dave Moore

Dave Moore, chief technologist for BMC software gave a wonderful presentation titled Oracle 10g Utilities.  Lively and interesting, Dave Moore specializes in Oracle Utilities and is the author of the book "Oracle Utilities":

The top excerpts include listing of the new 10g PL/SQL packages and Oracle 10g binaries.  Best of all, Moore  went into detail on the new data pump (incorporated into expdp and impdb) with the spectacular re-start feature, and the new file transfer utility dbms_file_transfer.  According to Moore:

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

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


For more details on Oracle utilities, see the book "Advanced Oracle Utilities" by Bert Scalzo, Donald K. Burleson, and Steve Callan.

You can buy it direct from the publisher for 30% off directly from Rampant TechPress


 

 
 
��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational