HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
System Administration
Showing results for 
Search instead for 
Did you mean: 

HPUX in the ORACLE Tablespace size limit

Occasional Advisor

HPUX in the ORACLE Tablespace size limit


    My OS Release:   HP-UX B.11.31 , I have confirmed ORACLE 10g ( of the documents in the file tablespace there are restrictions on the number of files,In the file of the "Operating system dependent", refers to what? I how to query, thanks





Re: HPUX in the ORACLE Tablespace size limit

I would say for a defintiive answer you would need to ask Oracle.

If I was going to guess, it's probably something to do with the maximum number of files any given single process can have open on a certain OS. 1024 is a typical limit on some OS and I would imagine an Oracle process keeps 2 of stdin/stdout/stderr open so that leaves 1022. 

Of course on HP-UX I think it is usually higher - look at the kernel parameters maxfiles/maxfiles_lim. But going above 1022 may hit some other Oracle limits that were set at DB creation, so don't assume you can go higher than 1022 anyway!