| 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?
K., Ian, Dan - Thanks so much for your replies. This is LMT. Dan -
appreciate your running a test, no wonder "you 'da man". Now I know the
statistic to keep an eye on, and which wait table. I'm not sure how much of
a problem this is, but when my sys admin gets an idea, he hangs on like a
bulldog, and damnit he's been right a few times!
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, November 26, 2002 5:26 PM
To: Multiple recipients of list ORACLE-L
Dennis,
I did some quick & dirty testing by creating a very small(10M) datafile with a large(2000m) autoextend clause. On the insert, the session was waiting on 'file open' for most of the time. When I did a rollback and reinserted the data, there were no waits (that I saw) on file open.
Interestingly, this wait event does not appear to be accurately tracked in v$session_event. In v$session_wait the seconds in wait (last trapped) was 132. In v$session_event, it shows 0. Okay, gurus, why? Am I missing something in this?
select * from v$session_wait where sid = 14
SID SEQ# EVENT
---------- ----------
P1TEXT P1P1RAW
P2TEXT P2P2RAW
P3TEXT P3 P3RAW WAIT_TIME SECONDS_IN_WAITSTATE
---------------------------------------------------------------- ----------
---------------- ---------- ---------------
14 322 file open
fib 4327126592
0000000101EAB640
iov 4327069760
0000000101E9D840
0 0
00 -1 132
WAITED SHORT TIME
select * from v$session_event where sid = 14
SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS
TIME_WAITED AVERAGE_WAIT MAX_WAIT
Dan Fink
-----Original Message-----
Sent: Tuesday, November 26, 2002 2: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 servicesReceived on Wed Nov 27 2002 - 10:44:34 CST
---------------------------------------------------------------------
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: Fink, Dan INET: Dan.Fink_at_mdx.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: 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).
 |
 |