ocp考試筆記

1、duplicate美[?djupl?k?t]復(fù)制的，副本的invisible隱匿的無(wú)形的OptimizerStatistics優(yōu)化器統(tǒng)計(jì)數(shù)據(jù)Implement執(zhí)行使生效，實(shí)現(xiàn)落實(shí)recommended被推薦的archival檔案exhibit陳列，展覽呈現(xiàn)證明公開(kāi)展覽某物展出strip剝光表演脫衣舞剝除除去，剝?nèi)儕Z刪除清除，拆除identify識(shí)別，認(rèn)出確定使參與把…看成一樣確定認(rèn)同suspended暫停的，緩期的（宣判），懸浮的re

2、sumable美[r?zju:m?b?l]可恢復(fù)的resync重新同步wkbench工作臺(tái)，作業(yè)臺(tái)purge清除，（使）凈化attribute認(rèn)為…是把…歸于把…品質(zhì)歸于某人individual個(gè)人的獨(dú)特的個(gè)別的overrides優(yōu)先于比…更重要retention保留記憶力，保持力滯留，扣留capture俘獲奪取奪得引起（注意、想像、興趣）捕獲占領(lǐng)捕獲物[計(jì)算機(jī)]捕捉annotate注解Integrity完整；完善；正直；誠(chéng)實(shí)criti

3、cal批評(píng)的；挑剔的；決定性的；危險(xiǎn)的臨界audit審計(jì)，查賬consumed消耗redundancy美[r??d?nd?nsi]過(guò)多，過(guò)剩冗長(zhǎng)裁員optimum美[?ɑpt?m?m]最適宜的desire美[d??za?r]希望渴望要求請(qǐng)求implement美[??mpl?m?nt]實(shí)施，執(zhí)行使生效，實(shí)現(xiàn)落實(shí)duplexing[dju:pleksi?][通信]雙工，復(fù)式；雙煉法v使成雙（duplex的ing形式），轉(zhuǎn)接asynchron

4、ous美[es??kr?n?s]異步的obsolete美[?ɑbs??lit?ɑbs??lit]廢棄的老式的，已過(guò)時(shí)的[生]已廢退的廢詞被廢棄的事物auxiliary美[?ɡ?z?lj?ri?z?l?ri]輔助的備用的，補(bǔ)充的附加的副的evolve演變，進(jìn)化involve美[?n?vɑlv]包含使參與，牽涉圍繞，纏繞使專心于conventional[k?n?v?n??n?l]傳統(tǒng)的習(xí)用的，平常的maintenance美[?ment?n?

5、ns]維持，保持保養(yǎng)，保管維護(hù)維修excessive美[?k?s?s?v]過(guò)度的，極度的過(guò)分的過(guò)多的exclusive美[?k?sklus?v]專用的高級(jí)的排外的單獨(dú)的associated英[??s???ie?t?d]合伙，合營(yíng)聯(lián)合，結(jié)合聯(lián)想encrypted把…編碼；把…加密dynamically充滿活力地；精力充沛地；個(gè)性強(qiáng)地（過(guò)程）動(dòng)態(tài)地；發(fā)展變化地cumulative美[?kjumj??let?vj?l?t?v]累積的；漸增的；

6、追加的；（判刑等）加重的累加；累計(jì)的；specified[英]spes?fa?d指定(specify的過(guò)去式和過(guò)去分詞)詳述提出…的條件recommends推薦勸告criteria英[kra?t??r??]批評(píng)、判斷等的）標(biāo)準(zhǔn)，準(zhǔn)則indicate[英]?nd?ke?t表明，標(biāo)示，指示象征，暗示，預(yù)示utilize[英]ju:t?la?z利用，使用cruption[英]k??r?p?n腐敗貪污賄賂變體prerequisite[英]?pr

7、i:rekw?z?t先決條件，前提，必要條件?語(yǔ)句SQLTuningAdvisinvokesAutomaticTuningOptimizertogeneraterecommendations.RecommendationstoacceptSQLprofilesoccurinafinding.如果丟失當(dāng)前redologfile則還原，基于SCN時(shí)間或者取消的恢復(fù)，再同RESETLOGS打開(kāi)數(shù)據(jù)庫(kù)，打開(kāi)數(shù)據(jù)庫(kù)后，再進(jìn)行一次全備份。如果丟失不

8、是當(dāng)前redologfile，則刪除添加，或者清除。?OCI_RESULT_CACHE_MAX_SIZE(optional)Maximumsizeinbytesftheperprocessquerycache.Specifyingasizelessthan32768intheclientsql.afiledisablestheclientresultcachefeaturefclientprocessesreadingthissql.a

9、file.NOCADE_FCEBacksoutspecifiedtransactionsigningdependenttransactions.ServerrunsundoSQLstatementsfspecifiedtransactionsinreversederofcommittimes.Ifnoconstraintsbreakyouaresatisfiedwiththeresultyoucancommitthechangesoth

10、erwiseyoucanrollthemback.acleASMPreferredReadDiskGroupsItimprovesperfmancebyreadingfromacopyofanextentclosesttothenode.SQLTuningAdvisprovidesoptionstomanagethescopedurationofatuningtask.Youcansetthescopeofatuningtaskeith

11、erofthefollowing:LimitedInthiscaseSQLTuningAdvisproducesrecommendationsbasedonstatisticalchecksaccesspathanalysisSQLstructureanalysis.SQLprofilerecommendationsarenotprehensiveInthiscaseSQLTuningAdviscarriesoutalltheanaly

12、sisitperfmsunderlimitedscopeplusSQLProfiling.Withthecomprehensiveoptionyoucanalsospecifyatimelimitfthetuningtaskwhichbydefaultis30minutes.FILESYTEMIO_OPTIONScanbesettooneofthefollowingvalues:?ASYNCH:enableasynchronousIOo

13、nfilesystemfileswhichhasnotimingrequirementftransmission.?DIRECTIO:enabledirectIOonfilesystemfileswhichbypassesthebuffercache.?SETALL:enablebothasynchronousdirectIOonfilesystemfiles.?NONE:disablebothasynchronousdirectIOo