 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 8 -
Miscellaneous Oracle Information
Compressing Export
Output Files in UNIX
-
Create the pipe - mknod expdat.dmp p
-
Start the compress in background compress - <
expdat.dmp > expdat.dmp.Z &
-
Wait a second or two before kicking off the
export - sleep 5
-
Start the export - scott/tiger file=expdat.dmp
Terminating Oracle
Processes (Threads) in Windows Systems
Oracle on NT provides the ORAKILL command to
kill Oracle processes (called threads) in Windows systems. You need
to specify the thread ID in Hex. Try orakill /? or orakill /h for
more details.
Truncating vs Deleting
The Oracle load utility and SQL language have
TRUNCATE commands that can be used to quickly remove data from
Oracle tables. TRUNCATE TABLE.......; is faster than the DELETE SQL
statement and running a load with the TRUNCATE option specified is
much faster than running the load utility with the REPLACE option.
The TRUNCATE option is faster because it doesn't generate any undo
information, does not fire DELETE triggers and does not record any
information in the snapshot log. Since it does not generate undo,
you cannot rollback the work to undo the removal of the data.
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
