33
个常见的等待事件
...................................................................................................110
Buffer busy waits .........................................................................................................................110
Buffer latch...............................................................................................................................111
Control file parallel write .............................................................................................................111
Control file sequential read .........................................................................................................112
Db file parallel read .....................................................................................................................112
Db file parallel write ....................................................................................................................112
Db file scattered read ..................................................................................................................113
Db file sequential read.................................................................................................................113
Db file single write.......................................................................................................................113
Direct path read.........................................................................................................................114
Direct path write........................................................................................................................114
Enqueue ....................................................................................................................................114
Free buffer waits........................................................................................................................117
Latch free...................................................................................................................................118
Library cache lock ......................................................................................................................119
Library cache pin........................................................................................................................119
Log file parallel write .................................................................................................................119
Log buffer space ........................................................................................................................120
Log file sequential read..............................................................................................................120
Log file single write....................................................................................................................120
Log file switch(archiving needed) ..............................................................................................120
Log file switch(checkpoint incomplete) .....................................................................................121
Log file sync ...............................................................................................................................121
SQL*Net break/reset to client ...................................................................................................122
SQL*Net break/reset to dblink ..................................................................................................122
SQL*Net message from client....................................................................................................122
SQL*Net message from dblink...................................................................................................122
SQL*Net message to client........................................................................................................123
SQL*Net message to dblink.......................................................................................................123
SQL*Net more data from client.................................................................................................123
SQL*Net more data from dblink................................................................................................123
SQL*Net more data to client......................................................................................................124
SQL*Net more data to dblink.....................................................................................................124
存储过程.....................................................................................................................................124
Procedure
定义
.............................................................................................................124
定义.............................................................................................................................................124
优 点...........................................................................................................................................124
存储过程与函数的对比.............................................................................................................125
存储过程使用示例
.........................................................................................................125
存储过程格式............................................................................................................................125
存储过程中的循环....................................................................................................................127
for ... in ... loop 循环 ..........................................................................................................127
loop 循环............................................................................................................................128
