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

datafileoracletablespaces

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.)

Best Answer

db block size is a database parameter but maximum number of tablespace or datafile is a physical limit and you can not find them in v$parameter view. You can use documentation for that: https://docs.oracle.com/cd/B28359_01/server.111/b28320/limits002.htm#i287915

Related Question