![Avatar of Alex [***Alex140181***]](https://filedb.experts-exchange.com/files/public/2022/11/13/8257e912-ee3c-4a93-9df0-fe9a8a1515cf.jpeg)
asked on Where to put TEMP and UNDO tablespace/datafiles for an Oracle database?
We're running Oracle Standard Edition 2 18c on a Windows Server 2016. The datafiles are stored in a attached SAN. Due to some recent events it came to my mind, if we might move the TEMP and maybe UNDO datafiles from the SAN to the server itself?!
Actually I'd like to hear your POVs and experiences and maybe best practices, if possible. Thanks in advance!
Oracle DatabaseDatabasesWindows OS
Last Comment
slightwv (䄆 Netminder)
ASKER
I suppose a lot depends on the problem you are trying to fix?It's more a general question on where to put TEMP (and maybe UNDO) files. On our production server, we have some space directly attached to the server (-> local drives), so I thought, it would be "nice" to move those temporary files from SAN to local storage. Or maybe having 2/3 of TEMP and UNDO on local drives and 1/3 on SAN?!
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
It's a quite fast SAN (SSD compound, as far as I know), so yeah, it would be marginal... But considering the space consumption, I think it would be "better" to have some more space for "real data" on the SAN and move a larger part of TEMP and UNDO to local disks....
I would HOPE whomever spec'd out the SAN did so with quite a few years of growth in mind and that a few TEMP/UNDO tablespaces wouldn't dent available space.
ASKER
Thank you very much for your input ;-)
Happy to help.
Happier to help another Expert!
Happier to help another Expert!
On our 4-Node RAC clusters and few stand-alone databases, we have everything on the corporate SAN. The servers themselves were individual blades and really had no attached disk storage.
They work fine for us.