| Is ASM worth the trouble? [message #115486] |
Mon, 11 April 2005 20:22  |
EricLaszlo
Messages: 1
Registered: April 2005
|
Junior Member |
|
|
Hi, Folks --
We have a new installation of Oracle 10g Standard on Windows 2000. We are currently migrating the back end of our company's e-learning platform to Oracle (from Access). If we're lucky, a few months from now, we'll have a couple hundred people daily interacting with the database through the e-learning site.
Prior to installing, I read a bunch of Oracle documentation, and everything strongly suggested using ASM (and OMF). There were some initial install problems relating to ASM, and now that I am trying to get all the multiplexing, backup, and recovery straightened out, I'm tempted to blow away the first install and just reinstall without ASM (or OMF). It just seems that these features add a whole level of complexity that may not be worth it for an install that will experience only moderate activity and not generate tons of data.
What do you think?
TIA
Eric
|
|
|
|
| Re: Is ASM worth the trouble? [message #115530 is a reply to message #115486] |
Tue, 12 April 2005 09:05  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
This is inherrently an "it depends" sort of question, and a "different opinions" one as well. But...
How much disk space are we talking about here? How many drives and what are their capacities and speeds?
How about the db itself, number of tables and tablespaces and their sizes?
What are the access conditions, oltp, dss? 300 concurrent users hitting it all day long for mission critical gotta have it yesterday response times or just a normal system that is going to run so much faster and more secure because it is on oracle instead of access in the first place?
How many people are supporting this project on the DB end?
ASM looks really nice, but depending on answers to above, I'd lean towards getting everything else migrated and running without it, then plan on adding it later if the need arises.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
