| Computers Forum Index » Computer - Databases - Oracle (Server) » [Questionary survey]How many people are using ASM?... |
|
Page 1 of 1 |
|
| Author |
Message |
| Jia Lu... |
 Posted: Thu Sep 24, 2009 1:19 pm |
|
|
|
Guest
|
Hi all
In out country there is a questionary survey result says 70% are using
OS's file system or other volume manager like LVM.
I wonder what storage manager does everyone use worldwide with Oracle
productive database system.
Q. What are you using with Oracle database?
A: ASM
B: File System
C: Other storage manager: ( Write here )
Thanks. |
|
|
| Back to top |
|
|
|
| Mladen Gogala... |
| Posted: Thu Sep 24, 2009 5:51 pm |
|
|
|
Guest
|
On Thu, 24 Sep 2009 06:19:52 -0700, Jia Lu wrote:
Quote: Hi all
In out country there is a questionary survey result says 70% are using
OS's file system or other volume manager like LVM.
I wonder what storage manager does everyone use worldwide with Oracle
productive database system.
Q. What are you using with Oracle database?
A: ASM
B: File System
C: Other storage manager: ( Write here )
Thanks.
The company that I work for uses both ASM and file system. There are
several databases and ASM is used on the 3 RAC configurations while the
file system is used on non-RAC configurations. The file system is Ext3.
Versions are ranging from 10.2.0.3 to 11.2.0.1, the latter being a test
database.
--
http://mgogala.freehostia.com |
|
|
| Back to top |
|
|
|
| gazzag... |
| Posted: Fri Sep 25, 2009 11:46 am |
|
|
|
Guest
|
On 25 Sep, 12:06, Noons <wizofo... at (no spam) yahoo.com.au> wrote:
Quote: File system. Mostly because we do not use Linux and it'd be a brave person who
would use ASM in anything other.
Sadly, I'm in a Windows environment. Currently we use the file system
with our databases but are considering using ASM for our new 11g
databases.
Is this something you'd recommend against, Noons?
Cheers,
Gareth |
|
|
| Back to top |
|
|
|
| stevedhoward at (no spam) gmail.com... |
| Posted: Fri Sep 25, 2009 2:21 pm |
|
|
|
Guest
|
On Sep 24, 9:19 am, Jia Lu <roka... at (no spam) gmail.com> wrote:
Quote: Q. What are you using with Oracle database?
A: ASM
B: File System
C: Other storage manager: ( Write here )
Thanks.
ASM |
|
|
| Back to top |
|
|
|
| Noons... |
| Posted: Fri Sep 25, 2009 3:06 pm |
|
|
|
Guest
|
Jia Lu wrote,on my timestamp of 24/09/2009 11:19 PM:
Quote:
Q. What are you using with Oracle database?
A: ASM
B: File System
C: Other storage manager: ( Write here )
File system. Mostly because we do not use Linux and it'd be a brave person who
would use ASM in anything other. |
|
|
| Back to top |
|
|
|
| gazzag... |
| Posted: Fri Sep 25, 2009 3:58 pm |
|
|
|
Guest
|
On 25 Sep, 15:21, "stevedhow... at (no spam) gmail.com" <stevedhow... at (no spam) gmail.com>
wrote:
Steve,
As a matter of interest, what O/S?
Cheers,
Gareth |
|
|
| Back to top |
|
|
|
| Noons... |
| Posted: Fri Sep 25, 2009 5:36 pm |
|
|
|
Guest
|
gazzag wrote,on my timestamp of 25/09/2009 9:46 PM:
Quote: Sadly, I'm in a Windows environment. Currently we use the file system
with our databases but are considering using ASM for our new 11g
databases.
Is this something you'd recommend against, Noons?
Don't know. Haven't yet touched 11g in Windows, can't say how stable it is.
With 10g, I'd think long and hard about using ASM in that environment: the list
of bug reports and fixes is quite extensive on anything outside Linux.
Call me weird but I get very nervous when bugs fixed in 10.2.0.3 and .4 include
expressions like "inaccessible device", "data loss", "crash" and other such.
It doesn't mean it can't be done. Just requires careful wading through lists of
bug fixes in the chosen OS for the latest release, then investigation if there
are backports of patches. Unfortunately we have to do this: Oracle doesn't.
However like I said: that's with 10g. 11g might well be a more stable beast.
Or so I'm told. |
|
|
| Back to top |
|
|
|
| John Hurley... |
| Posted: Fri Sep 25, 2009 5:42 pm |
|
|
|
Guest
|
On Sep 24, 9:19 am, Jia Lu <roka... at (no spam) gmail.com> wrote:
snip
Quote: Hi all
In out country there is a questionary survey result says 70% are using
OS's file system or other volume manager like LVM.
I wonder what storage manager does everyone use worldwide with Oracle
productive database system.
Q. What are you using with Oracle database?
A: ASM
B: File System
C: Other storage manager: ( Write here )
Using ASM on 11.1.0.7 OEL linux. |
|
|
| Back to top |
|
|
|
| Arne Ortlinghaus... |
| Posted: Mon Oct 19, 2009 11:37 am |
|
|
|
Guest
|
We do not want to use ASM because it is an additional overhead. We have
mixed big and small databases for the same applications on Windows servers.
We have made our utility program for adding tablespaces etc so most of the
installations are very similar.
Arne Ortlinghaus
ACS Data Systems |
|
|
| Back to top |
|
|
|
|
