RE: asm & smallfile limitation

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 29 Oct 2007 17:04:08 -0400

 
Did you verify that the OS file system is not full?

-- Mark D Powell -- 
Phone (313) 592-5148 

 


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roman Podshivalov
        Sent: Monday, October 29, 2007 10:42 AM
        To: ujang.jaenudin@xxxxxxxxx
        Cc: oracle-l@xxxxxxxxxxxxx
        Subject: Re: asm & smallfile limitation
        
        
        Hi, 
         
        Note:336186.1
         
Database file size       Maximum         Operating system dependent.
Limited by maximum operating system file size; typically 222 or 4 MB
blocks  

        --romas
         
        On 10/28/07, Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx> wrote: 

                all,
                
                I have this machine:
                solaris 10
                oracle 10.2.0.3 <http://10.2.0.3/>  rac 2 nodes
                asm
                
                a smallfile tablespace with 5 datafiles, each 32GB.
                
                but when datafiles rech 20GB, oracle complaint that
unable to extent on that tablespace.... 
                does anyone have the experience? or have metalink note? 
                
                -- 
                regards
                ujang 


Other related posts: