Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alter or Move System TEMP tablespace

Status
Not open for further replies.

kozlow

MIS
Mar 3, 2003
326
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top