- 博客(4)
- 收藏
- 关注
转载 log file sync(日志文件同步) 与 Log file parallel write 等待事件
log file sync(日志文件同步)等待事件具有一个参数:buffer#。在Oracle Database 10g中,这种等待事件位于Commit等待下面。当处理log file sync等待事件时,注意下面的思想: ◎ log file sync 等待时间和事务中指(提交或回滚)相关 ◎ 当进程在log file sync事件上花费大量时间时,这通常表明过多的提交或短事务。
2014-04-30 17:22:24 496
原创 V$LOCK 视图
V$LOCK lists the locks currently held by the Oracle Database and outstanding requests for a lock or latch. Column Datatype Description ADDR RAW(4 | 8) Address of lock state obj
2014-04-30 17:07:34 499
转载 字符设备和块设备的区别
设备文件分为Block Device Driver和Character Device Drive两类。Character Device Drive又被称为字符设备或裸设备raw devices; Block Device Driver通常成为块设备。而Block Device Driver是以固定大小长度来传送转移资料 ;Character Device Driver是以不定长度的字元传送资料
2014-04-29 09:06:38 812
原创 表连接 nested loop hash join sort merge
11.3 Overview of Joins Joins are statements that retrieve data from multiple tables. A join is characterized by multiple tables in the FROM clause. The existence of a join condition in the WHERE cla
2014-04-22 14:48:14 424
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人