We would like to change the PREFETCHSIZE on our default TEMP tablespace. Can this be done on the fly or only when you create the tablespace?
What we have seen in studies on the Internet, it is recommended to have multi containers on different drives. This sound like it should be defined as DMS.
Since ours is defined as SMS and on a RAID device consisting of three drives, is there any reason to recreate it?
What we have seen in studies on the Internet, it is recommended to have multi containers on different drives. This sound like it should be defined as DMS.
Since ours is defined as SMS and on a RAID device consisting of three drives, is there any reason to recreate it?