 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 8 -
Miscellaneous Oracle Information
Oracle9i - Resumable Space Allocation
Running update jobs that insert or update large
amounts of data also cause their fair share of problems. Estimating
the space required by large operations can be quite a formidable
forecasting effort.
Do you add extra space to data and index
tablespaces? Do you make the table and index INITIAL and NEXT extent
sizes bigger? Do you increase the size of the rollback segments to
handle the additional load? Should you increase the size of your
TEMP tablespace and make your default INITIAL and NEXT extent sizes
larger?
In previous releases, when an out of space
condition occurred, the statement quit running and the database
rolled back the unit of work. Rolling back can be a time-consuming
(sometimes a VERY time-consuming) process. The DBA corrected the
problem and the program was run again (hopefully successfully the
second time). How many times have there been a third, fourth and
fifth time?
Oracle 9i solves this problem with resumable
statements. Oracle9i temporarily pauses SQL statements that suffer
from out of space conditions (no freespace in tablespace, file
unable to expand, maxextents or maximum quota reached). The DBA is
able to easily identify the problem and correct the error. The
statement will then resume execution until completion.
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. |
|
