FileSystem (Volume) Sizes and Names (questions)

A quick survey.

When you, as the DBA, are allowed to specify to the Storage team the filesystem (volume)
sizes you want for Databases, what standards do you use ? eg for a database of less than 100GB, volumes of 10GB to 20GB each for a database of 100GB to 1TB, volumes of 100GB or 200GB each ....

If the Storage team set's up default volumes [without referring to you] what sizes do they
give you ?

I would like "smaller" volumes [eg each mount point between 10% to 20% of the total size,
thus 5 to 10 mount points] for the database files [of course, still using some standard
sizes, eg 20GB [for the 100GB databases] across servers. This allows flexibility
in relocating datafiles etc.

If the underlying storage actually creates one large Mega-LUN, do you still care
about the sizes of the mount points.

As an additional question, do you standardize mount-point names ? eg /orasys for the RDBMS binaries
/oradata1 ... /oradata10 for the database files
/redo for the Redo Logs
/archlogs for the ArchiveLogs

etc

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l