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. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
