Lub sijhawm ua haujlwm taug kev sau tshwj xeeb SQL nqe lus rau cov txheej txheem ua haujlwm, nrog rau cov xov xwm sib nug (cov lus nug cov phiaj xwm thiab cov xwm txheej tos) uas tau tua thaum tsab ntawv khiav. Koj tuaj yeem taug qab ib qho kev sib cav tsis tu ncua nyob hauv Oracle database.
Cov Lus Qhia
Kauj ruam 1
Ua ntej pib txoj kev taug, koj yuav tsum tau ua kom cov txheeb cais sau, txwv tsis pub cov ntaub ntawv nrog xoom sijhawm yuav tshwm sim. Txhawm rau ua qhov no, koj yuav tsum tau ua tiav cov lus nug: hloov qhov system teeb tsa timed_statistics = muaj tseeb Yog tias koj xav pib pib sib tham hauv kev sib kho tam sim no, tom qab ntawd qhov system parameter yuav tsum tau hloov nrog kev sib kho.
Kauj ruam 2
Txheeb xyuas tias qhov ntau tshaj plaws cov ntaub ntawv pov tseg qhov loj qhov ntaus nqi yog tsim los kom muaj nuj nqis. Txhawm rau ua qhov no, ua tiav cov lus nug SQL sib nug: SELECT value FROM v $ param p WHERE name = 'max_dump_file_size' Tus nqi ntawm $ param tuaj yeem tsim ob qho tib si ntawm theem database (hloov chaw) thiab ntawm ntu kev sib ntsib (hloov ntu).
Kauj ruam 3
Tom qab ntawv txheeb xyuas qhov kev sib kho uas xav tau los tshawb xyuas. Txhawm rau ua qhov no, nrhiav tawm qhov tseem ceeb rau ntawm txhua: Xaiv xaiv sab ntawm, $ # ntawm v $ system QHOV TWG xaiv qhov twg_criteria rau_tracing
Kauj ruam 4
Txhawm rau pib taug qab, koj yuav tsum teeb tsa 1046 hauv qhov sib kho ntawd. Khiav cov txheej txheem sys.dbms_system.set_ev, thiab tom qab ntawd dhau qhov tau txais sid thiab cov nuj nqis raws li cov lej tsis tseem ceeb: BEGIN sys.dbms_system.set_ev (sid, serial #, 10046, 8, ''); KAWG
Kauj ruam 5
Txhawm rau txo cov kev taug, hloov tus nqi ntawm qhov tshwm sim theem 10046 los ntawm 8 rau 0.
Kauj Ruam 6
Cov kab ntawv tshwm nyob rau hauv Oracle cov ntaub ntawv pov tseg cov chaw (Oracle / admin / databaseSID / udump). Lub npe ntawm cov ntaub ntawv no muaj cov cim ntawm tus txheej txheem OS hauv kev ua haujlwm, thiab txuas ntxiv yog.trc. Txhawm rau txhawm rau ua tiav cov ntaub ntawv hauv cov ntawv uas nyeem tau, ua cov ntaub ntawv kab ntawv hauv tkprof chaw tso dej: cd C: ORACLEadmindatabaseSIDudump
tkprof file.trc tso zis = my_file.prf Cov ntawv thov yuav teev tag nrho cov lus txib uas tau tua lub sijhawm qhib.
