appd_tru.htm

Debian中文参考手册,系统介绍了Debian系统

<div class="sect1">
<!--
infolevel=all
infotype=general
--><a id="sthref728" name="sthref728"></a>
<h2>
<font face="arial, helvetica, sans-serif" color="#330099">Enabling Access to the <a id="sthref729" name="sthref729"></a>Real Time Clock
</font>
</h2>
<p>Many Oracle processes are timed, especially if the <a id="sthref730" name="sthref730"></a><a id="sthref731" name="sthref731"></a>TIMED&#095;STATISTICS initialization parameter is set to TRUE. These timing functions call the Tru64 kernel and can affect Oracle9<em>i</em> performance. On Tru64, you can improve performance on heavily loaded systems by enabling processes to directly access the real time clock.
</p>
<p>To enable access to the real time clock:
</p>
<ol type="1" start="1">
<li>
<p>Log in as <code>root.</code> 
</p>
</li>
<li>
<p>Enter the following commands:
</p>
<pre>&#035; mknod &#047;dev&#047;timedev c 15 0 
&#035; chmod &#043;r &#047;dev&#047;timedev

</pre>
<p>If your system is a cluster running Tru64 UNIX V5.1 or higher, enter these commands on each cluster. If your system is a cluster running an earlier version of Tru64, enter the commands on each node. 
</p>
<br /><table summary="This is a layout table to format a note" title="This is a layout table to format a note" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>Note:</strong>
</font>
</p>The special file <code>&#047;dev&#047;timedev</code> remains on the system after rebooting.
</td>
</tr></tbody>
</table><br />
</li>
<li>
<p>Restart the Oracle9<em>i</em> instance.
</p>
<p>The system checks for the existence of the <code>&#047;dev&#047;timedev</code> file only on instance startup. 
</p>
</li>
</ol>
<p>Oracle Corporation recommends that you enable this feature on all instances in a cluster, and therefore on all nodes. 
</p>
</div class="sect1"><a id="i631192" name="i631192"></a>
<div class="sect1">
<!--
infolevel=all
infotype=general
--><a id="sthref732" name="sthref732"></a>
<h2>
<font face="arial, helvetica, sans-serif" color="#330099">Setting Up <a id="sthref733" name="sthref733"></a>Raw Devices
</font>
</h2>
<div align="center">
<br /><table summary="This is a layout table to format a note" title="This is a layout table to format a note" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>Caution:</strong>
</font>
</p> Do not attempt to set up raw devices without the help of an experienced system administrator and specific knowledge about the system you are using.
</td>
</tr></tbody>
</table><br />
</div>
<p>To set up raw devices&#047;volumes on Tru64 systems:
</p>
<ol type="1" start="1">
<li>
<p>If you are using Oracle9<em>i</em> Real Application Clusters, make sure that the partitions you are adding are on a shared disk. However, if your platform supports a cluster file system certified by Oracle Corporation, you can store the files that Oracle9<em>i</em> Real Application Clusters requires directly on the cluster file system.
</p>
</li>
<li>
<p>Determine the names of the free disk partitions.
</p>
<p>A free disk partition is one that is not used for a Tru64 file system that complies with the following restrictions:
</p>
<ul>
<li type="disc">
<p>It is not listed when you execute the <code>&#047;usr&#047;sbin&#047;mount</code> command.
</p>
</li>
<li type="disc">
<p>It is not in use as a swap device.
</p>
</li>
<li type="disc">
<p>It does not overlap a swap partition.
</p>
</li>
<li type="disc">
<p>It is not in use by other Tru64 applications (for example, other instances of the Oracle9<em>i</em> server).
</p>
</li>
<li type="disc">
<p>It does not overlap the Tru64 file system.
</p>
</li>
<li type="disc">
<p>It does not use a space already used by the file system.
</p>
</li>
</ul>
<p>To determine whether a partition is free, obtain a complete map of the starting locations and sizes of the partitions on the device and check for free space. Some partitions may contain file systems that are currently not mounted and are not listed in the <code>&#047;usr&#047;sbin&#047;mount</code> output.
</p>
<br /><table summary="This is a layout table to format a note" title="This is a layout table to format a note" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>Note:</strong>
</font>
</p> Make sure that the partition does <em>not</em> start at cylinder 0.
</td>
</tr></tbody>
</table><br />
</li>
<li>
<p>Set up the raw device for use by the Oracle9<em>i</em> Server.
</p>
<p>Begin by verifying that the disk is partitioned. If it is not, use the <code>disklabel</code> command to partition it.
</p>
</li>
<li>
<p>Enter the <code>ls</code> command to view the owner and permissions of the device file. For example:
</p>
<pre>&#036; ls -1a

