Manual Segment Management - Learning Question
604259Oct 1 2009 — edited Oct 1 2009I'm currently trying to learn as much as I can and am still new at it. Does anyone know of a good book or link that talks about manual segment management? Most of what I have found is a very short blurb that doesn't really discuss specifics. I would like to know what tasks a dba needs to regularly do when a tablespace is set up as manual.
I feel pretty confused and have a specific question*. Sorry if it is a dumb question... I know a lot of you don't like questions that you feel are beneath you. If you don't like the question, please just ignore it and don't gripe me out.
If the datafile is set to autoextend and the segment management is manual and the extent management is local is there any specific task a dba needs to perform for autoextend to work? ( I guess the mixing of manual and auto terms is kind of confusing me) In this specific instance I am most interested in the system tablespace specifically (the dev box I'm learning on is setup that way).
thanks in advance to those with patience to answer someone who is learning,
Cara