Originally posted by vishal sood
Though it is(Autoextend) very useful feature but what I mean to say is, if we use Autoextend option the Oracle will itself extend the size of datafile after reaching MAXEXTENTS. If someone(lazy DBA) never checks the used/free space related things then one day he may find that the datafile has been ocupied/extended up to the whole avaialble space.
Errr what amxextents you are talking about...? There is no such thing called maxextents at tablespace level!
You set extent limit for segments, maxsize for datafile... what´s wrong?
Ok, what you are talking about too! Since when Oracle add datafiles by itself?!
Originally posted by ngwh
ohh..u mean if auto-extend is ON .. for version 7.3.4 onwards ORACLE itself will create a new datafile once file size limit has been reached? interesting...hee
When we talk about auto-extend we mean datafiles not tablespaces!
what i meant is even with auto-extend on..if lazy DBA doesn't chk the OS filesize...u'll still hit problem..which is y auto-extend shld be off and DBA performing constant chk which is preferred as u r in control
And I said there is this parameter called MAXSIZE....
Click Here to Expand Forum to Full Width