-
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?
-
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
Ok, what you are talking about too! Since when Oracle add datafiles by itself?!
When we talk about auto-extend we mean datafiles not tablespaces!
-
pando,
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....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|