Re: Guide for Oracle 10g installation on Solaris 10 GA?

From: HansF (News.Hans_at_telus.net)
Date: 04/05/05 

Date: Tue, 05 Apr 2005 06:22:22 GMT

On Mon, 04 Apr 2005 21:49:35 -0700, madhu interested us by writing:

> Solaris 10 kernel tuning docs mentioned that these above entries are
> not needed for Solaris 10 as those are allocated dynamically using
> rcladm.

My guess ...

Yes, Solaris 10 allocates on demand, probably in response to a system
call. However Oracle presumes that it has already been allocated and tries
to use it - it ain't been allocated when Oracle wants it and so you have a
race.

I suspect this will be an ongoing problem that tracks Oracle history:
Ever notice that you need to pre-allocate the tablespace (or grow it in
pre-defined chunks), even though a lot of other RDBMSs grow on demand?
Oracle likes to have things presized so there are no (or minimal) delays
to accomodate expansion. 

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Relevant Pages

  • Re: Guide for Oracle 10g installation on Solaris 10 GA?
    ... Yes, Solaris 10 allocates on demand, probably in response to a system ... However Oracle presumes that it has already been allocated and tries ... even though a lot of other RDBMSs grow on demand? ...
    (comp.unix.solaris)
  • (SUMMARY) Filesystem --- "ls -l" total reporting incorrect file sizes - ADVFS
    ... that our version of oracle allocates space in it's temp files. ... Thomas" provided this nugget of knowledge from the Oracle ... space for a tempfile not allocated in the filesystem ... so the log is marked as empty. ...
    (Tru64-UNIX-Managers)
  • Re: DLPAR and Memory
    ... It appears that in the default oracle settings with 9i, it allocates ... the maximum real memory it finds for SGA... ... eventually bringing the server to it's knees. ...
    (comp.unix.aix)
  • Re: About Log File System
    ... I mean is any API available to tell ... How a log file created, How a block size allocated for log? ... Is any concept of allocates sector-aligned space in Solaris? ...
    (comp.unix.programmer)
  • About Log File System
    ... I mean is any API available to tell ... How a log file created, How a block size allocated for log? ... Is any concept of allocates sector-aligned space in Solaris? ...
    (comp.unix.programmer)