Entries tagged as Oracle DBA
OLE automation
What is OLE automation ? Â OLE automation allows an OLE server application to expose a set of commands and functions that can be invoked from an OLE container application. OLE automation provides a way for an OLE container application to use the features of an OLE server application to manipulate an OLE object from Read More...
STATSPACK
What is STATSPACK and how does one use it? Â Statspack is a set of performance monitoring and reporting utilities provided by Oracle from Oracle8i and above. Statspack provides improved BSTAT/ESTAT functionality, though the old BSTAT/ESTAT scripts are still available. For more information about STATSPACK, read the documentation in file $ORACLE_HOME/rdbms/admin/spdoc.txt. Install Statspack: cd $ORACLE_HOME/rdbms/admin Read More...
SQL*Loader to load images, sound clips and documents
How does one use SQL*Loader to load images, sound clips and documents? Â SQL*Loader can load data from a “primary data file”, SDF (Secondary Data file – for loading nested tables and VARRAYs) or LOGFILE. The LOBFILE method provides and easy way to load documents, images and audio clips into BLOB and CLOB columns. Look Read More...
Tools utilities Oracle provide to assist with performance tuning
What tools/utilities does Oracle provide to assist with performance tuning? Â Oracle provide the following tools/ utilities to assist with performance monitoring and tuning: . TKProf . UTLBSTAT.SQL and UTLESTAT.SQL – Begin and end stats monitoring . Statspack . Oracle Enterprise Manager – Tuning Pack Read More...