易截截图软件、单文件、免安装、纯绿色、仅160KB

HOW TO SETUP ORACLE ON A RAW PARTITION

HOW TO SETUP ORACLE ON A RAW PARTITION
What is a Raw device and what is the advantage of having a Raw device?
A Raw device, or a Raw disk partition, is a hardware device that is
supported
by a character device driver.  Raw devices are not buffered by the kernel;
the data is transferred directly between the user's buffers and the device.
This direct transfer makes the I/O operation much faster when compared to
FAT
and NTFS file systems.  So, if you are I/O bound with your system, you may
want to locate your log and datafiles to RAW partitions to gain I/O
performance.
The trade-off of the raw partition choice is restricted configuration
options.  Each RAW partition equates to a single file and is represented by
a
single file which is then represented by a single drive letter.
How to create a RAW partition on Windows NT
............................................................................
.
After the installation of Oracle on FAT or NTFS file systems, but before
creating the tablespaces that belong to datafiles, or putting the Log files
on RAW devices, we have to create the RAW partitions on Windows NT. In order
to do that, follow this procedure:
  1) Go into the "Disk Administrator" in the Administrative Tools.  If you
     already have free space there.  Single click on it.
NOTE:  If you don't have free space, you have to delete one of the
partitions
that you don't need anymore.  To do so, select the drive that you don't want
anymore, then select "Delete", under the "Partition" menu.
  2) Go to "Partition" menu and select "Create" in "Create Primary
Partition"
     screen.  Create the partition equal to the size of the file plus 1M,
     then click on OK.
  3) Do the same thing to create the new unformatted partitions for the
other
     fil


相关文档:

访问oracle数据库

1。web.config ----appSettings--<add key="LimsConnection" value="data source=yzlims;user id=lims;password = lims"/>
2.  c#代码中
using System.Data.OracleClient;     
public DataTable  GetLimsTimeInSpace(string S_SAMPLE_NAME, string S_SAMPLING_P_N,Date ......

oracle性能提高 批量绑定

author:skatetime:2010-05-04
在我们的系统里,大家在写pl/sql时,处理多条记录时,几乎都是通过游标来完成的,这样是非常影响性能的。我们可以用批量绑定可以大大的改善。
 
批量绑定是oracle9i增加的特性,是指执行单次sql操作能传递所有集合元素的数据。通过绑定绑定变量可以极大的提高数据处理速度,提高应用程 ......

ORACLE DSI 介绍

DSI是Data Server
Internals的缩写,是Oracle公司内部用来培训Oracle售后工程师使用的教材.由于某种原因流落江湖,
受到众多Oracle爱好者的追捧, 不过要是功力不到, 阅读反而无益. DSI3是Oracle 8系列的, DSI4是Oracle 9系列的.
这样的文档上通常都印着:Oracle Confidential:For internal Use Only.
DSI301 Advanced S ......

Oracle存储过程

现在的项目比较紧,加上自己也比较懒,实在是“没时间”写啊,呵呵,昨天看到一篇挺好的Oracle存储过程的例子,正好最近要用,转过来大家一起分享一下,谢谢(晨光映霞),原作地址:http://blog.csdn.net/xuyabao/archive/2008/03/20/2200205.aspx。
--------------------自定义函数开始--------------------
......

ORACLE存储过程

现在的项目比较紧,加上自己也比较懒,实在是“没时间”写啊,呵呵,昨天看到一篇挺好的Oracle存储过程的例子,正好最近要用,转过来大家一起分享一下,谢谢(晨光映霞),原作地址:http://blog.csdn.net/xuyabao/archive/2008/03/20/2200205.aspx。
 
--------------------自定义函数开始-------------- ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号