Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Oracle 81.7.2 on HP-UX 11i

Occasional Contributor

Oracle 81.7.2 on HP-UX 11i

Hi guys

Can some body help me with with the following asap?

Is HP-UX 1i one of those operating systems,which not allow Oracle to allocate space
for the tempfile until the tempfile blocks are actually accessed.

As I read in documentation his delay in space allocation results in faster creation and resizing of tempfiles, but it requires that sufficient disk space is available when
the tempfiles are later used. Oracle's advise was to refer to your operating system
documentation to determine whether Oracle allocates tempfile space in this way on your system.

don't know

Re: Oracle 81.7.2 on HP-UX 11i


my experience with all versions of HPUX is that all Oracle datafiles are pre-allocated upon creation... I do not know of any option that would result in bypassing this behavior.
Together we stand divided we fall
Brian Crabtree
Honored Contributor

Re: Oracle 81.7.2 on HP-UX 11i

This is true. The temp files created with the "CREATE TEMPORARY TABLESPACE" command are not pre-allocated. What this means is that as the temp space is being used, it will allocate the blocks from the O/S. This allows for a faster file creation for sort segments.

On the other hand, this means that you can completely fill a filesystem if not paying attention to your file placement, as you can fill up what appears to be "available" space, and a large query can try to allocate more blocks than available on the disk.

I would suggest if you are using them, to create specific directories for the temp files to be kept in, so that normal files are not used with it.
ie: /var/opt/oracle/temp01/ORCL/temp_01.dbf