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.