mercredi 4 mars 2015

How to find out the maximum number of datafiles per tablespace in Oracle?


According to this Oracle document, the maximum number of database files per tablespace is "Operating system dependent; usually 1022".


I know there are queries for some of the other limits mentioned in that document (e.g. to determine the database block size: select value from v$parameter where name='db_block_size').


Is there a query to determine the maximum number of datafiles per tablespace? (I tried select name from v$parameter where value='1022' but that returned no rows.)





Aucun commentaire:

Enregistrer un commentaire