???????????

????1???????

????sql????????????????????顣???????????淶??

????2????????

?????????Σ?????????ж?SQL?????????????????????壬?????sql????漰???????????????????

????3??shared pool check(shared sql area check)

???????????????shared pool check ??????????????????????е???????衣

???????????????hash??????sql???????hash???????sql_id v$sql.sql_id.(sql???shared pool check??????????hash value ?????????????????飬??????????飬??????????????粻????????????????????????????session??????????п????????)

???????????

??????SQL?????????Σ??????????漸?????衣

????1??????????????????????????????????sql??????????·????hints????м??

????2?????????????????????????????????????м????cost??cost ?? ??????

????3?????????????????cost????м???????????????????row source ????????

???????????????????????????????

????????????????????????л??????????????

????????row source generation

?????????????????????м??????????????????????????????

???????plan???????????????

??????????sql vm ??е??????????????

??????????????????????????????

?????????????????rowset????Щrowset?е?row????????????????????????

?????????????????????row set?????????????????????????????????????????????

????row source generator ????????????????????????????????

??????????????????????

????1??????????????????

????2??????????????????????????

????3????????????????????????????

????4?????????????????????????????

??????????

??????е????sql?????????row source ??????????????е??????????