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 Data Guard, 分逻辑Standby和物理Standby。 下面讲的是物理Standby 环境的搭建步骤。 有关Data Guard的一些概念性的理论知识,请参考我的blog, 这里不做过多的说明。
Oracle Data Gurad 理论知识
http://blog.csdn.net/tianlesoftware/archive/2010/04 ......
一. Oracle 控制文件主要包含如下条目
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECO ......
语法:
DECODE(expr, search, result [, search, result ]... [, default ] )
应用:
DECODE函数将每一个expr和search的值做比较。如果expr的值与search的值相等,Oracle数据库就会返回相应的result。如果找不到匹配的值,Oracle返回default。如果没有default,Oracle返回null值。参数可以是任意数值类型(NUMBER,BINAR ......
现在的项目比较紧,加上自己也比较懒,实在是“没时间”写啊,呵呵,昨天看到一篇挺好的Oracle存储过程的例子,正好最近要用,转过来大家一起分享一下,谢谢(晨光映霞),原作地址:http://blog.csdn.net/xuyabao/archive/2008/03/20/2200205.aspx。
--------------------自定义函数开始-------------- ......
latch是用于保护内存(系统全局区,SGA)中的共享内存结构的互斥机制。Latch就像是内存上的锁,可以由一个进程非常快速地激活和释放,用于防止对一个共享内存结构进行并行访问。如果latch不可用,那么将记录latch释放失败。绝大多数latch问题都与没有使用绑定变量(library-cache latch(库缓存latch))、重做日志生成问题 ......