Oracle says that when a file autoextends, there is a slight delay. Does
anyone know which Oracle WAIT statistic that would appear under?
We have been using autoextend on OLTP production tables for awhile now,
and the results have been satisfactory. This is an ERP system, so the
critical performance time is at month-end. Some of the developers are
concerned that table autoextending may slow batch programs, and suggesting
that I should determine which tables are likely to autoextend during
month-end and add storage beforehand. I would like to ensure that I am
fixing a real problem (short on time, like most of you), so I am wondering
if autoextend was causing a delay, what wait statistic would it show up
under. Any ideas?
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Nov 26 2002 - 15:29:40 CST
