易截截图软件、单文件、免安装、纯绿色、仅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性能提高 批量绑定

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

Oracle Data Gurad Physical Standby 相关说明


Oracle Data Guard, 分逻辑Standby和物理Standby。 下面讲的是物理Standby 环境的搭建步骤。 有关Data Guard的一些概念性的理论知识,请参考我的blog, 这里不做过多的说明。
Oracle Data Gurad 理论知识
http://blog.csdn.net/tianlesoftware/archive/2010/04 ......

oracle在linux下怎么安装

red hat linux 下安装 oracle 10g
racle考资料:
Oracle官方网站: http://download.oracle.com/docs/html/B10813_01/toc.htm
一、以root用户登录, 进行如下操作:
1 检查硬件要求
* 主要包括:
********************************************************************
* 内存:      & ......

Oracle存储过程

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

用PowerDesingner把oracle中的表导成er图

通过windows数据源管理,建立ODBC数据源。
我的是基于oracle10g。
 
打开Windows的控制面板
打开管理工具
 
打开数据源(ODBC)
 
选择你要操作的数据库类型
               1.我选择的时候报未找到客户端组件和一些客户 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号