Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
Filesystems 2007

Filesystems 2007

2007-03-22       - By Michael Taylor

 Back
Reply:     1     2     3     4  

I see on the following Metalink Note 414673.1 that both ext3 and XFS are Suse
provided filesystems that support both Asynch and Direct I/O on SLES-9 (See http://LES-9.ora-code.com) and SLES
-10 on 10g databases.

I recently lost a resierFS filesystem to reiserfsck --rebuild-tree when tons of
reiser kernel cannot stat errors started showing up in /var/log/messages.  A
colleague of mine had the same thing happen to him recently and said he did
warn me about reiserFS.  I used the manufacturer's CD to run a low level
diagnostics of the drive, and there were no bad sectors or any other problems
found.

I am looking for a stable, high performance filesystem for hosting 10g Oracle
Applications databases, but may also host the Applications tiers which consist
nearly 1 million files per instance.

Are there formatting options that people use when creating ext3 or XFS
filesystems for Oracle that seem to improve performance?  In my testing using
the default formatting options comparing ext3 and reiserFS filesystems
belonging to the same LVM groups, read speeds were comparable, but reiserFS was
2x faster on writes in Iozone benchmarking.  Most write intensive ERP jobs took
longer on ext3 as well.  Online LVM resize was pretty cool as well.

I have come down from my ReiserFS soap box since the filesystem has gone into
maintenance mode and I was burned last week.  I am just wondering what the
community's comments on this topic would be with reiserFS out of the picture.

Thanks,
Michael




 
-- ---- ---- ---- ---- ---- -----
Looking for earth-friendly autos?
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.