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 ---
相关文档：
三、 PL/SQL程序单元
1、无论是单独的过程/函数，还是包中的过程/函数，都统称为子程序。
2、过程
1) 异常处理部分是可选的。
2) 过程名应该用动词，因为过程通常是执行某种动作。过程并不一定具有参数。当� ......
Ms sql 2000
drivername=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=books
username=sa
password=sa
MySQL
drivername=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/books
username=root
password=root
Oracle
drivername=orac ......
数学函数
1.绝对值
S:select abs(-1) value
O:select abs(-1) value from dual
2.取整(大)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.取整（小）
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.取� ......
修改oracle 10g的字符集
修改数据库字符集为：ZHS16GBK
首先用scott&tiger&orcl登录到sql/plus
查看服务器端字符集
SQL > select * from
V$NLS_PARAMETERS;
修改：
$sqlplus /nolog
SQL>conn / as sysdba
若
此时数据库服务器已启动，则先执行 SHUTDOWN IMMEDIATE 命
令关闭数据库服务器，然后执 ......
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 ......
