易截截图软件、单文件、免安装、纯绿色、仅160KB

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.


相关文档:

ORACLE数据字典简介


ORACLE中的数据字典是什么?有什么特点和规律?
  数据字典记录了数据库的系统信息,它是只读表和系统视图的集合。
  数据字典的所有者是SYS用户,数据字典都被存放在SYSTEM表空间,SYS用户的方案下。
  数据字典只允许SELECT操作,其维护和修改任务由数据库自动完成。
当用户执行CREATE、ALTER、DROP ......

Oracle删除表中重复记录

--刪除重復列  
  a.如果有ID字段,就是具有唯一性的字段  
   
  delect   table   where   id   not   in   (  
   
  select   max(id)   from   table   group   by   col1,col ......

MsSQL,MySQL,Oracle,数据库连接字段

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 ......

Oracle按字符截取字符串函数

输入参数:str ——要截取的字符串,  ch——要查找的字符串
截取ch之前(不包括ch)的字符串: substr(str, 0, instr(str, ch) - 1)
截取ch之后(不包括ch)的字符串: substr(str, , instr(str, ch) + 1, length(str)) ......

Oracle的优化器有两种优化方式(二)

15. /*+USE_CONCAT*/
对查询中的WHERE后面的OR条件进行转换为UNION  ALL的组合查询. (懵懂啊,先存着)
例如:
select /*+use_concat */ * from emp where deptno=10 OR empno=7788;
Execution Plan
----------------------------------------------------------
   0      S ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号