Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: autoextend size vs. extent size in LMT
Morning
Glad to see the firewall's not working!
I agree about the error message which is why I left it in the output.
I must admit I didn't restart everything wth full logging and all the rest of it because The situation just seems so obviously daft as to warrant logical arguments along the lines advanced by Howard rather than the full tkprof monty..
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7023D9456_at_lnewton.leeds.lfs.co.uk...Received on Mon Jun 17 2002 - 08:57:34 CDT
> 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.
>
>