Re: autoextend size vs. extent size in LMT

Morning Niall,

I'm afraid that only user entered 'alter database datafile ... resize ...' show up in the alert log. I tried another experiment and there was noting for the autoextend, but my manual extension (and contraction) did show up in the alert log.

I also tried setting event 10046 via alter system ... but that produced no output apart from a single line in the alert log to say that I had run it. I'll try agin when I can put it in the initSID.ora fileand see what happens.

Cheers,
Norman.

PS. Slightly misleading error message that one, by the way, for the 9.2 LMT thingy. Could be consfusing if you don't already know that all tablespaces are LMT if SYSTEM is :o)

-----Original Message-----
From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk] Posted At: Monday, June 17, 2002 9:22 AM Posted To: server
Conversation: autoextend size vs. extent size in LMT Subject: Re: (LONG POST) autoextend size vs. extent size in LMT

Norman

I'd expect that one of the system processes (smon?) would be the session that issued 'ALTER DATABASE DATAFILE RESIZE....' in the event of autoextend
perhaps you were only tracing your session. Howards point about the resize
being recorded in the alert.log is well taken, unfortunately this seems to
have disappeared in 9.2. NB I have left in the new syntax for datafile creation that fooled me first of all as I thought others might learn from
it. Received on Mon Jun 17 2002 - 07:26:55 CDT