sam15
asked on
SegmentsSpaceMgmt.
I have am 11g database with 5 tablespaces and all set to locally managed tablespaces.
I noticed SYSTEM, TEMP and UNDOTBS1 ASSM are set to MANUAL. Is it recommended to set these to AUTO? I have been reading different things about this an that this may improve and may not improve performance depending on the applicatin.
The applications is a reporting analysis COTS package that purges data nighly and loads new data. It runs about 10 hours every night..
I also noticed that SYSTEM is sied at 3.5 GB abd 98% full and does not see to extends until it hits 100%. is this normal? is this filesize small.
I noticed SYSTEM, TEMP and UNDOTBS1 ASSM are set to MANUAL. Is it recommended to set these to AUTO? I have been reading different things about this an that this may improve and may not improve performance depending on the applicatin.
The applications is a reporting analysis COTS package that purges data nighly and loads new data. It runs about 10 hours every night..
I also noticed that SYSTEM is sied at 3.5 GB abd 98% full and does not see to extends until it hits 100%. is this normal? is this filesize small.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I believe it is the default since 10g. I'm not sure about older databases that have been upgraded.
If this has been manually changed it might have been for a reason.
Check the docs and online papers that talk about this topic and determine if locally managed makes sense for your database. Every database is different.
For me, I love locally managed. I can't suggest what works for you.
If this has been manually changed it might have been for a reason.
Check the docs and online papers that talk about this topic and determine if locally managed makes sense for your database. Every database is different.
For me, I love locally managed. I can't suggest what works for you.
ASKER
from what i read dictionary managed tbalespaces is the old stuff and getting phased out.
everything should be locally manged now.
but locally managed tablespace is for extents and we already have that setting.
i was asking about "Segment Space management" for segments. it is different feature.
everything should be locally manged now.
but locally managed tablespace is for extents and we already have that setting.
i was asking about "Segment Space management" for segments. it is different feature.
ASKER
I think oracle recommends that too for locally managed spaces.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm
is it recommended for data warehouse kind of database that get bulk loads at night.