Hi,
We're on 12.2 on a VMAX-based SAN, upon which we made our '/dev' devices.
We created only 2 diskgroups: one DATA, and one FRA. DATA diskgroup contains
all our tablespaces, including temporary ones.
In a Dell EMC white paper they recommend to modify striping to fine-grain for
temporary tablespaces files, so we ran:
SQL> alter diskgroup data alter template tempfile attributes (fine);
but I'm wondering if it makes sense... Shouldn't we create a TEMP diskgroup specific to
temporary tablespaces upon which we will make *all* our temp tablespaces, and then run:
SQL> alter diskgroup TEMP alter template tempfile attributes (fine);
^^^^
?? (we did this at the very beginning after Grid infra installation, before any DB creation)
Or is it enough for Oracle to alter generic DATA dg and modify TEMPFILE template only ?
Will Oracle modify stripes of temporary files *only* inside DATA diskgroup ? I found no
documentation where playing like this with template attributes is relevant or not...
Thanks a lot.
Regards,
Seb