?????塢??TOP SQL

???????????????????????????????????????????????????????
?????????????????????????????????
????Execution=0    ?????AWR?????????????С???????Execution????0????ЩSQL???С??????????
??????????????????OLAP???????OLTP??????????????SQL???OLAP??????????п???????п???nologging????
????OLAP??ν?????????????
????1????????????nologging??
????--create table xxx nologging??
????2?????????????????У?
????--insert /*+ append */;
????3???????????DML???У?
????--alter session enable parallel dml;
????4??????sql????hash???????????hash??
????--sql hint ??hash
?????????????????????????
????1??????????
????2??????nologing??
????3?????в???
????4????hash??
??????????????????????Щ????????飺
????OLAP??block?????????16K??
????OLAP??PGA???????????????????SGA???С??