ืืขืื
ืืื ืืึทืฉืืึธืกื ืฆื ืืืืื ืืืื ืืขืคึฟืื ืขื - ืื ืคืจืืื ืคืื ืืขืืึทื ืง, ืคึผืจืึธืฆืขืก ืืื ืืขืืช.
ืืืจื ืืื ืืจืืืก: ืืึธืก ืืื ื ืืฉื ืึท ืืขืคึฟืื ืขื, ืคืื ืงืืจืก - ืึทืืข ืืขื ืืึธื ืืึธืื ืืขืืืขื ืืืงืื ื ืคึฟืึทืจ ืึท ืืึทื ื ืฆืืึทื, ืฆื ืื ืืืืก ืืขื ืขื ืื ืืืึทืืืื ืืื ืืขืืืขื ืื ืกืืึทืืืกืืืฉ ืืึทืื ืคึผืจืึทืกืขืกืื ื ืืื ืึทืคึผืืึทืืึทืืืืฉืึทื ืคืื ืงืืื ืกืืกืืขืืขื, ื ืื ืืึทืืืงืข ืกืคึผืึทืกืืคืืงืื ืื DBMS.
ืืื: ืืึธ, ืืื ืืืืกื, ืืื ืฉืจืืึทืื ืืฉืืงืึทืืืข ืึทืจืืืงืืขื ืืืืฃ ืืืืขืจ ืคืึธืจืฉืื ื,
ืืืืฃ ืื ืื ืืขืจืข ืืึทื ื: ืึธืคืึทื ื ืืื ืืึธื ื ืื ืืขื ืงืืื ืืืืืืกืคึผืจืขื ืืขืจืืึธื ืขื ืึธืืขืจ ืืืกืขืืึทื ืืืฉืึทื ืคืื ืืขื ืฆืืืึทื ื ืืืืฃ ืืขืจ ืืื ืืขืจื ืขืฅ ืฆืืืืฉื IT ืกืคึผืขืฉืึทืืึทืกืฅ, ืืืึท.
ืึทืืื, ืฆื ืื ืคืื ื.
ืืึธืืืจ ืืืขืจื ืขืืขื ืึทื ืืืจ ืืึธืื ืึท ืึทืจืืขื: ืฆื ืฉืืขืื ืึท ืืืืขืจ ืืื ืกื ืกืืกืืขื ืฆื ืืื ืขื ืขืืืขืืข ืืื ืคืื ืึทืจืืขื.
ืขืก ืืื ืืืงืื ื ืืืขืื ืืขื ืึทืจืืขื: ืืืึธืก ืขืก ืืื, ืืื ืื ืงืืืึทืืืืขื ืคืื ืืขื ืึทืจืืขื ืืื ืืขืืืกืื, ืืื ืืืึธืก ืืื ืื ืงืจืืืขืจืืึธื ืคึฟืึทืจ ืืขืกืื ืื ืงืืืึทืืืืขื.
ืืึธืืืจ ืืืื ืืืขืจื ืขืืขื ืึทื ืขืก ืืื ืืขืจ ืึธืืขืจ ืืืืื ืืงืขืจ ืืืงืื ื ืืื ืคืืจืฉืืื ืขื: ืคึผืื ืงื ืืื ืึทืจืืขื ืืื ืืขืืื ืืื (ืึธืืขืจ ืืื) ืืขื ืืื ืกื ืกืืกืืขื.
"ืืขืจ ืึธืืขืจ ืืืืื ืืงืขืจ" - ืืึธืก ืืืื ืึทื ืขืก ืืื ืืขืืืขื ืฆื ืฆืืืจืืืื (ืึธืืขืจ ืืึทืงืืืขื ืขืก ืคึฟืื ืขืจืืขืฅ) ืึท ืืืืขืจ ืืขืฆืืึทื, ื ืืฆื, ืืื ืกื ืืืึธืก ืงืขื ืขื ืืืื ืกืื ืืึทืกืืืื ืืื ืืขืืืขื ืื ืฆื ืื ืกืืกืืขื ืืื ืึท ืคึผืจืึธืืข ืืึทืกืข ืืขื ืื ืืืืื ืฆื ืืืึธืก ืืืขื ืืืื ืืื ืคึผืจืึธืืืงืฆืืข, ืืื ืืืืื ืืื ืืขื ืืขื ืื ืืืืื ืคึฟืึทืจ ืืจืืขืื ืืื ืคึผืจืึธืืืงืฆืืข.
ื ื, ืืึธืื ืืื ืื ืืืขืจื ืขืืขื ืึทื ืึท ืกืืื ืคืื ืึทืืืฉืึทืกืืืึทื ื ืคึผืึทืจืึทืืขืืขืจืก ืคึฟืึทืจ ืืขื ืืื ืกื ืกืืกืืขื ืืื ืืืงืื ื, ืืืึธืก ืงืขื ืขื ืืืื ืืขืืืืื ื ืฆื ืงืึทื ืคืืืืขืจ ืืขื ืกืืกืืขื ืืื ืืขืจืืื ืขื ืคืื ืื ืคึผืจืึธืืืึทืงืืืืืืื ืคืื ืืืึทื ืึทืจืืขื.
ืืื ืืืึธืก ืืื ืื ืคึผืจืึธืืืขื - ืขืก ืืื ื ืืฉื ืึท ืืขื ืื ืคืืืฉืืขื ืืืง ืคืืจืฉืืื ื ืคืื ืืขื ืืื ืกื ืกืืกืืขื, ืืืึธืก ืึทืืึทืื ืืืจ ืฆื ืขืงืกืคึผืขืจืืื ืงืึทื ืคืืืืขืจ ืื ืกืขืืืื ืืก ืคืื ืืขื ืกืืกืืขื ืคึฟืึทืจ ืฆืืงืื ืคึฟื ืืึทืกืข ืืืืฃ ืึท ืืขืืขืื ืคึผืืึทืืคืึธืจืืข ืืื ืืึทืงืืืขื ืื ืคืืจืืื ืื ืคึผืจืึธืืืึทืงืืืืืืื ืคืื ืื ืกืืกืืขื.
ื ื. ืืึธืก ืืื ืึผืืขื ืฉืืขื ืืืง ืืขืจ ืคืึทื.
ืืืึธืก ืงืขื ืขื ืืืจ ืืึธื ืืึธ?
ื ื, ืืขืจ ืขืจืฉืืขืจ ืืึทื ืืืึธืก ืงืืื ืฆื ืืืื ืื ื ืืื ืฆื ืงืืงื ืืื ืื ืืึทืงืืืืขื ืืืืฉืึทื ืคึฟืึทืจ ืืขื ืกืืกืืขื. ืคึฟืึทืจืฉืืืื ืืืึธืก ืื ืคึผืึทืกืืง ืจืืื ืืืฉืึทื ืืขื ืขื ืคึฟืึทืจ ืื ืืืึทืืืขืก ืคืื ืื ืึทืืืฉืึทืกืืืึทื ื ืคึผืึทืจืึทืืขืืขืจืก. ืืื, ืืืฉื, ื ืืฆื ืื ืงืึธืืึธืจืืึทื ืึทื ืึทืจืึธืคึผืืึทื ื ืืืคึฟื, ืกืขืืขืงืืืจื ืืืึทืืืขืก ืคึฟืึทืจ ืกืืกืืขื ืคึผืึทืจืึทืืขืืขืจืก ืืื ืืขืกืฅ.
ืืขื ืข. ืืขืื ืื ืกืืกืืขื ืึท ืืื ืคืื ืงืึทื ืคืืืืขืจืืืฉืึทื ืืื ืื ืคืึธืจืขื ืคืื ืึท ืกืคึผืขืฆืืคืืฉ ืืึทื ื ืคืื ืืืึทืืืขืก ืคึฟืึทืจ ืืืึทื ืงืึทื ืคืืืืขืจืืืฉืึทื ืคึผืึทืจืึทืืขืืขืจืก.
ืึธื ืืืขื ืื ืึท ืคึผืจืึธืืข ืืึทืกืข ืฆื ืขืก, ื ืืฆื ืืขื ืืืืขืจ ืืขืฆืืึทื-ื ืืฅ ืืึทืกืข ืืขื ืขืจืึทืืึธืจ.
ืืื ืงืืง ืืื ืื ืืืขืจื - ืืขืจ ืขื ืืคืขืจ, ืึธืืขืจ ืึท ืืขืืจืืง ืคืื ืื ืงืืืึทืืืืขื ืคืื ืื ืกืืกืืขื.
ืืขืจ ืฆืืืืืืขืจ ืืขืืึทื ืง ืงืขื ืืืื ืื ืืกืงื ื ืึทื ืืึธืก ืืื ืึท ืืืืขืจ ืืึทื ื ืฆืืึทื.
ื ื, ืืึธืก ืืื: ืืืื ืขืก ืืขื ืขื ืึท ืคึผืืึทืฅ ืคืื ืืื ืื ื ืคึผืึทืจืึทืืขืืขืจืก, ืืืื ืื ืจืืื ืืืฉืึทื ืคืื ืืืืขืจ ืืืึทืืืขืก ืงืึทืืืขืจื ืืขื ืขื ืืจืืืก, ืืืื ืืขืืขืจ ืืืื ืืึทืกืข ืคึผืจืืืืจื ื ืขืื ืึท ืคึผืืึทืฅ ืคืื ืฆืืื ืฆื ืคืึทืจืขื ืืืงื, ืืขืืึธืื: ืืึธ, ืึทืืข ืืขื ืงืขื ื ืขืืขื ืึท ืึทื ืึทืงืกืขืคึผืืึทืืึทื ืกืืืข ืคืื ืฆืืื.
ื ื, ืืึธ ืก ืืืึธืก ืืืจ ืงืขื ืขื ืคึฟืึทืจืฉืืืื ืืื ืืขืืขื ืงืขื.
ืืืจ ืงืขื ืขื ืืขืคึฟืื ืขื ืึทื ืืื ืื ืืึทื ื ืคืื ืืืึทืืืขืก ืคืื ืื ืคึผืึทืจืึทืืขืืขืจืก ืคืื ืื ืกืขืจืืืืก ืกืืกืืขื ืกืขืืืื ืืก ืขืก ืืื ืึท ืืืขืงืืึธืจ, ืืื ืึท ืกืืงืืืึทื ืก ืคืื ืขืืืขืืข ืืืึทืืืขืก.
ืืขืืขืจ ืึทืืึท ืืืขืงืืึธืจ, ืื ืืขืจืข ืืืื ืืขื ืขื ืืืืึทื (ืืื ืึทื ืขืก ืืื ื ืืฉื ืึทืคืขืงืืึทื ืืืจื ืืขื ืืืขืงืืึธืจ), ืงืึธืจืึทืกืคึผืึทื ืื ืฆื ืึท ืืึธืจ ืืึทืฉืืืื ืืขืืจืืง ืืืขืจื - ืึท ืืจืืื ืคืื ืื ืงืืืึทืืืืขื ืคืื ืกืืกืืขื ืึธืคึผืขืจืึทืฆืืข ืืื ืืขืจ ืคึผืจืืืืจื ืืึทืกืข.
ืืึธืก ืืืืกื
ืืื ืืื ืื ืึธื ืืืืึทืื ืื ืกืืกืืขื ืงืึทื ืคืืืืขืจืืืฉืึทื ืืืขืงืืึธืจ ืืื ืืื ; ืืืื - ื ืืืขืจ ืคืื ืกืืกืืขื ืงืึทื ืคืืืืขืจืืืฉืึทื ืคึผืึทืจืึทืืขืืขืจืก, ืืื ืคืืืข ืคืื โโืื ืคึผืึทืจืึทืืขืืขืจืก ืขืก ืืขื ืขื.
ืืื ืื ืืืขืจื ืคืื ืื ืืขืืจืืง ืงืึธืจืึทืกืคึผืึทื ืืื ื ืฆื ืืขื ืืืืืจ ืขืก ืืืฆืืืืขื ืขื ืืื
, ืืขืืึธืื ืืืจ ืืึทืงืืืขื ืึท ืคึฟืื ืงืฆืืข:
ื ื, ืืขืจืืืขืจ: ืึทืืฅ ืงืืื ืืืืื ืึทืจืึธืคึผ ืฆื, ืืื ืืืื ืคืึทื: ืึผืืขื ืคืืจืืขืกื ืคืื ืืืื ืกืืืืขื ืื ืืขื, ืึทืืืขืจืืืึทืื ืคึฟืึทืจ ืืืื ืคึฟืึทืจ ืื ืขืงืกืืจืขื ืคืื ืึท ืคึฟืื ืงืฆืืข.
ืึธืืงืื, ืึธืืขืจ ืืึธ ืึท ืึธืจืืึทื ืึทืืืืฉืึทื ืึทื ืืื ืืขืืืขื ืื ืงืฉืื ืขืจืืืืึทื: ืืืึธืก ืึทืืืขืจืืืึทื ืฆื ื ืืฆื.
- ืืื ืืขื ืืื ืขื - ืึทืืื ืึทื ืืืจ ืงืขื ืขื ืงืึธื ืืืืื ืืงืขืจ ืืืจื ืืึทื ื.
- ืืื ืคึฟืึทืจ ืขืก ืฆื ืึทืจืืขืื, ื.ื. ืืขืคืื ืขื ืื ืขืงืกืืจืขื (ืืืื ืขืก ืืื ืืืื), ื ื, ืืคึผืืืช ืคืึทืกืืขืจ ืืื ืงืึธืืึธืจืืึทื ืึทื ืึทืจืึธืคึผืืึทื ื.
ืืขืจ ืขืจืฉืืขืจ ืคืื ื ืืื ืฅ ืึทื ืืืจ ืืึทืจืคึฟื ืฆื ืงืืงื ืฆื ืขืืืขืืข ืื ืืืืืจืึทื ืืึทื ืฅ ืืื ืืืึธืก ืึทืืึท ืึทืืืขืจืืืึทืื ืืึธืื ืฉืืื ืืืคึผืืึทืืขื ืึทื, ืืื ืืขื ืขื, ืืื ืขืืืขืืข ืคืึธืจืขื, ืืจืืื ืคึฟืึทืจ ื ืืฆื ืืื ืงืึธื.
ื ื, ืืื ืืืืกื python
ะธ cran-r
ืื ืจืืข ืคืื ื ืืืื ืึทื ืืืจ ืืึทืจืคึฟื ืฆื ืืืืขื ืขื ืืืขืื ืื ืึทืืืขืจืืืึทืื ืืื, ืืืึธืก ืืื ืืขื ืขื, ืืืึธืก ืืขื ืขื ืืืืขืจ ืืืืขืจืคืขื ืืฉื, ืื ืคึฟืขืึดืงืืืื ืคืื ืืืืขืจ ืึทืจืืขื.
ืืื ืืืึธืก ืืื ืืขืื ืงืขื ืขื ืืืื ื ืืฆืืง ืืืึทื ืืคืขืงืก - ืจืขืืืืืึทืื ืึธืืขืจ ืืืืึทื ืคึฟืื ืื ืึทืืืขืจืืืึทื ืืื.
ืึธืืขืจ ืืื ืงืขื ืขื ืืืื ืืืงืืืขื ืคืื ืื ืจืขืืืืืึทืื ืคืื ืื ืึทืืืขืจืืืึทื.
ื ืคึผืืึทืฅ ืืขืคึผืขื ืืก ืืืืฃ ืื ืึทืจืืึทื ืฉืจืืึทื ืื ืึธืื.
ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืืืื, ืคึฟืึทืจ ืขืืืขืืข ืกืืื, ืืืจ ืืึทืจืคึฟื ืฆื ืืึทืงืืืขื ืึท ืจืขืืืืืึทื ืคืึทืกืืขืจ, ื ื, ืืืจ ืืึทืจืคึฟื ืฆื ืงืืงื ืฆื ืืจืึทืืืขื ื ืึทืจืึธืคึผืืึทื ื ืึทืืืขืจืืืึทืื ืืื ืงืืืึทืื ืืืื ืขืจ ืคืื ืืื.
ืึธืืขืจ, ืืืื ืฆืืื ืืื ื ืืฉื ืึทืืื ืืืืืืืง, ืืืจ ืงืขื ืขื, ืืืฉื, ื ืืฆื ืกืืึธืืฉืึทืกืืืง ืึทืคึผืืึทืืึทืืืืฉืึทื ืืขืืืึธืืก, ืึทืืึท ืืื ืึท ืืขื ืขืืืง ืึทืืืขืจืืืึทื.
ืืื ืคืึธืจืฉืืึธืื ืฆื ืืึทืืจืึทืืื ืื ืึทืจืืขื ืคืื ืืขื ืฆืืืึทื ื, ืกืึทืืขืงืืื ื ืื ืกืืกืืขื ืงืึทื ืคืืืืขืจืืืฉืึทื, ื ืืฆื ืึท ืืขื ืขืืืง ืึทืืืขืจืืืึทื, ืืื ืืขืจ ืืืืึทืืขืจ, ืึทืืื ืฆื ืืึธืื: ืืึทืืึธืจืึทืืึธืจืืข ืึทืจืืขื.
ืึธืจืืืื ืขื:
- ืืื ืขืก ืืืื, ืืื ืึท ืืื ืกื ืกืืกืืขื:
oracle xe 18c
- ืืึธืื ืขืก ืืื ืขื ืืจืึทื ืกืึทืงืืืึธื ืึทื ืืขืืืงืืื ืืื ืืขืจ ืฆืื: ืฆื ืืึทืงืืืขื ืื ืืขืืกืื ืืขืืืขื ืืจืืคึผืื ืคืื ืื ืกืืืืึทืืึทืืืืก ืืื ืืจืึทื ืืึทืงืฉืึทื ื / ืกืขืง.
- ืืจืึทื ืืึทืงืฉืึทื ื ืงืขื ืขื ืืืื ืืืืขืจ ืึทื ืืขืจืฉ ืืื ืื ื ืึทืืืจ ืคืื ืืจืืขืื ืืื ืืึทืื ืืื ืื ืงืึธื ืืขืงืกื ืคืื ืึทืจืืขื.
ืืื ืก ืฉืืืืขื ืึทื ืืึธืก ืืขื ืขื ืืจืึทื ืืึทืงืฉืึทื ื ืืืึธืก ืืึธื ื ืื ืคึผืจืึธืฆืขืก ืึท ืืจืืืก ืกืืืข ืคืื โโืืึทืืืืึทืจ ืืึทืื.
ืืื ืืขื ืืื ืขื ืึทื ืืื ืืึธื ื ืื ืืืฉืขื ืขืจืืื ืืขืจ ืืคืืึทืื ืืึทืื ืืื ืจืขืืึธ ืืื ืืึธื ื ืื ืคึผืจืึธืฆืขืก ืืจืืืก ืคึผืขืจืกืขื ืืืืืฉืื ืคืื ืจืึธืื ืืื ืืจืืืก ืืืฉื.
ืืืก ืืขื ืขื ืืจืึทื ืืึทืงืฉืึทื ื ืืืึธืก ืืืืฉื ืืืื ืจืืืขืจื ืืื ืึท ืืขืจ ืึธืืขืจ ืืืืื ืืงืขืจ ืืจืืืก ืืืฉ, ืืื ืึท ืงืืืื ื ืืืขืจ ืคืื ืื ืืขืงืกืื ืืืืฃ ืืขื ืืืฉ.
ืืื ืืขื ืกืืืืึทืฆืืข: ืื ืคึผืจืึธืืืึทืงืืืืืืื ืคืื ืื ืกืึทืืืึทืืึทืืืืก ืคึฟืึทืจ ืคึผืจืึทืกืขืกืื ื ืืจืึทื ืืึทืงืฉืึทื ื ืืืขื, ืืื ืึท ืจืขืืขืจืืืึทืฆืืข, ืืืื ืืืฉืืืกื ืืืจื ืื ืงืืืึทืืืืขื ืคืื ืคึผืจืึทืกืขืกืื ื ืืืจื ืื ืจืขืืึธืงืก ืืึทืืึทืืืืก.
ืึธืคึผืืืืงืขื ืื ื - ืืืื ืืืจ ืจืขืื ืกืคึผืึทืกืืคืืงืื ืืืขืื ืื ืกืืืื ืกืขืืืื ืืก.
ืืืืึทื, ืืื ืึทืืืขืืืื, ืขืก ืงืขื ืืืื, ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืืจืึทื ืกืึทืงืืืึธื ืึทื ืืึทืงืก ืฆืืืืฉื ืกืงื ืกืขืฉืึทื ื, ืจืขืื ืฆื ืืขืจ ืคึผืืึทื ืคืื ืืึทื ืืฆืขืจ ืึทืจืืขื ืืื ืืึทืืืืึทืจ ืืึทืื ืืื / ืึธืืขืจ ืื ืืึทืืืืึทืจ ืืึธืืขื.
ืืืึธืก, ืคืื ืงืืจืก, ืืืขื ืืึธืื ืึท ืืืคึผืจืขืกืื ื ืืืืจืงืื ื ืืืืฃ ืื TPS ืืขืืจืืง ืืื ืืึธืก ืืืขื ืืืื ืึท ืขืงืกืึธืืขื ืึธืืก ืคืึทืงืืึธืจ, ืงืึธืจืขืื ืฆื ืื ืกืืืืึทืืึทืืืืก: ื ื, ืืึธืก ืืื ืืื ืื ืืึทืืืืึทืจ ืืึธืืขื ืืื ืืืืืื ื ืืื ืื ืึทืจืืขื ืืื ืืึทืื ืืื ืขืก ืึทื ืืืึทืงืืืืฉืื ืคืึทืื.
ืืขืจืืืขืจ, ืคึฟืึทืจ ืื ืจืืื ืงืืึทื ืคืื ืืขืจ ืขืงืกืคึผืขืจืืืขื ื, ืืืจ ืืืขืื ืืืกืฉืืืกื ืืขื ืคืึทืงืืึธืจ, ืืื ืื ืืขืจ ืืื ืืืขื ืืขืจืงืืขืจื ืคึผืื ืงื ืืื.
- ืืื ืืื ืื ืืืขืจื ืขืืขื, ืคึฟืึทืจ ืืขืคืื ืืืขื ืขืกืก, ืึทื 100% ืคืื ืื SQL ืงืึทืืึทื ืื ืืขืจืืื ืื ืฆื ืื ืืึทืืึทืืืืก ืืขื ืขื DML ืงืึทืืึทื ืื.
ืืึธืื ืื ืงืขืจืึทืงืืขืจืืกืืืงืก ืคืื ืืึทื ืืฆืขืจ ืึทืจืืขื ืืื ืื ืกืืืืึทืืึทืืืืก ืืืื ืื ืืขืืืข ืืื ืืขืกืฅ.
ื ืืืืื: ืื ื ืืืขืจ ืคืื ืกืงื ืกืขืฉืึทื ื, ืืึทืืืืึทืจ ืืึทืื, ืืื ืกืงื ืกืขืฉืึทื ื ืึทืจืืขื ืืื ืืื. - ืกืืื ืึทืจืืขื ืืื
FORCE LOGGING
,ARCHIVELOG
ืืึธืืก. ืคืืึทืฉืืึทืงืง-ืืืืืึทืืืืก ืืึธืืข ืืื ืืืืกืืขืืจืืื ืึทืืืขืง ืืืืฃ ืื ืกืืื ืืืจืื. - ืจืขืืึธ ืืึธืืก: ืืืื ืืื ืึท ืืึทืืื ืืขืจ ืืขืงืข ืกืืกืืขื, ืืืืฃ ืึท ืืึทืืื ืืขืจ "ืืืกืง";
ืื ืจืขืฉื ืคืื ืื ืืฉืืืืช ืงืึธืืคึผืึธื ืขื ื ืคืื ืื ืืึทืืึทืืืืก: ืืื ืื ืื ืืขืจ, ืืึทืืื ืืขืจ ืืขืงืข ืกืืกืืขื, ืืืืฃ ืึท ืืึทืืื ืืขืจ "ืืืกืง":
ืืขืจ ืืขืืึทืืืก ืืืขืื ืืขื ืืฉืืืืช ืืืื. ืืึทืืึธืจืึทืืึธืจืืข ืืึทืืึทืืืืก ืงืึทืืคึผืึธืื ืึทื ืฅ
SQL> select status||' '||name from v$controlfile;
/db/u14/oradata/XE/control01.ctl
SQL> select GROUP#||' '||MEMBER from v$logfile;
1 /db/u02/oradata/XE/redo01_01.log
2 /db/u02/oradata/XE/redo02_01.log
SQL> select FILE_ID||' '||TABLESPACE_NAME||' '||round(BYTES/1024/1024,2)||' '||FILE_NAME as col from dba_data_files;
4 UNDOTBS1 2208 /db/u14/oradata/XE/undotbs1_01.dbf
2 SLOB 128 /db/u14/oradata/XE/slob01.dbf
7 USERS 5 /db/u14/oradata/XE/users01.dbf
1 SYSTEM 860 /db/u14/oradata/XE/system01.dbf
3 SYSAUX 550 /db/u14/oradata/XE/sysaux01.dbf
5 MONITOR 128 /db/u14/oradata/XE/monitor.dbf
SQL> !cat /proc/mounts | egrep "/db/u[0-2]"
/dev/vda1 /db/u14 ext4 rw,noatime,nodiratime,data=ordered 0 0
/dev/mapper/vgsys-ora_redo /db/u02 xfs rw,noatime,nodiratime,attr2,nobarrier,inode64,logbsize=256k,noquota 0 0
ืืืืืขืก, ืืื ืืขืจ ืื ืืึทืกืข ืื ืึธืื, ืืื ืืขืืืืื ืฆื ื ืืฆื ืืจืึทื ืกืึทืงืืืึธื ืกืืื
ืขืก ืืื ืึทืืึท ืึท ืืืื ืืขืจืืขื ืฉืืจืื, ืืื ืืืขื ืฆืืืืจื ืืขื ืืืืจ:
ืืื ืื ืืึทืจืฅ ืคืื SLOB ืืื ืื "SLOB ืืืคึฟื." ืื SLOB ืืขืืึทื ืืืื ืฆื ืคึผืจืืืืจื ืคึผืืึทืืคืึธืจืืก
ืึธื ืึทืคึผืืึทืงืืืฉืึทื ืงืึทื ืืขื ืฉืึทื. ืืืื ืขืจ ืงืขื ื ืืฉื ืคืึธืจื ืืึทืงืกืืืื ืืึทืื ืืืึทืจื ืคืึธืจืฉืืขืืื ื
ื ืืฆื ืึทืคึผืืึทืงืืืฉืึทื ืงืึธื ืืืึธืก ืืื, ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืืขืืื ืื ืืืจื ืึทืคึผืืึทืงืืืฉืึทื ืืึทืงืื ื ืึธืืขืจ ืืคืืื
ืืึทื ืืืืืื ื ืึธืจืึทืงืืข ืืึทืืึทืืึทืกืข ืืืึทืงืก. ืึทื ืก ืจืขืื - ืขืก ืืื ืึธืืืืขืจืืขื ืืืขื ืืึทื ืืืืืื ื ืืึทืื
ืืื ืืึทืื ืืืึทืงืก! ืึธืืขืจ SLOB - ืืื ืืืื ืคืขืืืงืืึทื ืืืคึผืืืืืึทื ื - ืืื ืืืืื ืฆื ืึทืืึท ืงืึทื ืืขื ืฉืึทื.
ืื ืืขืงืืึทืจืึทืฆืืข: ืงืึธืจืึทืกืคึผืึทื ืื, ืขืก ืืื.
ืขืก ืืื ืืึทืงืืืขื ืฆื ืจืขืืืืืจื ืื ืืจืึทื ืคืื ืคึผืึทืจืึทืืขืืืกื ืคืื ืงื ืกืขืฉืึทื ื, ืืึธืก ืืื ืืขืจ ืฉืืืกื -t
ืงืึทืืขืจ ืื ื ืืฆื runit.sh
ืคืื SLOB
ืืขืจ ืคึผืจืึธืฆืขื ื ืคืื DML ืงืึทืืึทื ืื ืืื ืจืขืืืึทืืืืืึทื, ืืื ืื ื ืืืขืจ ืคืื ืืขืงืกื ืึทืจืืืงืืขื ืืืึธืก ืืขื ืขื ืืขืฉืืงื ืฆื ืื ืกืืื, ืืขืืขืจ ืืขืงืกื ืกืขืกืืข, ืคึผืึทืจืึทืืขืืขืจ UPDATE_PCT
ืกืขืคึผืขืจืึทืืื ืืื ืืืืขืจ ืืึทืงืืืขื: SLOB
ืืื, ืืืืืขืจ ืืื ื ืึธื ืื ืืึทืกืข ืกืขืกืืข - ืคึผืจืืคึผืขืจื ืึท ืกืืึทืฅืคึผืึทืง, ืึธืืขืจ awr-snapshots (ืืืึธืก ืืื ืืึทืฉืืืื ืฆื ืืืื ืฆืืืขืืจืืื).
ืึธืืขืจ, ืขืก ืคืืจืงืขืจื ืืืืก ืึทื SLOB
ืฉืืืฆื ื ืืฉื ืกืงื ืกืขืฉืึทื ื ืืื ืึท ืืขืืืืขืจ ืคืื ืืืืื ืืงืขืจ ืืื 30 ืกืขืงืื ืืขืก.
ืืขืจืืืข ืจ ืื ื ืื ื ืฆืืขืจืฉ ื ืืขืงืื ื ืืฒ ื ืืฒืืขื ืข , ืืจืืขืืขืจึพืคืืืขืจืืฉ ืข ืืืขืจืกืืข , ืคื ื ืืข ืจ ืืืืข ืจ ืื ื ืื ื ืื ื ืืขืืืื ื ืื ื ืืคืขืจืืฆืืข .
ืืึธืื ืืืจ ืืขืจืงืืขืจื ืืืึธืก ืื ืืึธืืืขืจ ืืื ืืื ืืื ืขืก ืืื ืขืก, ืคึฟืึทืจ ืงืืขืจืืื.
ืืืืกืืงืื, ืื ืืึธืืืขืจ ืงืืงื ืืื ืืึธืก:
ืึทืจืืขืืขืจ ืงืึธื
function dotx()
{
local v_period="$2"
[ -z "v_period" ] && v_period="0"
source "/home/oracle/testingredotracะต/config.conf"
$ORACLE_HOME/bin/sqlplus -S system/${v_system_pwd} << __EOF__
whenever sqlerror exit failure
set verify off
set echo off
set feedback off
define wnum="$1"
define period="$v_period"
set appinfo worker_&&wnum
declare
v_upto number;
v_key number;
v_tots number;
v_cts number;
begin
select max(col1) into v_upto from system.testtab_&&wnum;
SELECT (( SYSDATE - DATE '1970-01-01' ) * 86400 ) into v_cts FROM DUAL;
v_tots := &&period + v_cts;
while v_cts <= v_tots
loop
v_key:=abs(mod(dbms_random.random,v_upto));
if v_key=0 then
v_key:=1;
end if;
update system.testtab_&&wnum t
set t.object_name=translate(dbms_random.string('a', 120), 'abcXYZ', '158249')
where t.col1=v_key
;
commit;
SELECT (( SYSDATE - DATE '1970-01-01' ) * 86400 ) into v_cts FROM DUAL;
end loop;
end;
/
exit
__EOF__
}
export -f dotx
ืืืึธืจืงืขืจืก ืืขื ืขื ืืึธื ืืฉื ืืขื ืืืขื:
ืืืืคื ืืืงืข ืืจืืขืืขืจ
echo "starting test, duration: ${TEST_DURATION}" >> "$v_logfile"
for((i=1;i<="$SQLSESS_COUNT";i++))
do
echo "sql-session: ${i}" >> "$v_logfile"
dotx "$i" "${TEST_DURATION}" &
done
echo "waiting..." >> "$v_logfile"
wait
ืืื ืืืฉื ืคึฟืึทืจ ืืืขืจืก ืืขื ืขื ืฆืืืขืืจืืื ืืื ืืึธืก:
ืฉืืคื ืืึทืืืขืก
function createtable() {
source "/home/oracle/testingredotracะต/config.conf"
$ORACLE_HOME/bin/sqlplus -S system/${v_system_pwd} << __EOF__
whenever sqlerror continue
set verify off
set echo off
set feedback off
define wnum="$1"
define ts_name="slob"
begin
execute immediate 'drop table system.testtab_&&wnum';
exception when others then null;
end;
/
create table system.testtab_&&wnum tablespace &&ts_name as
select rownum as col1, t.*
from sys.dba_objects t
where rownum<1000
;
create index testtab_&&wnum._idx on system.testtab_&&wnum (col1);
--alter table system.testtab_&&wnum nologging;
--alter index system.testtab_&&wnum._idx nologging;
exit
__EOF__
}
export -f createtable
seq 1 1 "$SQLSESS_COUNT" | xargs -n 1 -P 4 -I {} -t bash -c "createtable "{}"" | tee -a "$v_logfile"
echo "createtable done" >> "$v_logfile"
ืืขื ืข. ืคึฟืึทืจ ืืขืืขืจ ืึทืจืืขืืขืจ (ืคึผืจืึทืงืืึทืงืื: ืึท ืืึทืืื ืืขืจ ืกืงื ืกืขืกืืข ืืื ืื ืื) ืืื ืืืฉืืคื ืึท ืืึทืืื ืืขืจ ืืืฉ, ืืื ืืืึธืก ืืขืจ ืึทืจืืขืืขืจ ืึทืจืืขื.
ืืึธืก ืื ืฉืืจื ืืขืจ ืึทืืืขืง ืคืื ืืจืึทื ืกืึทืงืืืึธื ืึทื ืืึทืงืก ืฆืืืืฉื ืึทืจืืขืืขืจ ืกืขืฉืึทื ื.
ืืขืืขืจ ืืจืืขืืขืจ: ืืื ืื ืืขืืืข ืืื, ืืื ืืืื ืืืืืขื ืขื ืืืฉ, ืื ืืืฉื ืืขื ืขื ืืืข ืื ืืขืืืข.
ืื ืข ืืจืืขืืข ืจ ืคืืจ ื ืืจืืขื ื ืื ื ืืข ืจ ืืขืืืข ืจ ืฆืฒื .
ืืขืจืฆื, ืคึฟืึทืจ ืึท ืืึทื ื ืืขื ืื ืฆืืึทื ืึทืืื ืึทื, ืืืฉื, ืึท ืงืืึธืฅ ืืึทืฉืืืืขื ืืืึธืื ืืืฉืืืื ืคึผืึทืกืืจื, ืืื ืืขืจ ืืื ืึทืืึธื.
ื ื, ืึทืงืึธืจืืื ืืื, ืคึฟืึทืจืืื ืื ืงืึธืก ืืื ืืคืขืงืฅ ืืืืคืืขืฉืืื ืขื.
ืืื ืืืื ืคืึทื, ืืื ืงืึทื ืคืืืืขืจื ืื ืืขืืืืขืจ ืคืื ืื ืืืขืจืก 'ืึทืจืืขื ืืื 8 ืืื ืื.
ื ืฉืืืง ืคืื ืึท ืกืืึทืฅืคึผืึทืง ืืึทืจืืื ืืืกืงืจืืืืื ื ืื ืึธืคึผืขืจืึทืฆืืข ืคืื โโืื ืกืืื ืืื ืืขืจ ืืึทืกืข
Database DB Id Instance Inst Num Startup Time Release RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
2929910313 XE 1 07-Sep-20 23:12 18.0.0.0.0 NO
Host Name Platform CPUs Cores Sockets Memory (G)
~~~~ ---------------- ---------------------- ----- ----- ------- ------------
billing.izhevsk1 Linux x86 64-bit 2 2 1 15.6
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- --------- ------------------
Begin Snap: 1630 07-Sep-20 23:12:27 55 .7
End Snap: 1631 07-Sep-20 23:20:29 62 .6
Elapsed: 8.03 (mins) Av Act Sess: 8.4
DB time: 67.31 (mins) DB CPU: 15.01 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 1,392M Std Block Size: 8K
Shared Pool: 288M Log Buffer: 103,424K
Load Profile Per Second Per Transaction Per Exec Per Call
~~~~~~~~~~~~ ------------------ ----------------- ----------- -----------
DB time(s): 8.4 0.0 0.00 0.20
DB CPU(s): 1.9 0.0 0.00 0.04
Redo size: 7,685,765.6 978.4
Logical reads: 60,447.0 7.7
Block changes: 47,167.3 6.0
Physical reads: 8.3 0.0
Physical writes: 253.4 0.0
User calls: 42.6 0.0
Parses: 23.2 0.0
Hard parses: 1.2 0.0
W/A MB processed: 1.0 0.0
Logons: 0.5 0.0
Executes: 15,756.5 2.0
Rollbacks: 0.0 0.0
Transactions: 7,855.1
ืืืืืขืงืขืจื ืฆื ืืขืจ ืืึทืืึธืจืึทืืึธืจืืข ืึทืจืืขื.
ืืืจ ืืืขืื, ืื ืืขืจืข ืืืืื, ืืืึทืื ืื ืืืึทืืืขืก ืคืื ืื ืคืืืืขื ืืข ืคึผืึทืจืึทืืขืืขืจืก ืคืื ืื ืืึทืืึธืจืึทืืึธืจืืข ืกืืืืึทืืึทืืืืก:
- ืืจืืืก ืคืื ืืืืืึทืืืืก ืงืืึธืฅ ืืจืืคึผืขืก. ืืืขืจื ืงืืื: [32, 1024] ืื;
- ื ืืืขืจ ืคืื ืืฉืืจื ืึทื ืืจืืคึผืขืก ืืื ืื ืืึทืืึทืืืืก. ืืืขืจื ืงืืื: [2,32];
log_archive_max_processes
ืืืขืจื ืงืืื: [1,8];commit_logging
ืฆืืืื ืืืึทืืืขืก ืืขื ืขื ืขืจืืืืื:batch|immediate
;commit_wait
ืฆืืืื ืืืึทืืืขืก ืืขื ืขื ืขืจืืืืื:wait|nowait
;log_buffer
ืืืขืจื ืงืืื: [2,128] ืืขืืืืืืื.log_checkpoint_timeout
ืืืขืจื ืงืืื: [60,1200] ืกืขืงืื ืืขืกdb_writer_processes
ืืืขืจื ืงืืื: [1,4]undo_retention
ืืืขืจื ืงืืื: [30;300] ืกืขืงืื ืืขืกtransactions_per_rollback_segment
ืืืขืจื ืงืืื: [1,8]disk_asynch_io
ืฆืืืื ืืืึทืืืขืก ืืขื ืขื ืขืจืืืืื:true|false
;filesystemio_options
ืื ืคืืืืขื ืืข ืืืึทืืืขืก ืืขื ืขื ืขืจืืืืื:none|setall|directIO|asynch
;db_block_checking
ืื ืคืืืืขื ืืข ืืืึทืืืขืก ืืขื ืขื ืขืจืืืืื:OFF|LOW|MEDIUM|FULL
;db_block_checksum
ืื ืคืืืืขื ืืข ืืืึทืืืขืก ืืขื ืขื ืขืจืืืืื:OFF|TYPICAL|FULL
;
ื ืืขื ืืฉ ืืื ืืขืจืคืึทืจืื ื ืืื ืืืื ืืืื ืื ื ืึธืจืึทืงืืข ืืึทืืึทืืืืกืื ืงืขื ืขื ืึทืืืึทืืข ืฉืืื ืืึธืื ืืืึธืก ืืื ืฆื ืืืึธืก ืืืึทืืืขืก ืืึธื ืืืื ืืึทืฉืืืื, ืคึฟืื ืื ืกืคึผืขืกืืคืืขื ืคึผืึทืจืึทืืขืืขืจืก ืืื ืืืืขืจ ืคึผืึทืกืืง ืืืึทืืืขืก, ืฆื ืืึทืงืืืขื ืึท ืืจืขืกืขืจืข ืคึผืจืึธืืืึทืงืืืืืืื ืคืื ืื ืืึทืืึทืืืืก ืคึฟืึทืจ ืื ืึทืจืืขื ืืื ืืึทืื ืืืึธืก ืืื ืื ืืึทืงืืืืื ืืืจื ืื ืึทืคึผืืึทืงืืืฉืึทื ืงืึธื, ืืึธ ืืืืื.
ืึธืืขืจ.
ืื ืคืื ื ืคืื ืื ืืึทืืึธืจืึทืืึธืจืืข ืึทืจืืขื ืืื ืฆื ืืืืึทืื ืึทื ืื ืึทืคึผืืึทืืึทืืืืฉืึทื ืึทืืืขืจืืืึทื ืืื ืืืขื ืืขืจืงืืขืจื ืืึธืก ืคึฟืึทืจ ืืื ืื ืืขืคืืขืจืขื ืืขืฉืืืื ื.
ืคึฟืึทืจ ืืื ืื, ืึทืืข ืืืึธืก ืืืืืื ืืื ืฆื ืงืืงื ืืื ืืขื ืืึธืงืืืขื ื, ืืืจื ืื ืงืืกืืึธืืืืึทืืืข ืกืืกืืขื, ืคึผืื ืงื ืืขื ืื ืฆื ืืขืคึฟืื ืขื ืืืืก ืืืึธืก ืคึผืึทืจืึทืืขืืขืจืก ืฆื ืืืืฉื ืืื ืืื ืืืึธืก ืจืืื ืืืฉืึทื.
ืืื ืืืื: ืงืึธื ืื ืงืึธื ืืืึธืก ืืืขื ืืืื ืืขืืืืื ื ืฆื ืึทืจืืขืื ืืื ืื ืื ืื ืกืืกืืขื ืคืื ืื ืืืืกืืขืงืืืื ืึทืคึผืืึทืืึทืืืืฉืึทื ืึทืืืขืจืืืึทื.
ืึทืืื, ืืืฆื ืืืขืื ืื ืงืึธื.
ืืื ืืขืจืขืื ืืืืื ืืืขืื cran-r
, ื"ื: ืึทืืข ืืึทื ืืคึผืืึทืืืืฉืึทื ื ืืื ืื ืงืึทืกืืึทืืืืื ืกืืกืืขื ืืขื ืขื ืึธืจืงืขืกืืจืืืืื ืืื ืื ืคืึธืจืขื ืคืื ืึท ืจ ืฉืจืืคื.
ืื ืคืึทืงืืืฉ ืึทืจืืขื, ืึทื ืึทืืืกืืก, ืกืขืืขืงืฆืืข ืืืจื ืืขืืจืืง ืืืขืจื, ืกืืกืืขื ืฉืืึทื ืืืขืงืืึธืจืก: ืืึธืก ืืื ืึท ืคึผืขืงื GA
(
ืืขืจ ืคึผืขืงื, ืืื ืืขื ืคืึทื, ืืื ื ืืฉื ืืืืขืจ ืคึผืึทืกืืง, ืืื ืืขื ืืื ืขื ืึทื ืขืก ืืงืกืคึผืขืงืฅ ืืืขืงืืึธืจืก (ืืฉืจืึธืืึธืกืึธืืื, ืืืื ืืื ืืขืจืืื ืขื ืคืื ืื ืคึผืขืงื) ืฆื ืืืื ืกืคึผืขืกืืคืืขื ืืื ืื ืคืึธืจืขื ืคืื ืกืืจืื ืืก ืคืื ื ืืืขืจื ืืื ืึท ืคืจืึทืงืฉืึทื ืึทื ืืืื.
ืืื ืืืื ืืืขืงืืึธืจ, ืคึฟืื ืื ืืืึทืืืขืก ืคืื ืื ืืึทืฉืืขืืืงื ืคึผืึทืจืึทืืขืืขืจืก: ืืึธืก ืืขื ืขื 14 ืงืืืึทื ืืึทืืื - ืื ืืึทืืืฉืขืจื ืืื ืฉืืจืืงื ืืืึทืืืขืก.
ืืขืจ ืคึผืจืึธืืืขื, ืคืื ืงืืจืก, ืืื ืืืืื ืึทืืืืืืึทื ืืืจื ืึทืกืืื ืื ื ืขืืืขืืข ืกืคึผืขืฆืืคืืฉ ื ืืืขืจื ืฆื ืฉืืจืืงื ืืืึทืืืขืก.
ืืืื, ืืื ืื ืกืืฃ, ืื ืืืืคึผื ืฉืืืง ืคืื ืื R ืฉืจืืคื ืงืืงื ืืื ืืึธืก:
ืจืืคื GA :: ืืึท
cat( "", file=v_logfile, sep="n", append=F)
pSize = 10
elitism_value=1
pmutation_coef=0.8
pcrossover_coef=0.1
iterations=50
gam=GA::ga(type="real-valued", fitness=evaluate,
lower=c(32,2, 1,1,1,2,60,1,30,1,0,0, 0,0), upper=c(1024,32, 8,10,10,128,800,4,300,8,10,40, 40,30),
popSize=pSize,
pcrossover = pcrossover_coef,
pmutation = pmutation_coef,
maxiter=iterations,
run=4,
keepBest=T)
cat( "GA-session is done" , file=v_logfile, sep="n", append=T)
gam@solution
ืืึธ, ืืื ืืขืจ ืืืืฃ lower
ะธ upper
ืกืืืจืืืื ืข ืึทืืจืืืืืฅ ga
ืืกืขื ืฉืึทืื, ืึท ืืขืื ื ืคืื ืืขืจ ืืืื ืคึผืืึทืฅ ืืื ืกืคึผืขืกืืคืืขื, ืืื ืืืึธืก ืึท ืืืื ืืืขื ืืืื ืืืจืืืขืงืึธืื ืคึฟืึทืจ ืึทืืึท ืึท ืืืขืงืืึธืจ (ืึธืืขืจ ืืืขืงืืึธืจืก) ืคึฟืึทืจ ืืืึธืก ืื ืืึทืงืกืืืื ืืืขืจื ืคืื ืื ืืืืืืงืืื ืคืื ืงืฆืืข ืืืขื ืืืื ืืืงืืืขื.
ืื ืืึท ืกืืืจืืืื ืข ืคึผืขืจืคืึธืจืื ืึท ืืืื ืืึทืงืกืึทืืืืืื ื ืื ืืืืืืงืืื ืคืื ืงืฆืืข.
ื ื, ืืขืจืืืขืจ, ืขืก ืืืจื ืก ืืืืก ืึทื ืืื ืืขื ืคืึทื, ืขืก ืืื ื ืืืืืง ืึทื ืื ืืืืืืงืืื ืคืื ืงืฆืืข, ืฆื ืคึฟืึทืจืฉืืืื ืื ืืืขืงืืึธืจ ืืื ืึท ืกืืื ืคืื ืืืึทืืืขืก ืคึฟืึทืจ ืืืืขืจ ืคึผืึทืจืึทืืขืืขืจืก ืคืื ืื ืกืืื, ืืึทืงืืืขื ืึท ืืขืืจืืง ืคืื ืื ืกืืื.
ืึทื ืืื: ืืื ืคืืืข, ืืื ืึท ืืขืืขืื ืกืืื ืกืขืืึทืคึผ ืืื ืึท ืืขืืขืื ืืึทืกืข ืืืืฃ ืื ืกืืื: ืื ืกืืื ืคึผืจืึทืกืขืกืึทื ืืจืึทื ืืึทืงืฉืึทื ื ืคึผืขืจ ืกืขืงืื ืืข.
ืึทื ืืื, ืืืขื ืึทื ืคืึธืืืืื ื, ืื ืคืืืืขื ืืข ืืึทืืื-ืฉืจืื ืืืื ืืืื ืืืจืืืขืงืึธืื ืืื ืื ืืืืืืงืืื ืคืื ืงืฆืืข:
- ืคึผืจืึทืกืขืกืื ื ืื ืึทืจืืึทื ืฉืจืืึทื ืืืขืงืืึธืจ ืคืื ื ืืืขืจื - ืงืึทื ืืืขืจืืื ื ืขืก ืืื ืืืึทืืืขืก ืคึฟืึทืจ ืกืืืืึทืืึท ืคึผืึทืจืึทืืขืืขืจืก.
- ืึทื ืคึผืจืืืื ืฆื ืฉืึทืคึฟื ืึท ืืขืืขืื ื ืืืขืจ ืคืื ืจืขืืึธ ืืจืืคึผืขืก ืคืื ืึท ืืขืืขืื ืืจืืืก. ืืขืจืฆื, ืืขืจ ืคึผืจืืืื ืงืขื ืืืื ื ืื ืืขืจืึธืื.
ืืฉืืจื ืึทื ืืจืืคึผืขืก ืืืึธืก ืืึธืื ืฉืืื ืขืงืืืกืืืจื ืืื ืื ืกืืื, ืืื ืขืืืขืืข ืงืืืึทื ืืืื ืืื ืคืื ืขืืืขืืข ืืจืืืก, ืคึฟืึทืจ ืื ืจืืื ืงืืึทื ืคืื ืื ืขืงืกืคึผืขืจืืืขื ื - ื.ื. ืืืืกืืขืืขืงื. - ืืืื ืื ืคืจืืขืจืืืงืข ืคืื ื ืืื ืืขืจืึธืื: ืกืคึผืขืฆืืคืืฆืืจื ืื ืืืึทืืืขืก ืคืื ืงืึทื ืคืืืืขืจืืืฉืึทื ืคึผืึทืจืึทืืขืืขืจืก ืฆื ืื ืืึทืืึทืืืืก (ืืืืืขืจ: ืขืก ืงืขื ืืืื ืึท ืืืจืืคืึทื)
- ืืืื ืื ืคืจืืขืจืืืงืข ืฉืจืื ืืื ืืขืจืึธืื: ืกืืึธืคึผืคึผืื ื ืื ืกืืื, ืึธื ืืืื ืื ืกืืื ืึทืืื ืึทื ืื ื ืืึท ืกืคึผืขืกืืคืืขื ืคึผืึทืจืึทืืขืืขืจ ืืืึทืืืขืก ื ืขืืขื ืืืืจืงืื ื. (ืืืืืขืจ: ืขืก ืงืขื ืืืื ืึท ืืืืืฉ)
- ืืืื ืื ืคืจืืขืจืืืงืข ืฉืจืื ืืื ืืขืจืึธืื: ืืืจืืคืืจื ืึท ืืึทืกืข ืคึผืจืืืืจื. ืืึทืงืืืขื ืืขืืจืืงืก ืคืื ืกืืื.
- ืฆืืจืืงืงืืืขื ืื ืกืืื ืฆื ืืืึทื ืึธืจืืืื ืขื ืฉืืึทื, ื.ื. ืืืกืืขืงื ื ืึธื ืงืืึธืฅ ืืจืืคึผืขืก, ืฆืืจืืงืงืืืขื ืื ืึธืจืืืื ืขื ืกืึทืืืึทืืึทืืืืก ืงืึทื ืคืืืืขืจืืืฉืึทื ืฆื ืึทืจืืขืื.
ืืืืืืงืืื ืคึฟืื ืงืฆืืข ืงืึธื
evaluate=function(p_par) {
v_module="evaluate"
v_metric=0
opn=NULL
opn$rg_size=round(p_par[1],digit=0)
opn$rg_count=round(p_par[2],digit=0)
opn$log_archive_max_processes=round(p_par[3],digit=0)
opn$commit_logging="BATCH"
if ( round(p_par[4],digit=0) > 5 ) {
opn$commit_logging="IMMEDIATE"
}
opn$commit_logging=paste("'", opn$commit_logging, "'",sep="")
opn$commit_wait="WAIT"
if ( round(p_par[5],digit=0) > 5 ) {
opn$commit_wait="NOWAIT"
}
opn$commit_wait=paste("'", opn$commit_wait, "'",sep="")
opn$log_buffer=paste(round(p_par[6],digit=0),"m",sep="")
opn$log_checkpoint_timeout=round(p_par[7],digit=0)
opn$db_writer_processes=round(p_par[8],digit=0)
opn$undo_retention=round(p_par[9],digit=0)
opn$transactions_per_rollback_segment=round(p_par[10],digit=0)
opn$disk_asynch_io="true"
if ( round(p_par[11],digit=0) > 5 ) {
opn$disk_asynch_io="false"
}
opn$filesystemio_options="none"
if ( round(p_par[12],digit=0) > 10 && round(p_par[12],digit=0) <= 20 ) {
opn$filesystemio_options="setall"
}
if ( round(p_par[12],digit=0) > 20 && round(p_par[12],digit=0) <= 30 ) {
opn$filesystemio_options="directIO"
}
if ( round(p_par[12],digit=0) > 30 ) {
opn$filesystemio_options="asynch"
}
opn$db_block_checking="OFF"
if ( round(p_par[13],digit=0) > 10 && round(p_par[13],digit=0) <= 20 ) {
opn$db_block_checking="LOW"
}
if ( round(p_par[13],digit=0) > 20 && round(p_par[13],digit=0) <= 30 ) {
opn$db_block_checking="MEDIUM"
}
if ( round(p_par[13],digit=0) > 30 ) {
opn$db_block_checking="FULL"
}
opn$db_block_checksum="OFF"
if ( round(p_par[14],digit=0) > 10 && round(p_par[14],digit=0) <= 20 ) {
opn$db_block_checksum="TYPICAL"
}
if ( round(p_par[14],digit=0) > 20 ) {
opn$db_block_checksum="FULL"
}
v_vector=paste(round(p_par[1],digit=0),round(p_par[2],digit=0),round(p_par[3],digit=0),round(p_par[4],digit=0),round(p_par[5],digit=0),round(p_par[6],digit=0),round(p_par[7],digit=0),round(p_par[8],digit=0),round(p_par[9],digit=0),round(p_par[10],digit=0),round(p_par[11],digit=0),round(p_par[12],digit=0),round(p_par[13],digit=0),round(p_par[14],digit=0),sep=";")
cat( paste(v_module," try to evaluate vector: ", v_vector,sep="") , file=v_logfile, sep="n", append=T)
rc=make_additional_rgroups(opn)
if ( rc!=0 ) {
cat( paste(v_module,"make_additional_rgroups failed",sep="") , file=v_logfile, sep="n", append=T)
return (0)
}
v_rc=0
rc=set_db_parameter("log_archive_max_processes", opn$log_archive_max_processes)
if ( rc != 0 ) { v_rc=1 }
rc=set_db_parameter("commit_logging", opn$commit_logging )
if ( rc != 0 ) { v_rc=1 }
rc=set_db_parameter("commit_wait", opn$commit_wait )
if ( rc != 0 ) { v_rc=1 }
rc=set_db_parameter("log_buffer", opn$log_buffer )
if ( rc != 0 ) { v_rc=1 }
rc=set_db_parameter("log_checkpoint_timeout", opn$log_checkpoint_timeout )
if ( rc != 0 ) { v_rc=1 }
rc=set_db_parameter("db_writer_processes", opn$db_writer_processes )
if ( rc != 0 ) { v_rc=1 }
rc=set_db_parameter("undo_retention", opn$undo_retention )
if ( rc != 0 ) { v_rc=1 }
rc=set_db_parameter("transactions_per_rollback_segment", opn$transactions_per_rollback_segment )
if ( rc != 0 ) { v_rc=1 }
rc=set_db_parameter("disk_asynch_io", opn$disk_asynch_io )
if ( rc != 0 ) { v_rc=1 }
rc=set_db_parameter("filesystemio_options", opn$filesystemio_options )
if ( rc != 0 ) { v_rc=1 }
rc=set_db_parameter("db_block_checking", opn$db_block_checking )
if ( rc != 0 ) { v_rc=1 }
rc=set_db_parameter("db_block_checksum", opn$db_block_checksum )
if ( rc != 0 ) { v_rc=1 }
if ( rc!=0 ) {
cat( paste(v_module," can not startup db with that vector of settings",sep="") , file=v_logfile, sep="n", append=T)
rc=stop_db("immediate")
rc=create_spfile()
rc=start_db("")
rc=remove_additional_rgroups(opn)
return (0)
}
rc=stop_db("immediate")
rc=start_db("")
if ( rc!=0 ) {
cat( paste(v_module," can not startup db with that vector of settings",sep="") , file=v_logfile, sep="n", append=T)
rc=stop_db("abort")
rc=create_spfile()
rc=start_db("")
rc=remove_additional_rgroups(opn)
return (0)
}
rc=run_test()
v_metric=getmetric()
rc=stop_db("immediate")
rc=create_spfile()
rc=start_db("")
rc=remove_additional_rgroups(opn)
cat( paste("result: ",v_metric," ",v_vector,sep="") , file=v_logfile, sep="n", append=T)
return (v_metric)
}
ืึทื. ืึทืืข ืึทืจืืขื: ืืขืืื ืืื ืื ืืืืืืงืืื ืคืื ืงืฆืืข.
ืื ืืึท-ืกืืืจืืืื ืข ืคึผืจืึทืกืขืกืึทื ืืืขืงืืึธืจืก, ืึธืืขืจ, ืืขืจ ืจืืืืืง, ืืฉืจืึธืืึธืกืึธืืื.
ืืื ืืืึธืก, ืืืึธืก ืืื ืืขืจืกื ืืืืืืืง ืคึฟืึทืจ ืืื ืื, ืืื ืื ืกืขืืขืงืฆืืข ืคืื โโืืฉืจืึธืืึธืกืึธืืื ืืื ืืขื ืขืก ืคึฟืึทืจ ืืืึธืก ืื ืืืืืืงืืึทื ืคึฟืื ืงืฆืืข ืืจืืื ืืจืืืก ืืืึทืืืขืก.
ืืึธืก, ืืื ืขืกืึทื ืก, ืืื ืืขืจ ืคึผืจืึธืฆืขืก ืคืื ืืืื ืคึฟืึทืจ ืื ืึธืคึผืืืืึทื ืืึทื ื ืคืื ืืฉืจืึธืืึธืกืึธืืื ื ืืฆื ืึท ืืืขืงืืึธืจ ืืื ืึท N-ืืืืขื ืฉืึทื ืึทื ืืืื ืคึผืืึทืฅ.
ืืืืขืจ ืงืืึธืจ, ืืืืืืื
ืืื ืืืื ืืืืื ืืขืจ ืืืืขืจืงื ืฆืืืื ืืขืื ืืฉืข ืคืื ืงืื.
ืึทืืืืืืขืจื ืจืืคื ืคืื ืื ืคึฟืื ืงืฆืืข evaluate
, ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืืึทืืื-ืึธื ืืืื, ืืึทืฉืืขืืืงื ืื ืืืขืจื ืคืื ืื ืกืืื ืคึผืึทืจืึทืืขืืขืจ, ืืขื ืขื ืืขืืื ืืืืืจื ืืืืฃ cran-r
ืคืึทื ืืงืฉืึทื ื system2
ืืื ืืขืจ ืืืืฃ ืคืื ืืืึธืก: ืขืืืขืืข ืืึทืฉ ืฉืจืืคื ืึธืืขืจ ืืึทืคึฟืขื ืืื ืืขืจืืคื.
ืคึฟืึทืจ ืืืึทืฉืคึผืื:
set_db_parameter
set_db_parameter=function(p1, p2) {
v_module="set_db_parameter"
v_cmd="/home/oracle/testingredotracะต/set_db_parameter.sh"
v_args=paste(p1," ",p2,sep="")
x=system2(v_cmd, args=v_args, stdout=T, stderr=T, wait=T)
if ( length(attributes(x)) > 0 ) {
cat(paste(v_module," failed with: ",attributes(x)$status," ",v_cmd," ",v_args,sep=""), file=v_logfile, sep="n", append=T)
return (attributes(x)$status)
}
else {
cat(paste(v_module," ok: ",v_cmd," ",v_args,sep=""), file=v_logfile, sep="n", append=T)
return (0)
}
}
ืื ืฆืืืืืืข ืคืื ื ืืื ืื ืฉืืจื, evaluate
ืคืึทื ืืงืฉืึทื ื, ืืื ืฉืคึผืึธืจื ืึท ืกืคึผืขืฆืืคืืฉ ืืขืืจืืง ืืืขืจื ืืื ืืืื ืงืึธืจืึทืกืคึผืึทื ืืื ื ืืื ืื ื ืืืขืงืืึธืจ ืฆื ืึท ืงืืึธืฅ ืืขืงืข:
cat( paste("result: ",v_metric," ",v_vector,sep="") , file=v_logfile, sep="n", append=T)
ืืึธืก ืืื ืืืืืืืง, ืืืืึทื ืคึฟืื ืืขื ืืึทืื ืืขื ืืข, ืขืก ืืืขื ืืืื ืืขืืืขื ืฆื ืืึทืงืืืขื ื ืึธื ืืื ืคึฟืึธืจืืึทืฆืืข ืืืขืื ืืืึธืก ืคืื ืื ืงืึทืืคึผืึธืื ืึทื ืฅ ืคืื ืื ืืื ืื ื ืืืขืงืืึธืจ ืืื ืึท ืืจืขืกืขืจืข ืึธืืขืจ ืืืืื ืืงืขืจ ืืืืจืงืื ื ืืืืฃ ืื ืืขืืจืืง ืืืขืจื.
ืึทื ืืื: ืขืก ืืืขื ืืืื ืืขืืืขื ืฆื ืืืจืืคืืจื ืึทืืจืืืืื-ืืืคึผืึธืจืืึทืืกืข ืึทื ืึทืืืกืืก.
ืึทืืื ืืืึธืก ืงืขื ืคึผืึทืกืืจื?
ืืื ืืจืึทืคืืง ืคืึธืจืขื, ืืืื ืืืจ ืกืืจ ืื ืืขืกืฅ ืืื ืึทืกืขื ืืื ื ืืขืืจืืง ืกืืจ, ืื ืืืื ืืื ืืื ืืืื:
ืขืืืขืืข ืืึทืื ืงืึธืจืึทืกืคึผืึทื ืืื ื ืฆื ืื ืขืงืกืืจืขื ืืืึทืืืขืก ืคืื ืื ืืขืืจืืง:
ืืึธ, ืืื ืื ืกืงืจืขืขื ืฉืึธื ืืื ืื ืจืขืืืืืึทืื, ืืื ืืืขื ืืขืจืงืืขืจื: ืื ืืืึทืืืขืก ืคืื ืื ืืื ืื ื ืืืขืงืืึธืจ ืืขื ืขื ืืขืืขืื ืืื ืืขืจืืื ืขื ืคืื ืื ืืืืืืงืืื ืคืื ืงืฆืืข ืงืึธื, ื ืืฉื ืืื ืืขืจืืื ืขื ืคืื ืื ื ืืืขืจ ืจืฉืืื ืคืื ืคึผืึทืจืึทืืขืืขืจืก / ืจืืื ืืืฉืึทื ืคืื ืคึผืึทืจืึทืืขืืขืจ ืืืึทืืืขืก, ืืืึธืก ืืื ืืขืืืขื ืคืืจืืืืืจื ืืืืื ืืื ืืขื ืืขืงืกื.
ื ื. ืืื ืขืก ืึท ืคึผืืึทืฅ ืึธืืขืจ ืึท ืืืกื, ~ 8 ืืืืื ื ืืคึผืก: ืึท ืืึทืืื ืืขืจ ืงืฉืื.
ืืื ืื ืคืจืืืืืืขืจืง ืคืื ืืึทืืึธืจืึทืืึธืจืืข ืึทืจืืขื, ืืขื ืคืืืืจ ืืื ื ืืฉื ืืืืืืืง, ืืืึธืก ืืื ืืืืืืืง ืืื ืื ืืื ืึทืืืง, ืืื ืื ืืืขืจื ืขื ืืขืจืื ืืขื.
ืื ืืื ืึทืืืง ืืึธ ืืื ืืื.
ืขืก ืืื ืงืืึธืจ ืืื ืืขืจ ืืึธื ืึทื ืืืึท ืืื ืืกืืขืจ ืืืื ืคืึทืงืืึธืจ ืืืืืืืืง ืื ืคืืืึทื ืกืื ืื ืืืขืจื ืคืื ืื ืืขืืจืืง, ืื ืืึท-ืึทืืืขืจืืืึทื, ืกืึธืจืืื ื ืืืจื ืื ืืจืึธืืึธืกืึธื ืืืขืงืืึธืจืก: ืืืืขืงื.
ืืืื ืืฉืคืื ืืืจื ืื ืคืขืจืื ืงืจืึทืคืืืง ืืื ืึทืืืง ืคืื ืื ืืืกืืืื ืืืึทืืืขืก, ืขืก ืืื ืืืึท ืืื ืืกืืขืจ ืืืื ืขืจ ืืขืจ ืคืึทืงืืึธืจ ืืืึธืก, ืืึธืืฉ ืืืืืืืืง ืงืืขื ืขืจืขืจ, โโโโืืื ืึท ืืฉืคึผืขื.
ืืืก ืืื ืืื ืืืจ ืืึทืจืคึฟื ืขืก attribute-importance
ืึทื ืึทืืืกืืก ืฆื ืคึฟืึทืจืฉืืืื ืืืึธืก ืึทืืจืืืืืฅ (ื ื, ืืื ืืขื ืคืึทื, ืงืึทืืคึผืึธืื ืึทื ืฅ ืคืื ืื ืืื ืื ื ืืืขืงืืึธืจ) ืืื ืืื ืคืื ืืื ืืฉืคึผืขื ืืืืฃ ืื ืืขืืจืืง ืืืขืจื.
ืืื ืคึฟืื ืืขื ืืื ืคึฟืึธืจืืึทืฆืืข: ืคึฟืึทืจืฉืืืื ืืืึธืก ืกืืืืช ืืขื ืขื ืึทืคืขืงืืึทื ืืืจื ืขื ืืขืจืื ืืขื ืืื ืืึทืืืึทืืืง ืึทืืจืืืืืฅ.
ืืืืฃ attribute-importance
ืงืขื ืขื ืืืื ืืื ืคืืืข ืืืขืื.
ืคึฟืึทืจ ืื ืฆืืืขืงื, ืืื ืืื ืื ืึทืืืขืจืืืึทื randomForest
R ืคึผืขืงื ืืื ืื ืืขืืืข ื ืึธืืขื (
randomForest
, ืืื ืืื ืคืืจืฉืืื ืืืื ืืืขืจืง ืืื ืึทืืืขืืืื ืืื ืืืื ืฆืืืึทื ื ืฆื ืึทืกืกืขืกืก ืื ืืืืืืืงืืื ืคืื ืึทืืจืืืืืฅ ืืื ืืึทืืื ืืขืจ, ืืืืขื ืึท ืืืืขืจ ืืึธืืขื ืคืื ืื ืึธืคืขื ืืืงืืึทื ืคืื ืื ืขื ืืคืขืจ ืืืึทืืขืืืืืง ืืืืฃ ืื ืึทืืจืืืืืฅ.
ืืื ืืื ืืืขืจ ืคืึทื, ืืขืจ ืขื ืืคืขืจ ืืืึทืืขืืืืืง ืืื ืึท ืืขืืจืืง ืืืงืืืขื ืคืื ืื ืืึทืืึทืืืืก ืืื ืืึทืกืข ืืขืกืฅ: tps
;
ืืื ืึทืืจืืืืืฅ ืืขื ืขื ืงืึทืืคึผืึธืื ืึทื ืฅ ืคืื ืื ืืื ืื ื ืืืขืงืืึธืจ.
ืึทืืื randomForest
ืืืืึทืืืืืืฅ ืื ืืืืืืืงืืื ืคืื ืืขืืขืจ ืืึธืืขื ืึทืืจืืืืื ืืื ืฆืืืื ื ืืืขืจื: %IncMSE
- ืืื ืื ืืืึทืืืึทื / ืึทืืืขืง ืคืื ืืขื ืึทืืจืืืืื ืืื ืึท ืืึธืืขื ืขื ืืขืจืื ืืขื ืื MSE ืงืืืึทืืืืขื ืคืื ืืขื ืืึธืืขื (ืืขืึทื ืกืงืืืึทืจืขื ืืขืืช);
ืืื IncNodePurity ืืื ืึท ื ืืืขืจ ืืืึธืก ืจืืคืืขืงืก ืืื ืืขืืื ื, ืืืืืจื ืืืืฃ ืื ืืืึทืืืขืก ืคืื ืืขื ืึทืืจืืืืื, ืึท ืืึทืืึทืกืขื ืืื ืึทืืืขืจืืืืืฉืึทื ื ืงืขื ืขื ืืืื ืฆืขืืืืื, ืึทืืื ืึทื ืืื ืืืื ืืืื ืขืก ืืขื ืขื ืืึทืื ืืื ืืืื ืืืขืจื ืคืื ืื ืืขืืจืืง ืืืึธืก ืืื ืืขืจืงืืขืจื, ืืื ืืื ืื ืื ืืขืจืข ืืื. ืื ืื ืืขืจ ืืืขืจื ืคืื ืื ืืขืืจืืง.
ื ื, ืืึธืก ืืื: ืืื ืืืึธืก ืืึธืก ืืื ืืึธืก ืึท ืงืืึทืกืึทืคืืืื ื ืึทืืจืืืืื (ืืื ืืึธื ืืขืืขื ืื ืืขืจืกื ืงืืึธืจ, ืจืืกืืฉ-ืฉืคึผืจืึทื ืืขืจืงืืขืจืื ื ืืืืฃ RandomForest
ืึทืจืืขืืขืจ-ืคึผืืืขืจ ืจ-ืงืึธื ืคึฟืึทืจ ืคึผืจืึทืกืขืกืื ื ืึท ืืึทืืึทืกืขื ืืื ืื ืจืขืืืืืึทืื ืคืื ืืึทืกืข ืืขืกืฅ:
x=NULL
v_data_file=paste('/tmp/data1.dat',sep="")
x=read.table(v_data_file, header = TRUE, sep = ";", dec=",", quote = ""'", stringsAsFactors=FALSE)
colnames(x)=c('metric','rgsize','rgcount','lamp','cmtl','cmtw','lgbffr','lct','dbwrp','undo_retention','tprs','disk_async_io','filesystemio_options','db_block_checking','db_block_checksum')
idxTrain=sample(nrow(x),as.integer(nrow(x)*0.7))
idxNotTrain=which(! 1:nrow(x) %in% idxTrain )
TrainDS=x[idxTrain,]
ValidateDS=x[idxNotTrain,]
library(randomForest)
#mtry=as.integer( sqrt(dim(x)[2]-1) )
rf=randomForest(metric ~ ., data=TrainDS, ntree=40, mtry=3, replace=T, nodesize=2, importance=T, do.trace=10, localImp=F)
ValidateDS$predicted=predict(rf, newdata=ValidateDS[,colnames(ValidateDS)!="metric"], type="response")
sum((ValidateDS$metric-ValidateDS$predicted)^2)
rf$importance
ืืืจ ืงืขื ืขื ืืืืื ืืืืกืงืืืึทืื ืื ืืืืคึผืขืจืคึผืึทืจืึทืืึทืืขืจื ืคืื ืื ืึทืืืขืจืืืึทื ืืื ืืืื ืืขื ื ืืื, ืคืึธืืงืืกืื ื ืืืืฃ ืื ืงืืืึทืืืืขื ืคืื ืื ืืึธืืขื, ืืืืกืงืืืึทืื ืึท ืืึธืืขื ืืืึธืก ืืขืจ ืึทืงืืขืจืึทืืื ืคืืืคืืื ืื ืคึฟืึธืจืืืกืืึธืื ืืืืฃ ืื ืืืึทืืึทืืืืฉืึทื ืืึทืืึทืกืขื.
ืืืจ ืงืขื ืขื ืฉืจืืึทืื ืึท ืืื ืคืื ืคืื ืงืฆืืข ืคึฟืึทืจ ืืขื ืึทืจืืขื (ืืื, ืืืืืขืจ, ื ืืฆื ืึท ืืื ืคืื ืึทืคึผืืึทืืึทืืืืฉืึทื ืึทืืืขืจืืืึทื).
ืืืจ ืงืขื ืขื ื ืืฆื R ืคึผืขืงื caret
, ื ืื ืื ืคืื ื ืืื ืืืืืืืง.
ืืื ืึท ืจืขืืืืืึทื, ืืื ืืขื ืคืึทื, ืื ืคืืืืขื ืืข ืจืขืืืืืึทื ืืื ืืืงืืืขื ืฆื ืึทืกืกืขืกืก ืื ืืจืึทื ืคืื ืืืืืืืงืืื ืคืื ืื ืึทืืจืืืืืฅ:
ื ื. ืืืื, ืืืจ ืงืขื ืขื ืึธื ืืืืื ืืืืืืืข ืึธืคึผืฉืคึผืืืืื ื:
- ืขืก ืืืจื ืก ืืืืก ืึทื ืื ืืขืจืกื ืืึทืืืึทืืืง, ืืื ืืขืจ ืื ืืขืกืืื ื ืื ืึธืื, ืืื ืืขืืืขื ืืขืจ ืคึผืึทืจืึทืืขืืขืจ
commit_wait
ืืขืงื ืืงืื, ืขืก ืกืคึผืขืฆืืคืืฆืืจื ืื ืืืจืืคืืจืื ื ืืึธืืข ืคืื โโืื ืืึธ ืึธืคึผืขืจืึทืฆืืข ืคืื โโืฉืจืืืื ืจืขืืึธ ืืึทืื ืคึฟืื ืื ืกืืืื ืงืืึธืฅ ืืึทืคืขืจ ืฆื ืื ืงืจืึทื ื ืงืืึธืฅ ืืจืืคึผืข: ืกืื ืืฉืจืึธื ืึธืืก ืึธืืขืจ ืืืกืื ืืงืจืึทื ืึทืก.
ืืืขืจืnowait
ืืืึธืก ืจืืืึทืืืื ืืื ืึท ืึผืืขื ืืืขืจืืืงืึทื, ืงืืืคื ืคืึทืจืืจืขืกืขืจื ืืื ืื ืืืขืจื ืคืื ืื ืืคึผืก ืืขืืจืืง: ืืึธืก ืืื ืื ืื ืงืืืืฉืึทื ืคืื ืื ืืืกืื ืืงืจืึทื ืึทืก ืืึธ ืืึธืืข ืืื ืจืขืืึธ ืืจืืคึผืขืก.
ื ืืึทืืื ืืขืจ ืงืฉืื ืืื ืฆื ืืืจ ืืึธื ืืึธื ืืึธืก ืืื ืึท ืขืกื ืืืึทืจื ืืึทืืึทืืืืก ืึธืืขืจ ื ืืฉื. ืืึธ ืืื ืืึทืืจืขื ืขืฆื ืืื ืฆื ื ืึธืจ ืกืืืืืื ื: ืืึธืก ืืื ืึท ืืึทืืืืืืง ืคืึทืงืืึธืจ. - ืขืก ืืื ืืึทืืืฉืืงืึทื ืึทื ืื ืืจืืืก ืคืื ืื ืงืืึธืฅ ืืึทืคืขืจ ืคืื ืื ืกืืื: ืืืจื ืก ืืืืก ืฆื ืืืื ืึท ืืึทืืืืืืง ืคืึทืงืืึธืจ.
ืื ืงืืขื ืขืจืขืจ ืื ืืจืืืก ืคืื ืืขื ืงืืึธืฅ ืืึทืคืขืจ, ืื ืืืืื ืืงืขืจ ืืืึทื ืืึทืคืขืจืื ื ืงืึทืคึผืึทืฆืืืขื, ืื ืืขืจ ืึธืคื ืขืก ืึธืืืืขืจืคืืึธืื ืืื / ืึธืืขืจ ืื ืื ืึทืืืืืื ืฆื ืึทืืึทืงืืื ืึท ืคืจืื ืืขืื ื ืืื ืขืก ืคึฟืึทืจ ืึท ืืืื ืคืื ื ืืึท ืจืขืืึธืงืก ืืึทืื.
ืืขื ืืืื: ืืืืืื ืคืืจืืื ืื ืืื ืึทืืึทืงืืืืื ื ืคึผืืึทืฅ ืืื ืื ืงืืึธืฅ ืืึทืคืขืจ ืืื / ืึธืืขืจ ืืึทืืคึผืื ื ืจืขืืึธ ืืึทืื ืคึฟืื ืขืก ืืื ืจืขืืึธ ืืจืืคึผืขืก.
ืื ืืืืืื, ืคืื ืงืืจืก, ืืึธื ืืื ืืึธื ืืืืจืงื ืื ืืจืืคึผืื ืคืื ืื ืืึทืืึทืืืืก ืคึฟืึทืจ ืืจืึทื ืืึทืงืฉืึทื ื. - ืคึผืึทืจืึทืืขืืขืจ
db_block_checksum
: ื ื, ืืืื, ืืื ืึทืืืขืืืื, ืขืก ืืื ืงืืึธืจ - ืืจืึทื ืกืึทืงืืืึธื ืคึผืจืึทืกืขืกืื ื ืคืืจื ืฆื ืื ืคืึธืจืืืจืื ื ืคืื ืืึทืจื ืืืึทืงืก ืืื ืื ืืึทืคืขืจ ืงืึทืฉ ืคืื ืื ืกืึทืืืึทืืึทืืืืก.
ืืืึธืก, ืืืขื ืงืึธื ืืจืึธืืืจืื ื ืืฉืขืงืกืึทืื ืคืื ืืึทืืึทืืืึธืงืงืก ืืื ืขื ืืืืึทืื, ืื ืืึทืืึทืืืืก ืืืื ืคึผืจืึธืฆืขืก - ืจืขืืขื ืขื ืื ืืฉืขืงืกืึทืื ืคืื ืื ืืืฃ ืคืื ืื ืืึทืืึทืืืึธืงืง, ืงืึธื ืืจืึธืืืจื ืืื ืืื ืืืึธืก ืืื ืืขืฉืจืืื ืืื ืื ืืึทืืึทืืืึธืงืง ืืขืืขืจ: ืฉืืืขืืขืืขื / ืืึธื ื ืื ืืืืึทืื.
ืึทืืึท ืึทืจืืขื, ืืืืืขืจ, ืงืขื ืขื ื ืื ื ืึธืจ ืคืึทืจืืึทืืื ืื ืคึผืจืึทืกืขืกืื ื ืคืื ืืึทืื, ืืื ืึทืงืึธืจืืื ืืื, ืืขืจ ืคึผืึทืจืึทืืขืืขืจ ืืื ืื ืืขืงืึทื ืืืึทื ืืืึธืก ืฉืืขืื ืืขื ืคึผืึทืจืึทืืขืืขืจ ืืขื ืขื ืืึทืืืึทืืืง.
ืึทื ืก ืืืึธืก ืืขืจ ืคืึทืจืงืืืคืขืจ ืึธืคืคืขืจืก ืืื ืื ืืึทืงืืืืขื ืืืืฉืึทื ืคึฟืึทืจ ืืขื ืคึผืึทืจืึทืืขืืขืจ ืคืึทืจืฉืืืขื ืข ืืืึทืืืขืก ืคึฟืึทืจ ืืื (ืืขืจ ืคึผืึทืจืึทืืขืืขืจ) ืืื ืืขืจืืช ืึทื ืืึธ, ืขืก ืืืขื ืืืื ืึท ืคึผืจืึทื, ืึธืืขืจ, ื ื, ืืืจ ืงืขื ืขื ืงืืืึทืื ืคืึทืจืฉืืืขื ืข ืืืึทืืืขืก, ืึทืจืืืฃ ืฆื "ืึทืืืขืง" ืืื ืคืึทืจืฉืืืขื ืข ืืืคึผืึทืงืฅ.
ื ื, ืึท ืืืืืืืข ืืกืงื ื.
ืืขืจ ืฆืืืึทื ื, ืืื ืึทืืืขืืืื, ืืืจื ืก ืืืืก ืฆื ืืืื ืืึทื ืฅ ืืจืืขืื.
ืขืจ ืืึทื ืฅ ืึทืืึทืื ืืื, ืืื ืื ืคืจื ืกืืึทืืขืก ืคืื ืืึทืกืข ืืขืกืืื ื ืคืื ืึท ืืืืขืจ ืืื ืกื ืกืืกืืขื, ืฆื ืืืืกืงืืืึทืื ืืืึทื (ืกืืกืืขื) ืึธืคึผืืืืึทื ืงืึทื ืคืืืืขืจืืืฉืึทื ืคึฟืึทืจ ืื ืืึทืกืข, ื ืืฉื ืฆื ืืขืืื ืฆื ืคืื ืืื ืื ืกืคึผืขืกืืคืืงืก ืคืื ืืึทืฉืืขืืืงื ืื ืกืืกืืขื ืคึฟืึทืจ ืื ืืึทืกืข.
ืืืขืจ ืขืก ืืื ื ืืฉื ืืืกืฉืืืกื ืขืก ืืึธืจ - ืืื ืืื ืืกืืขืจ ืืื ืืขืจ ืืืจืื ืคืื ืคืืจืฉืืื ื: ืื ืกืืกืืขื ืืืื ืืืื ืืึทืืืืกื ืืืขืื ืื "ืึทืืืฉืึทืกืืืึทื ื ื ืึทืื" ืืื ืื ืขืจืืืืื ืจืืื ืืืฉืึทื ืคืื ืจืึธืืืืืฉืึทื ืคืื ืื ื ืึทืื.
ืืขืจ ืฆืืืึทื ื ืงืขื ืขื ืืขืจืืืขืจ ืืขืคืืขืจืขื ืืขืฉืืืื ื ืืขืคึฟืื ืขื ืื ืึธืคึผืืืืึทื ืกืืกืืขื ืงืึทื ืคืืืืขืจืืืฉืึทื.
ืืื ืืืืืจื ืืืืฃ ืื ืจืขืืืืืึทืื ืคืื ืืขืกืืื ื, ืขืก ืืื ืืขืืืขื ืฆื ืืึทืงืืืขื ืืื ืคึฟืึธืจืืึทืฆืืข ืืืขืื ืื ื ืึทืืืจ ืคืื ืื ืฉืืืืืช ืฆืืืืฉื ืื ืกืืกืืขื ืคืึธืจืฉืืขืืื ื ืืขืืจืืงืก ืืื ืื ืืืึทืืืขืก ืคืื ืื ืคึผืึทืจืึทืืขืืขืจืก ืคืื ืื ืกืืกืืขื ืกืขืืืื ืืก.
ืืืึธืก, ืคืื ืงืืจืก, ืืึธื ืืืืฉืืืืขืจื ืฆื ืื ืืืขืจืืืฉืึทื ืก ืคืื ืืขื ืืืืขืจ ืืืฃ ืคืืจืฉืืื ื ืคืื ืื ืกืืกืืขื, ืืืึทื ืึธืคึผืขืจืึทืฆืืข, ืืคึผืืืช ืืื ืืขืจ ืึท ืืขืืขืื ืืึทืกืข.
ืืื ืคืืจ, ืืึธืก ืืื ืึท ืืืขืงืกื ืคืื ืื ืงืึธืก ืคืื ืคืืจืฉืืื ื ืื ืงืึทืกืืึทืืืืื ืกืืกืืขื ืคึฟืึทืจ ืื ืงืึธืก ืคืื ืคึผืจืืคึผืขืจืื ื ืึทืืึท ืืขืกืืื ื ืคืื ืื ืกืืกืืขื.
ืืื ืืืึธืื ืืื ืฆื ืืึธื ืกืขืคึผืขืจืึทืืื: ืืื ืืขื ืฆืืืึทื ื, ืืขืจ ืืจืึทื ืคืื ืึทืืึทืงืืืึทืกื ืคืื ืกืืกืืขื ืืขืกืืื ื ืฆื ืื ืึทืคึผืขืจืืืืื ื ืื ืึธืื ืืืึธืก ืขืก ืืืขื ืืึธืื ืืื ืืขืฉืขืคื ืึธืคึผืขืจืึทืฆืืข ืืื ืงืจืืืืฉ ืืืืืืืง.
ืืื ืง ืืืจ ืคึฟืึทืจ ืืืื ืืคืืขืจืงืืึทืืงืืึทื ืืื ืฆืืื.
ืืงืืจ: www.habr.com