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