| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Autoextend WAIT statistic?
Dennis:
It depends whether you use Dictionary Management or
Local Management for Extent allocation. If you use
dictionary management you will see the ST enqueue
contention in X$KSQST (Kernel Services enQueue Statistic
Types) and if it is Locally Managed tablespace you may
find contention for BitMap Blocks (level1?) in the
V$WAITSTAT.
Best Regards,
K Gopalakrishnan
-----Original Message-----
WILLIAMS
Sent: Tuesday, November 26, 2002 1:30 PM
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET: kaygopal_at_yahoo.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 - 18:04:10 CST
 |
 |