RE: Performance BIGFILE contra SMALLFILE tablespaces

From: Marco Gralike <Marco.Gralike_at_AMIS.nl>
Date: Fri, 18 Jul 2008 11:24:02 +0200
Message-ID: <3FA1E6332C73EB4391F729E4EDB7CED90142EFD6@amisnt30.AMIS.local>


Neither Kevin,  

just a good old fashion EXT3 linux.  

I am interested in the internal "book keeping". I have huge performance problems during my tests with XMLType Binary XML Securefile storage and/or with "COMPRESS HIGH" and I want to figure out if it is problem related to the "BIGFILE" / "SMALLFILE"  

Cheers  

Marco


From: Kevin Closson [mailto:ora_kclosson_at_yahoo.com] Sent: woensdag 16 juli 2008 20:50
To: Marco Gralike; oracle-l_at_freelists.org Subject: Re: Performance BIGFILE contra SMALLFILE tablespaces

Raw partition or CFS?

  • Original Message ---- From: Marco Gralike <Marco.Gralike_at_AMIS.nl> To: oracle-l_at_freelists.org Sent: Tuesday, July 15, 2008 2:32:32 AM Subject: Performance BIGFILE contra SMALLFILE tablespaces

Has anyone any idea if there is a difference in performance between BIGFILE / SMALLFILE tablespaces on a normal harddisk (so no ASM etc)  

Thanks in advance    

Marco

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 18 2008 - 04:24:02 CDT

Original text of this message