</pre>
</li>
<li>
<p>Make sure that the partition is owned by the Oracle software owner. If necessary, use the <code>chown</code> command to change the ownership on the block and character files for the device. For example:
</p>
<pre>&#035; chown oracle &#047;dev&#047;rdisk&#047;dsk10c

</pre>
</li>
<li>
<p>Make sure that the partition has the correct permissions. If necessary, use the <code>chmod</code> command to make the partition accessible to only the Oracle software owner. For example:
</p>
<pre>&#035; chmod 600 &#047;dev&#047;rdisk&#047;dsk10c

</pre>
</li>
<li>
<p>Create a symbolic link to the raw devices you require. For example:
</p>
<pre>&#036; ln -s &#047;dev&#047;rdisk&#047;dsk10c &#047;oracle&#095;data&#047;datafile.dbf

</pre>
<p>To verify that you have created the symbolic link, use the character special device (not the block special device) and enter the following command:
</p>
<pre>&#036; ls -Ll <em>datafile</em>

</pre>
<p>The following message should appear:
</p>
<pre>crwxrwxrwx oracle dba <em>datafile</em>

</pre>
<br /><table summary="This is a layout table to format a note" title="This is a layout table to format a note" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>Caution:</strong>
</font>
</p> This symbolic link must be set up on each node of the cluster. Check that no two symbolic links specify the same raw device.
</td>
</tr></tbody>
</table><br />
</li>
<li>
<p>Create or add the new partition to a new database.
</p>
<p>To create a new partition, from SQL&#042;Plus enter the following SQL command:
</p>
<br /><table summary="This is a layout table to format a note" title="This is a layout table to format a note" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>Note:</strong>
</font>
</p> The size of an Oracle datafile created in a raw partition must be at least 64 KB plus one Oracle block size smaller than the size of the raw partition.
</td>
</tr></tbody>
</table><br />
<pre>SQL&gt; CREATE DATABASE <em>sid</em>
  2  LOGFILE &#039;&#047;oracle&#095;data&#047;log1.dbf&#039; SIZE 100K
  3 &#039;&#047;oracle&#095;data&#047;log2.dbf&#039; SIZE 100K
  3  DATAFILE &#039;&#047;oracle&#095;data&#047;datafile.dbf&#039; SIZE 10000K REUSE;

</pre>
<p>To add a partition to a tablespace in an existing Oracle database, enter:
</p>
<pre>SQL&gt; ALTER TABLESPACE <em>tablespace&#095;name</em> 
  2  ADD DATAFILE &#039;&#047;dev&#047;rdisk&#047;dsk10c&#039; SIZE 10000K REUSE;

</pre>
</li>
</ol>
<p>You can use the same procedure to set up a raw device for the redo log files.
</p>
</div class="sect1"><a id="i631244" name="i631244"></a>
<div class="sect1">
<!--
infolevel=all
infotype=general
--><a id="sthref734" name="sthref734"></a>
<h2>
<font face="arial, helvetica, sans-serif" color="#330099"><a id="sthref735" name="sthref735"></a>Spike Optimization Tool
</font>
</h2>
<p>The Spike optimization tool (Spike) is a performance optimization tool that increases the performance of a Tru64 binary. In a testing environment, Spike, with feedback, increased the performance of the Oracle9<em>i</em> server by up to 23 percent on an OLTP workload. 
</p>
<p>For information on Spike, see the Tru64 documentation or enter one of the following commands:
</p>
<ul>
<li type="disc">
<p><code>man spike</code>
</p>
</li>
<li type="disc">
<p><code>spike</code>
</p>
</li>
</ul>
<p>Oracle9<em>i</em> requires Spike version V5.1 (1.2.2.31.2.4 ADK) Feb 22 2001 or later.
</p>
<div align="center">
<br /><table summary="This is a layout table to format a note" title="This is a layout table to format a note" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>Note:</strong>
</font>
</p> If you have a version of Spike earlier than V5.1 (1.2.2.31.2.4 ADK) Feb 22 2001, contact Compaq for a patchkit.
</td>
</tr></tbody>
</table><br />
</div>
<p>Enter the following command to check the version of Spike:
</p>
<pre>&#036; spike -V

</pre>
<p>You can download the latest version of Spike from the Compaq Web site.
</p>
<div align="center">