📄 oracle inside out - linux vs windows.htm
字号:
Specific RDBMS Functionality</FONT></B></P>
<P class=MsoNormal align=center> </P>
<P class=MsoNormal align=left><FONT face=Arial size=2>As you can see from
the graph above, Oracle RDBMS operations tested on Linux performed
anywhere between 13%-75% better than they did with an identical Oracle
configuration, running under Windows 2000 Server. When all operations were
averaged together, Linux showed a general performance advantage of 38.4%
over Windows.</FONT></P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left><SPAN style="FONT-SIZE: 14pt"><B><SPAN
style="FONT-FAMILY: Garamond">The Administration
Comparison</SPAN></B></SPAN></P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left><FONT face=Arial size=2>The task of overall
database administration was also compared by examining the simplicity and
platform consistency in creating and maintaining one or more Oracle
database instances in the two operating system environments compared to
how these operations are performed today on other mainstream Oracle
environments, Sun Solaris and HP-UX.</FONT></P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left><FONT face=Arial size=2>The following table
illustrates the Pros and Cons identified during the examination of the two
operating platforms:</FONT></P>
<P class=MsoNormal align=left> </P>
<TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse"
borderColor=#111111 height=39 cellSpacing=0 cellPadding=0 width="100%"
border=1>
<TBODY>
<TR>
<TD align=middle width="33%" bgColor=#000000 height=19><FONT
face=Arial color=#ffffff size=2><B>Task</B></FONT></TD>
<TD align=middle width="33%" bgColor=#000000 height=19><FONT
face=Arial color=#ffffff size=2><B>Selected Platform</B></FONT></TD>
<TD align=middle width="34%" bgColor=#000000 height=19><FONT
face=Arial color=#ffffff size=2><B>Comments</B></FONT></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>Automated Instance
Startup and Shutdown (Consistency)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>Linux</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>dbstart, dbshut,
oratab use similar to Solaris and HP-UX</FONT></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>Automated Instance
Startup and Shutdown (Simplicity)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>Windows</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>Service and
Registry is configured via GUIs to control automatic instance start
up and shut down</FONT></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>Command-Line
Utilities (Consistency, Simplicity)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>None</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>Unlike other
Oracle releases, 9i has consistent names for most command-line
utilities in Windows and Linux.</FONT></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>Initial OS Prep
for Database Creation (Consistency)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>Linux</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>Procedurally the
kernel reconfiguration is slightly different, but the parameters
modified and the steps necessary to prep the environment are
identical to HP-UX and Solaris.</FONT></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>Initial OS Prep
for Database Creation (Simplicity)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>Windows</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>No kernel
reconfiguration or relink required.</FONT></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>Instance Creation
(Consistency, Simplicity)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>Linux</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>Windows requires a
extra step in database creation (and deletion). A Windows Service
must be created and maintained via the <I>oradim </I>utility for
each database instance on the server.</FONT></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>GUI Utilities
(Consistency, Simplicity)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>None</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>Identical GUIs.
"Remote execution" of server-based GUI tools equally troublesome on
Windows and Linux.</FONT></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>OFA-like
Implementation and Support</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>Linux</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>Windows has no
support for symbolic links or nested mount points, making OFA
implementations on Windows difficult, at best.</FONT></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>Operating System
Administration (Consistency)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>Linux</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>Not always
identical, but certainly closer in heritage to what one would expect
in HP-UX and Solaris</FONT></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>Operating System
Administration (Simplicity)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>Windows</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>Windows has more
GUI-enabled administrative features than Linux.</FONT></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>Scripting
(Consistency, Simplicity)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>Linux</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>Scripting options
are more robust on the Linux platform and more closely resemble
those found on Solaris and HP-UX. </FONT>
<P><FONT face=Arial size=2>Although third-party implementations of
KSH are available for Windows, many of them are extremely unstable
and exhibit different behaviors compared to their Unix
siblings.</FONT></P>
<P><FONT face=Arial size=2>Environment variable names are also more
consistent on Linux than on Windows. (e.g. $TWO_TASK on Windows is
called %LOCAL%, etc.)</FONT></P></TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>Support for
multiple instances within the same Oracle Home (Consistency,
Simplicity)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>None</FONT></TD>
<TD width="34%" height=19> </TD></TR>
<TR>
<TD width="33%" height=19><FONT face=Arial size=2>Support for
multiple instances with different Oracle Homes (Consistency,
Simplicity)</FONT></TD>
<TD align=middle width="33%" height=19><FONT face=Arial
size=2>Linux</FONT></TD>
<TD width="34%" height=19><FONT face=Arial size=2>Windows requires
multiple registry entries for each Oracle Home. Depending on the
Oracle version, the registry tree structure for a given home can be
very different. <BR><BR>Switching homes "gracefully" occurs by
running a GUI based switcher. </FONT>
<P><FONT face=Arial size=2>Windows will also use a dynamic home
assignment that is formulated when an executable from a particular
$ORACLE_HOME is created.</FONT></P>
<P> </P></TD></TR></TBODY></TABLE>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left><SPAN style="FONT-SIZE: 14pt"><B><SPAN
style="FONT-FAMILY: Garamond"><BR> </SPAN></B></SPAN></P>
<P class=MsoNormal align=left><SPAN style="FONT-SIZE: 14pt"><B><SPAN
style="FONT-FAMILY: Garamond">Comparing Stability</SPAN></B></SPAN></P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left><FONT face=Arial size=2>Neither Windows 2000
Server nor RedHat Linux 7.2 demonstrated any notable operating
system-specific problems for the Oracle RDBMS environments tested in terms
of stability; There were no operating-specific ORA-600 internal errors,
fatal instance crashes, etc. during its various testing
operations.</FONT></P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left><SPAN style="FONT-SIZE: 14pt"><B><SPAN
style="FONT-FAMILY: Garamond">Conclusions and
Recommendations</SPAN></B></SPAN></P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left><FONT face=Arial size=2>From perspective of
performance, RedHat Linux 7.2 demonstrated an average performance
advantage of 38.4% higher RDBMS throughput than a similarly configured
Windows 2000 Server in a variety of operational scenarios. </FONT></P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left><FONT face=Arial size=2>Neither operating
system introduced any strange RDBMS operating anomalies, unexplained
errors, or crashes during testing. This demonstrated that either platform
was well-suited to support a stable Oracle Instance, operating in a
variety of conditions.</FONT></P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left><FONT face=Arial size=2>In terms of overall
configuration and administration, Windows 2000 Server demonstrated that it
could be easier from an overall point-and-click GUI perspective. It was
lacking, however, in the ability to support multiple, dissimilar Oracle
homes which is critical in order to support even a minimal degree of
database stacking. </FONT></P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left><FONT face=Arial size=2>Another point of
contention was Window's lack of consistency between many database
administrative functions (automated startup, shutdown, service creation,
scripting, etc.) compared to what DBAs are already used to in many
mainstream UNIX environments (Solaris and HP-UX).</FONT></P>
<P class=MsoNormal align=left> </P>
<P class=MsoNormal align=left><FONT face=Arial size=2>RedHat Linux 7.2 is
highly recommended for use in non-OPS/RAC Oracle RDBMS installations
operating on Pentium-based servers. Windows 2000 Server on Intel-based
machines may be used for Oracle databases in environments where there are
no current or foreseeable scalability requirements, under the rare
circumstance where a windows-based service is required to operate on the
same server as the RDBMS itself, or other specific case-by-case
situations.</FONT></P>
<P> </P></CENTER></TD></TR></TBODY></TABLE></CENTER></DIV><IMG
src="Oracle Inside Out - Linux vs Windows.files/count.xbm"> </BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -