易截截图软件、单文件、免安装、纯绿色、仅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、默认事例:
用户名:scott密码:tiger 主机字符串:本机可以为空
2、启动方法:
运行:sqlplus scott/tiger@lhd
3、SQLPLUS基本命令:
Desc:显示表、视图结构  desc 表名,视图
List:列出SQL缓冲区区中的一行或多行命令语句
Exit:退出
4、常用的数据字典(三种前缀:USER,ALL,DBA)
USER_TABL ......

关于Oracle在AIX平台实施的 培训内容安排

《oracle大型数据库系统在AIX/unix上的实战详解》讨论38    关于Oracle在AIX上实施培训的内容安排   这段时间由于一直忙于项目,也就疏于在日志上和读者的互动,因此又积攒下若干读者来信未回,实在抱歉。其中有几封是关于Oracle在AIX上实施培训的,要求我对培训内容给与解释和说明。这里我做统一说 ......

11g的Oracle Grid Infrastructure

2010年05月2号  | 
23:59分类:Linux&Unix
, 管理维护
  |  编辑
  |  标签:11g
、grid

本文出自 “inthirties(男
人三十)
”博客,转载请务必注明作者和保留出处。
11g里出现了一个新角色。
Oracle Grid Infrastructure
http://downlo ......

Oracle DECODE

语法:
DECODE(expr, search, result [, search, result ]... [, default ] )
应用:
DECODE函数将每一个expr和search的值做比较。如果expr的值与search的值相等,Oracle数据库就会返回相应的result。如果找不到匹配的值,Oracle返回default。如果没有default,Oracle返回null值。参数可以是任意数值类型(NUMBER,BINAR ......

用PowerDesingner把oracle中的表导成er图

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