Re: OracleClient and OCI.dll
From: Roy Fine (rlfine_at_twt.obfuscate.net)
Date: 10/19/04
- Next message: Mervin Williams: "Select datagrid rows with key-up and key-down?"
- Previous message: Sushil Chordia: "Re: Batched Update in .NET 2.0"
- In reply to: Sahil Malik: "Re: OracleClient and OCI.dll"
- Next in thread: Sahil Malik: "Re: OracleClient and OCI.dll"
- Reply: Sahil Malik: "Re: OracleClient and OCI.dll"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 14:47:45 -0400
"Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message
news:OMxXVqetEHA.2808@TK2MSFTNGP14.phx.gbl...
> I agree with that. ASPNET should not be given admin rights, that's
suicide.
> I personally don't like giving ASPNET access to even the ORACLE_HOME
> directory, but I don't like oracle in the first place ( See ..
> http://dotnetjunkies.com/WebLog/sahilmalik/archive/2004/08/28/23563.aspx )
>
> - Sahil Malik
> You can reach me thru my blog at
> http://www.dotnetjunkies.com/weblog/sahilmalik
>
>
Your Oracle Sucks article has some serious shortcomings.
The number of CD's in the installation is not relevant to "bloat" - it is a
function of compression and features, etc. There is a lot of stuff on the
three Oracle CDs that is not on the SqlServer CD - so your comparisons are
flawed.
Your item B is flawed as well - when SqlServer starts (by default) it
consumes all available real memory. Oracle consumes a fixed amount
(established by max_sga_size init parameter) and variable amount determined
by the client process (or server instance) and whether or not you are
running dedicated or shared server. You are wrong to state that Oracle
memory usage goes up exponentially - the statement is wrong and using such
removes your works from the realm of objectivity.
Oracle and SqlServer implemented two very different scenarios - before one
can judge the merits of one vis-a-vis another, one must have a comparable
understanding of each. SqlServer requires much less knowledge to get it up
and running - that is a design consideration, and on that account, it does
pretty good at it. Oracle strives to run on many platforms, and focuses on
performance, security and stability, and on those accounts, it's pretty good
at it.
Item C - point well taken - but remember - Oracle runs on MANY platforms,
and it does a pretty good job of providing a consistent interface across
those platforms. Microsoft SqlServer runs on one platform, and it does a
pretty good job of providing a consistent interface vis-a-vis other
applications on that same/singular platform. Oracle is not good at looking
like SqlServer, but it gets no bad marks in that regard, because that was
never an advertised capability.
Item D - good point.
Item E - another good point - the registry has been forever tattooed
With respect to Larry Ellison's feeling towards Bill Gates, I have no
information - but I suspect yours is only an opinion, not something that can
be substantiated. However, the success of Oracle is based on the quality of
the product, not on the mindset of those that are using it. For high-end
systems, SqlServer does not measure up. That is not necessarily a fault of
the product, at least not directly, but rather the limitation of the
platform. The high end dual and quad processor Xeon machines running
Windows server O/S pale in comparison to multiprocessor RISC based hardware
with large physical memory capacity and high bandwidth I/O subsystems
(memory and storage)
Oracle is quite a bit more difficult to administer - and I suspect that such
is at the root of many of your dislikes with the product. You would serve
yourself and those that lend their ears to take the time to learn the
product, then proffer an objective comparison.
regards
roy
>
> "Roy Fine" <rlfine@twt.obfuscate.net> wrote in message
> news:OSvfe6ctEHA.1048@tk2msftngp13.phx.gbl...
> >
> > "Vinesh Mamania" <Vinesh Mamania@discussions.microsoft.com> wrote in
> message
> > news:36B441A1-2BEF-4E73-A724-F81AB4E4A1E5@microsoft.com...
> > > Hi james,
> > > your asp.net user account needs enough permission to execute the code.
> > > Try giving your asp.net user account administrator access rights
> > >
> > > Go to --> Local Users and Groups --> Users --> ASPNET (right click &
> > > properties) --> Member of --> Add --> Administrator. --> Add --> Ok
> > >
> >
> > ABSOLUTELY NOT -- unnecessarily promoting an account to a member of the
> > administrator group is a most serious bad-practice with respect to
> security.
> >
> > A better approach would be to find the value of ORACLE_HOME (look at the
> > value of the ORACLE_HOME key in the registry
> > HKEY_LOCAL_MACHINE\Software\Oracle) and give the ASPNET account read and
> > execute access to that path.
> >
> > regards
> > roy fine
> >
> >
>
>
- Next message: Mervin Williams: "Select datagrid rows with key-up and key-down?"
- Previous message: Sushil Chordia: "Re: Batched Update in .NET 2.0"
- In reply to: Sahil Malik: "Re: OracleClient and OCI.dll"
- Next in thread: Sahil Malik: "Re: OracleClient and OCI.dll"
- Reply: Sahil Malik: "Re: OracleClient and OCI.dll"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
