Oracle Waits event:DB File Scattered Read
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 number
indicates that there may be missing or suppressed indexes. This could also be preferred, since it
may be more efficient to perform a full table scan than an index scan. Check to ensure full table
scans are necessary when you see these waits. Try to cache small tables to avoid reading them
into memory over and over again. Locate the data on disk systems that have either more disk
caching or are buffered by the OS file system cache. DB_FILE_MULTIBLOCK_READ_COUNT
can make full scans faster (but it could also influence Oracle to do more of them). You can also
partition tables and indexes so that only a portion is scanned. Slow File I/O (slow disks) can
cause these waits. Correlated to each of the waits are the values for P1,P2,P3=file, block, blocks.
相关文档：
1，查看当前的保护模式
select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
2，查看日志的传送方式；
select dest_name,archiver from v$archive_dest;
3，停止standby的自动恢复状态
alter database recover manager standby database finish;
4，添加standby logfile
&nb ......
在 Windows 上安装 Oracle 数据库 11g
安装Oracle 软件，必须使用 Oracle Universal Installer。
1.在这一安装中，您需要使用 DVD 或下载 DVD 版本。在本教程中，将从已下载的版本进行安装。在解压缩 DVD 文件的目录中，打开 Windows 资源浏览器并双击 \db\Disk1 目录的 setup.exe。
2.安装的产品为 Oracle Da ......
输入参数：str ——要截取的字符串, ch——要查找的字符串
截取ch之前（不包括ch）的字符串： substr(str, 0, instr(str, ch) - 1)
截取ch之后（不包括ch）的字符串： substr(str, , instr(str, ch) + 1, length(str)) ......
1、查询两个日期之间的数据。
假设有表Table1，其创建表的sql语句为：
create table Table1(
StationID NUMBER(10) Primary key,
Year NUMBER(4) not null,
Month NUMBER(2) n ......
