oracle raw devices
1.LVM:
[root@vmfs ~]# pvdisplay
--- Physical volume ---
PV Name /dev/sdg
VG Name db_v4
PV Size 2.00 GB / not usable 0
Allocatable yes
PE Size (KByte) 4096
Total PE 511
Free PE 1
Allocated PE 510
PV UUID MlB8lE-H3DL-RCcf-p5Di-J6A2-INLc-zw328m
--- Physical volume ---
PV Name /dev/sdf
VG Name db_v3
PV Size 2.00 GB / not usable 0
Allocatable yes
PE Size (KByte) 4096
Total PE 511
Free PE 115
Allocated PE 396
PV UUID 2KsemU-DsQQ-GR8k-nnR2-Zm7M-nUCb-yXuUR5
--- Physical volume ---
相关文档：
输入参数：str ——要截取的字符串, ch——要查找的字符串
截取ch之前（不包括ch）的字符串： substr(str, 0, instr(str, ch) - 1)
截取ch之后（不包括ch）的字符串： substr(str, , instr(str, ch) + 1, length(str)) ......
Oracle 的生产库都是启动在归档模式下，RAC下归档非归档的切换和单实例也是一样的，都是在MOUNT模式下执行ALTER DATABASE ARCHIVELOG/NOARCHIVELOG;命令。 不同的是：RAC环境下所有实例都必须处于非OPEN状态，然后在任意一个处于MOUNT状态的实例执行ALTER DATABASE命令，操作成功后，再正常启动 ......
1、查询两个日期之间的数据。
假设有表Table1，其创建表的sql语句为：
create table Table1(
StationID NUMBER(10) Primary key,
Year NUMBER(4) not null,
Month NUMBER(2) n ......
The DB File Scattered Read wait event generally indicates waits related to full table scans or fast
full index scans. As full table scans are pulled into memory, they are scattered throughout the
buffer cache, since it is usually unlikely that they fall into contiguous buffers. A large numb ......
The DB File Sequential Read wait event generally indicates a single block read (an index read,
for example). A large number could indicate poor joining orders of tables or unselective indexing.
This number will certainly be large (normally) for a high-transaction, well-tuned system. You ......
