RE: asm & smallfile limitation

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 29 Oct 2007 17:04:08 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A901889C80@usahm208.amer.corp.eds.com>

 

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

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

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roman Podshivalov

	Sent: Monday, October 29, 2007 10:42 AM
	To: ujang.jaenudin_at_gmail.com
	Cc: oracle-l_at_freelists.org
	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_at_gmail.com> 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 

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 29 2007 - 16:04:08 CDT