ืฉืืื
ืืืืืชื ืืฉืชืฃ ืืืืฆื ืฉืื - ืคืจื ืืืฉืื, ื ืืกืื ืืืขืืื.
ืืืืื: ืื ืื ืืืฆื ืืืืื - ืื ืื ืืื ืฆืจืื ืืืืืช ืืืืข ืืืื, ืืื ืฉืขืืกืง ืืขืืืื ื ืชืื ืื ืกืืืืกืืืื ืืืฉืืื ืืืืคืืืืืืฆืื ืฉื ืืขืจืืืช ืืืฉืื, ืืื ืืืืงื ื-DBMS.
ืืื: ืื, ืื ืืืืขืื, ืื ืืืชืืื ืืืืจืื ืืขื ืืื ืื ืขื ืืืืงืจ ืฉืืื,
ืืฆื ืฉื ื: ืืฉืจ ืื ื ืื ืจืืื ืืืืืืจ ืื ืืคืฆื ื ืจืืืช ืฉื ืืืฉื ืื ืืืื ืืจื ื ืืงืจื ืืืืื IT, DBA.
ืื, ืืขื ืืื.
ืืื ื ื ืื ืฉืืฉ ืื ื ืืฉืืื: ืืืงืื ืืขืจืืช ืฉืืจืืช ืืกืืืืช ืฉืชืฉืจืช ืกืื ืฉื ืขืืืื.
ืืืืข ืขื ืขืืืื ืื: ืืื, ืืื ื ืืืืช ืืืืืช ืืขืืืื ืืื ืืืื ืืงืจืืืจืืื ืืืืืืช ืืืืืช ืื.
ืืืื ืื ื ื ืื ืฉืื ืคืืืช ืื ืืืชืจ ืืืืข ืืืืื: ืืื ืืืืืง ืืชืืฆืขืช ืืขืืืื ืืืขืจืืช ืืฉืืจืืช ืืื (ืื ืขื).
"ืคืืืช ืื ืืืชืจ" - ืื ืืืืจ ืฉืืคืฉืจ ืืืืื (ืื ืืืฉืื ืืืชื ืืืืคืฉืื) ืืื ืืกืืื, ืฉืืจืืช, ืฉืืจืืช ืฉื ืืชื ืืกื ืชื ืืืืืื ืขื ืืืขืจืืช ืขื ืขืืืก ืืืืงื ืืกืคืืง ืืชืืื ืืื ืฉืืืื ืืืืฆืืจ, ืืชื ืืื ืืกืคืืงืื ืืขืืืื ืืืืฆืืจ.
ืืืื, ื ื ืื ืฉืืืืข ืงืืืฆื ืฉื ืคืจืืืจื ืืชืืื ืขืืืจ ืืขืจืืช ืฉืืจืืช ืื, ืืฉืจ ื ืืชื ืืืฉืชืืฉ ืืื ืืื ืืืืืืจ ืืขืจืืช ืื ืืืืื ืช ืืคืจืืืืงืืืืืืช ืฉื ืขืืืืชื.
ืืื ืืืขืื - ืืื ืืื ื ืืืื ืืกืคืืง ืฉื ืืขืจืืช ืืฉืืจืืช ืืื, ืืื ืฉืืืคืฉืจืช ืื ืืืืืืจ ืืืืืืืืช ืืช ืืืืืจืืช ืฉื ืืขืจืืช ืื ืืขืืืก ืขืชืืื ืขื ืคืืืคืืจืื ื ืชืื ื ืืืงืื ืืช ืืคืจืืืืงืืืืืืช ืื ืืจืฉืช ืฉื ืืืขืจืืช.
ื ื. ืื ืืืขื ืชืืื ืืืฆื.
ืื ืืชื ืืืื ืืขืฉืืช ืืื?
ืืืื, ืืืืจ ืืจืืฉืื ืฉืขืืื ืืจืืฉ ืืื ืืืกืชืื ืขื ืืชืืขืื ืฉื ืืืขืจืืช ืืื. ืืื ืืื ืืืืืืื ืืืงืืืืื ืขืืืจ ืืขืจืืื ืฉื ืคืจืืืจื ืืืชืืื. ืืืืืืื, ืืืืฆืขืืช ืฉืืืช ืืืจืืื ืืงืืืืจืืื ืืืช, ืืืจ ืขืจืืื ืขืืืจ ืคืจืืืจื ืืขืจืืช ืืืืืงืืช.
ืึธืึตื. ืชื ืืืขืจืืช ืืืืืฉืื ืชืฆืืจื, ืืฆืืจื ืฉื ืกื ืกืคืฆืืคื ืฉื ืขืจืืื ืขืืืจ ืคืจืืืจื ืืชืฆืืจื ืฉืื.
ืืคืขื ืขืืื ืขืืืก ืืืืงื, ืืืืฆืขืืช ืืืืื ืขืืืกืื ืื ืืืฉ ืืื-ืขืืจ.
ืืชืจืื ืืช ืืขืจื - ืืชืืืื, ืื ืืื ืฉื ืืืืืช ืืืขืจืืช.
ืืืืฉืื ืืฉื ืืื ืขืฉืืื ืืืืืช ืืืกืงื ื ืฉืืืืืจ ืืืื ืืจืื ืืืื.
ืืืื, ืืืืืจ: ืื ืืฉ ืืจืื ืคืจืืืจื ืืืืจื, ืื ืืืืื ืืขืจืืื ืฉืืื ืืืืคืขืืื ืืืืืื, ืื ืื ืืืืงืช ืขืืืก ืืืืืช ืืืงืืช ืืจืื ืืื ืืืฉืืื, ืื: ืื, ืื ืื ืขืฉืื ืืงืืช ืืื ืืืชื ืืชืงืื ืขื ืืืขืช ืืจืื ืืื.
ืืืื, ืื ื ืื ืฉืืชื ืืืื ืืืืื ืืืืืืจ.
ืืชื ืืืื ืืืืืช ืฉืืงืืืฆืช ืืขืจืืื ืฉื ืคืจืืืจื ืืืืจืืช ืืขืจืืช ืืฉืืจืืช ืืฉ ืืงืืืจ, ืืจืฆืฃ ืฉื ืืื ืขืจืืื.
ืื ืืงืืืจ ืืื, ืืืืืชื ืืืจืื ืฉืืืื (ืืื ืฉืืื ืืื ื ืืืฉืคืข ืืืืงืืืจ ืื), ืืชืืื ืืขืจื ืืืจื ืืืืืจ ืืืืืืื - ืืื ืืืงืืืจ ืืืืืืช ืคืขืืืช ืืืขืจืืช ืืขืืืก ืืืืงื.
ืืืืืจ
ืืื ื ืกืื ืืช ืืงืืืจ ืชืฆืืจืช ืืืขืจืืช ืืชืืจ ืืืคื ; ืืืคื - ืืกืคืจ ืคืจืืืจืื ืฉื ืชืฆืืจืช ืืืขืจืืช, ืืื ืืืคืจืืืจืื ืืืื ืืฉ.
ืืขืจื ืืืื ืืืงืืื ืืื ืืืื ื ืกืื ืืช ืื ืืชืืจ
, ืื ื ืงืื ืคืื ืงืฆืื:
ืืืื, ืื ืื: ืืื ืืกืชืื ืืื, ืืืงืจื ืฉืื: ืืืขื ื ืฉืื ืืืื ืืกืืืื ืืื ืฉืื, ืืืืืจืืชืืื ืืืืคืืฉ ืืงืืฆืื ืฉื ืคืื ืงืฆืื.
ืืืงืื, ืืื ืืื ืขืืื ืฉืืื ืืจืืื ืืช ืืืืฉืืืืช: ืืืืื ืืืืืจืืชื ืืืฉืชืืฉ.
- ืืืืื - ืืื ืฉืชืืืื ืืงืืื ืคืืืช ืืื.
- ืืืื ืฉืื ืืขืืื, ืืืืืจ. ืืฆื ืืช ืืงืืฆืื (ืื ืืฉ ืืื), ืืืื, ืืคืืืช ืืืจ ืืืชืจ ืืืจืืื ืืงืืืืจืืื ืืืช.
ืื ืงืืื ืืจืืฉืื ื ืืจืืืช ืฉืื ืื ื ืฆืจืืืื ืืืกืชืื ืืขืืจ ืืื ืกืืืืืช ืฉืืื ืืืืืจืืชืืื ืืืื ืืืจ ืืืฉืื, ืืื, ืืฆืืจื ืืืฉืื, ืืืื ืืช ืืฉืืืืฉ ืืงืื.
ืืืื ืื ื ืืืืข python
ะธ cran-r
ืื ืงืืื ืืฉื ืืื ืคืืจืืฉื ืฉืขืืื ืืงืจืื ืขื ืืืืืืจืืชืืื ืขืฆืื, ืื ืื, ืื ืืืจืืฉืืช ืฉืืื, ืชืืื ืืช ืืขืืืื ืฉืืื.
ืืื ืฉืื ื ืืชื ืื ืืืื ืืืืืช ืชืืคืขืืช ืืืืื ืฉืืืืฉืืืช - ืชืืฆืืืช, ืื ืืฉืืจืืช ืืืืืืืจืืชื ืขืฆืื.
ืื ืฉื ืืชื ืืงืื ืืืชื ืืชืืฆืืืช ืืืืืืจืืชื.
ืืจืื ืชืืื ืืชื ืื ืืงืื.
ืืืืืื, ืื, ืืกืืื ืืืฉืื, ืืชื ืฆืจืื ืืงืื ืชืืฆืื ืืืจ ืืืชืจ, ืืืื, ืืชื ืฆืจืื ืืืกืชืื ืืขืืจ ืืืืืจืืชืืื ืฉื ืืจืืื ืืฉืืคืืข ืืืืืืจ ืืื ืืื.
ืื, ืื ืืืื ืื ืื ืื ืืฉืื, ืืชื ืืืื, ืืืฉื, ืืืฉืชืืฉ ืืฉืืืืช ืืืคืืืืืืฆืื ืกืืืืกืืืืช, ืืื ืืืืืจืืชื ืื ืื.
ืื ื ืืฆืืข ืืฉืงืื ืืช ืืขืืืื ืฉื ืืืฉื ืื, ืืืืจืช ืชืฆืืจืช ืืืขืจืืช, ืืืืฆืขืืช ืืืืืจืืชื ืื ืื, ืืขืืืื ืืืื, ืืืืืื: ืขืืืืช ืืขืืื.
ืืชืืืชื:
- ืฉืืืื, ืืืขืจืืช ืฉืืจืืช:
oracle xe 18c
- ืชื ืืื ืืฉืจืช ืืช ืืคืขืืืืช ืืขืกืงืืช ืืืืืจื: ืืืฉืื ืืช ืืชืคืืงื ืืืืืื ืืืืชืจ ืืืคืฉืจืืช ืฉื ืชืช ืืกื ืื ืชืื ืื, ืืขืกืงืืืช/ืฉื ืืืช.
- ืขืกืงืืืช ืืืืืืช ืืืืืช ืฉืื ืืช ืืืื ืืืืคื ืืขืืืื ืขื ื ืชืื ืื ืืืืงืฉืจ ืืขืืืื.
ืืืื ื ืกืืื ืฉืืืืืจ ืืขืกืงืืืช ืฉืืื ื ืืขืืืืช ืืืืช ืืืืื ืฉื ื ืชืื ืื ืืืืืืื.
ืืืืื ืื ืฉืื ืื ืืืืฆืจืื ืืืชืจ ื ืชืื ื ืืืืื ืืืฉืจ ืืขืฉืืช ืืืืฉ ืืื ืืขืืืื ืืืืืื ืืืืืื ืฉื ืฉืืจืืช ืืืืืืืช ืืืืืืช.
ืืืืืจ ืืขืกืงืืืช ืฉืืฉื ืืช ืฉืืจื ืืืช ืืืืื ืืืืื ืคืืืช ืื ืืืชืจ, ืขื ืืกืคืจ ืงืื ืฉื ืืื ืืงืกืื ืืืืื ืื.
ืืืฆื ืื: ืืคืจืืืืงืืืืืืช ืฉื ืชืช ืืกื ืื ืชืื ืื ืืขืืืื ืขืกืงืืืช ืชืืงืืข, ืืืกืชืืืืืช, ืืคื ืืืืืช ืืขืืืื ืฉื ืืกื ืื ืชืื ืื ืืืืืืจ.
ืืชื ืืืชืืจ - ืื ื ืืืจ ืกืคืฆืืคืืช ืขื ืืืืจืืช subdb.
ืืืืืื ืฉืืืงืจื ืืืืื ืืืชืื ื, ืืืฉื, ื ืขืืืืช ืืจื ืืงืฆืืืช ืืื ืืคืขืืืช ืฉื SQL, ืขืงื ืขืืฆืื ืขืืืืช ืืืฉืชืืฉ ืขื ื ืชืื ืื ืืืืืืื ื/ืื ืืืืื ืืืืืื.
ืื ืฉืืืืื ืืฉืคืืข ืืืื ืขื ืืื ื-TPS ืืื ืืืื ืืืจื ืืงืกืืื ื, ืืืกืืช ืืืกืืก ืื ืชืื ืื ืืืฉื ื: ืืืื, ืื ืชืืื ื ืืืืื ืืืืืื ืืืขืืืื ืขื ื ืชืื ืื ืื ืฉืืชืจืืฉืืช ืืกืืืืช.
ืืื, ืืืขื ืืืืจ ืื ืืกืื, ื ืฉืื ืืืจื ืื, ืืืืื ืืืืืจ ืืืฆื ืืืืืง.
- ืืื ื ื ืื, ืืืชืจ ืืืืืื, ืฉ-100% ืืคืงืืืืช ื-SQL ืื ืฉืืืืช ืืืกื ืื ืชืื ืื ืื ืคืงืืืืช DML.
ืชื ืืืืคืืื ื ืืขืืืื ืฉื ืืืฉืชืืฉ ืขื ืชืช-ืืกืืก ืื ืชืื ืื ืืืืืช ืืืื ืืืืืงืืช.
ืืืืืจ: ืืกืคืจ ืืคืืฉื SKL, ื ืชืื ืื ืืืืืืื, ืืืฆื ืืคืืฉื SKL ืขืืืืื ืืืชื. - Subd ืขืืื ื
FORCE LOGGING
,ARCHIVELOG
ืืืคื ืื. ืืฆื Flashback-Datebank ืืืื, ืืจืืช subd. - ืืฆืข ืฉืื ืืืื ื: ืืืืงื ืืืขืจืืช ืงืืฆืื ื ืคืจืืช, ืขื "ืืืกืง" ื ืคืจื;
ืฉืืจ ืืจืืื ืืคืืื ืฉื ืืกื ืื ืชืื ืื: ืืืขืจืืช ืงืืฆืื ืืืจืช, ื ืคืจืืช, ื"ืืืกืง" ื ืคืจื:
ืคืจืืื ื ืืกืคืื ืขื ืืืืฉืืจ ืืคืืื. ืจืืืื ืืกื ื ืชืื ืื ืืืขืืื
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
ืืชืืืื, ืืชื ืื ืืขืืืก ืืืื, ืจืฆืืชื ืืืฉืชืืฉ ืืืจื ืืงืฆืื subd
ืืฉ ืื ืชืืื ื ืื ืื ื ืคืืื, ืื ื ืืฆืื ืืช ืืืืืจ:
ืืืืื ืฉื SLOB ื ืืฆืืช "ืฉืืืช SLOB". ืฉืืืช SLOB ืฉืืืคืช ืืืืื ืคืืืคืืจืืืช
ืืื ืืขื ื ืืืืฉืื. ืื ืืคืฉืจ ืื ืืื ืืืืฆืืขื ืืืืจื ืืงืกืืืืืื
ืืืืฆืขืืช ืงืื ืืืฉืื ืืืืืืจ, ืืืฉื, ืื ืขืืืช ืืืฉืื ืื ืืคืืื
ืฉืืชืืฃ ืืืืงืื ืฉื Oracle Database. ืื ื ืืื - ืืฉ ืชืงืืจื ืืขืช ืฉืืชืืฃ ื ืชืื ืื
ืืืืืง ื ืชืื ืื! ืืื SLOB - ืืคืจืืกืช ืืจืืจืช ืืืืื ืฉืื - ืืกืื ืืคื ื ืืขื ื ืืื.
ืืืืจืื ืืื: ืชืืืืช, ืื ืื.
ืื ื ืื ืืืืกืช ืืช ืืืืช ืืืงืืื ืฉื ืืคืืฉื cl, ืื ืืืคืชื -t
ืืืคืขืื ืืช ืืื ืืฉืืจืืช runit.sh
ื-SLOB
ืืืื ืคืงืืืืช DML ืืืกืืจ, ืืืกืคืจ ืืืืขืืช ืืืงืกื ืื ืฉืืืืช ื-subd, ืื ืกืฉื ืืงืกื, ืคืจืืืจ UPDATE_PCT
ืื ืคืจื ืืืืื ื ืื: SLOB
ืขืฆืื, ืืคื ื ืืืืจื ืกืฉื ืืืขืื ื - ืืืื ืกืืืืกืืืงื, ืื awr-snapshots (ืื ืืืืืจ ืืืืืช ืืืื).
ืขื ืืืช, ืืชืืจืจ ืื SLOB
ืืื ื ืชืืื ืืืคืขืืืช SQL ืืืืจื ืฉื ืคืืืช ื-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"
ืึธืึตื. ืืื ืขืืื (ืืคืืขื: ืกืฉื SQL ื ืคืจื ื-DB) ื ืืฆืจืช ืืืื ื ืคืจืืช, ืืืชื ืขืืื ืืขืืื.
ืื ืืืืื ืืืขืืจ ื ืขืืืืช ืขืกืงืืืช ืืื ืืคืขืืืช ืขืืืืื.
ืื ืขืืื: ืขืืฉื ืืืชื ืืืจ, ืขื ืืฉืืืื ืฉืื, ืืฉืืืื ืืช ืืืื ืืืชื ืืืจ.
ืื ืืขืืืืื ืืืฆืขืื ืขืืืื ืืืฉื ืืืชื ืคืจืง ืืื.
ืืชืจื ืืื, ืืืื ืืกืคืืง ืืจืื ืื ืฉืืืืืื ืืชืจืืฉ, ืืืฉื, ืืขืืจ ืืืื, ืืืืชืจ ืืคืขื ืืืช.
ืืืื, ืืืชืื, ืขืืืืืช ืืืฉืคืขืืช ื ืืืืช.
ืืืงืจื ืฉืื, ืืืืจืชื ืืช ืืฉื ืืขืืืื ืฉื ืืขืืืืื ื-8 ืืงืืช.
ืืืง ืืืื statspack ืืืชืืจ ืืช ืคืขืืืช ื-subd ืชืืช ืขืืืก
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] MB;
- ืืกืคืจ ืงืืืฆืืช ืืืืื ืืืืืจ. ืืืื ืขืจืืื: [2,32];
log_archive_max_processes
ืืืื ืขืจืืื: [1,8];commit_logging
ืฉื ื ืขืจืืื ืืืชืจืื:batch|immediate
;commit_wait
ืฉื ื ืขืจืืื ืืืชืจืื:wait|nowait
;log_buffer
ืืืื ืขืจืืื: [2,128] MB.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
, ืืืืืจ: ืื ืืื ืืคืืืฆืืืช ืขื ืืืขืจืืช ืืืืชืืืช ืืชืืืืจืช ืืฆืืจื ืฉื ืชืกืจืื R.
ืืืฉืืื ืืคืืขื, ื ืืชืื, ืืืืจื ืืคื ืขืจื ืืืจื, ืืงืืืจืื ืฉื ืืฆื ืืขืจืืช: ืื ืืืืื GA
(
ืืืืืื, ืืืงืจื ืื, ืืื ื ืืชืืืื ืืืืืื, ืืืืื ืื ืฉืืื ืืฆืคื ืฉืืืงืืืจืื (ืืจืืืืืืืื, ืื ืืืื ืืื ืฉื ืืืืืื) ืืฆืืื ื ืืฆืืจื ืฉื ืืืจืืืืช ืฉื ืืกืคืจืื ืขื ืืืง ืฉืืจ.
ืืืืืงืืืจ ืฉืื, ืืืขืจืืื ืฉื ืคืจืืืจื ืืืืืจื: ืืื 14 ืืืืืืช - ืืกืคืจืื ืฉืืืื ืืขืจืื ืืืจืืืช.
ืืืขืื, ืืืืื, ื ืื ืขืช ืืงืืืช ืขื ืืื ืืงืฆืืช ืืกืคืจืื ืกืคืฆืืคืืื ืืขืจืื ืืืจืืืช.
ืืคืืื, ืืกืืคื ืฉื ืืืจ, ืืืืง ืืขืืงืจื ืฉื ืืชืกืจืื R ื ืจืื ืื:
ืืชืงืฉืจ ื-GA::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
ืืขืืงืจื ืฉื ืืืจ, ืืฆืืื ืืืืจ ืฉื ืืจืื ืืืืคืืฉ, ืฉืืชืืื ืืืืฆืข ืืืคืืฉ ืขืืืจ ืืงืืืจ (ืื ืืงืืืจืื) ืฉืืืื ืฉืขืืืจื ืืชืงืื ืืขืจื ืืืจืื ืฉื ืคืื ืงืฆืืืช ืืืืฉืจ.
ืชืช-ืืฉืืจื ga ืืืฆืขืช ืืืคืืฉ ืชืื ืืงืกืื ืคืื ืงืฆืืืช ืืืืฉืจ.
ืืืื, ืื ืื, ืืกืชืืจ ืฉืืืงืจื ืื, ืืฉ ืฆืืจื ืฉืคืื ืงืฆืืืช ืืืืฉืจ, ืืื ืช ืืืืงืืืจ ืืืขืจืืช ืฉื ืขืจืืื ืขืืืจ ืคืจืืืจืื ืืกืืืืื ืฉื ื-subd, ืชืงืื ืืื ืื-subd.
ืืืืืจ: ืืื, ืขื ืืืืจืช subd ื ืชืื ื ืืขืืืก ื ืชืื ืขื subd: ื-subd ืืขืื ืืจื ืืงืฆืืืช ืืฉื ืืื.
ืืืืืจ, ืืขืช ืืคืชืืื, ืืฉ ืืืฆืข ืืช ืืฉืื ืืจื ืืื ืืชืื ืคืื ืงืฆืืืช ืืืืฉืจ:
- ืขืืืื ืืงืืืจ ืืงืื ืฉื ืืกืคืจืื - ืืืจืชื ืืขืจืืื ืขืืืจ ืคืจืืืจื ืืืฉื ื.
- ื ืืกืืื ืืืฆืืจ ืืกืคืจ ื ืชืื ืฉื ืงืืืฆืืช ืืืืจืืช ืืืืื ื ืชืื. ืืชืจื ืืื, ืื ืืกืืื ืขืืื ืืืืืฉื.
ืงืืืฆืืช ืืืืื ืื ืฉืืืจ ืืื ืงืืืืืช ืืกื"ื, ืืืืืช ืืกืืืืช ืืืืืื ืืกืืื, ืขื ืืืจืช ืื ืืกืื - ื.ื. ื ืืืง. - ืื ืื ืงืืื ืืงืืืืช ืืฆืืืื: ืฆืืื ืืขืจืืื ืฉื ืคืจืืืจื ืชืฆืืจื ืืืกื ืื ืชืื ืื (ืฉืื: ืืืชืื ืฉืืฉ ืืฉื)
- ืื ืืฉืื ืืงืืื ืืฆืืื: ืขืฆืืจืช ื-subd, ืืชืืืช ื-subd ืื ืฉืขืจืื ืืคืจืืืจืื ืืืืฉืื ืฉืฆืืื ื ืืืื ืกื ืืชืืงืฃ. (ืฉืื: ืืืชืื ืฉืืฉ ืชืงืื)
- ืื ืืฉืื ืืงืืื ืืฆืืื: ืืฆืข ืืืืงืช ืขืืืก. ืงืื ืืืืื ื-subd.
- ืืืืจ ืืช ื-subd ืืืฆืื ืืืงืืจื, ืืืืืจ. ืืืง ืงืืืฆืืช ืืืื ื ืืกืคืืช, ืืืืจ ืืช ืชืฆืืจืช ืืืฉื ื ืืืงืืจืืช ืืขืืืื.
ืงืื ืคืื ืงืฆืืืช ืืืฉืจ
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)
}
ืึถื. ืื ืืขืืืื: ืืืืฆืขืช ืืคืื ืงืฆืืืช ืืืืฉืจ.
ื-ga-subroutine ืืขืืืช ืืงืืืจืื, ืื ืืืชืจ ื ืืื, ืืจืืืืืืืื.
ืฉืืื, ืื ืฉืืื ืืฉืื ืื ื ืืื ืืืืจืช ืืืจืืืืืืืื ืขื ืื ืื ืฉืคืื ืงืฆืืืช ืืืืฉืจ ืืืืฆืจืช ืขืืืจื ืขืจืืื ืืืืืื.
ืืื, ืืืืืชื, ืชืืืื ืืืืคืืฉ ืืืจ ืงืืืฆืช ืืืจืืืืืืืื ืืืืคืืืืืืช ืืืืฆืขืืช ืืงืืืจ ืืืจืื ืืืคืืฉ N-ืืืื.
ืืืื ืืจืืจ, ืืคืืจื
ืื ื ืจืืฆื ืืฆืืื ืื ืคืจื ืฉืชื ื ืงืืืืช ืืื ืืืช.
ืงืจืืืืช ืขืืจ ืืืคืื ืงืฆืื evaluate
, ืืืฉื, stop-start, ืงืืืขืช ืืขืจื ืฉื ืืคืจืืืจ subd, ืืชืืฆืขืื ืขื ืกืื cran-r
ืคืื ืงืฆืืืช system2
ืืขืืจืชื: ื ืงืจื ืืืื ืกืงืจืืคื ืื ืคืงืืื bash.
ืืืืืื:
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 ืืืฃ ืืคืก: ืฉืืื ื ืคืจืืช.
ืืืกืืจืช ืขืืืืช ืืขืืื ืื ืชืื ืืื ืื ืืฉืื, ืื ืฉืืฉืื ืื ืืืื ืืืงื, ืืื ืืขืจื ืืื ืืฉืชื ื.
ืืืื ืืืงื ืืื ืืืื.
ืืจืืจ ืฉืืคืืืช ืืืจื ืืื ืืฉืคืืข ืืืืคื ืืฉืืขืืชื ืขื ืขืจืื ืฉื ืืืื, ืืืืืืจืืชื ื-ga, ืืืืืื ืืช ืืงืืืจื ืืืจืืืืืืืื: ืืืืกื.
ืื ืืฉืคืื ืืคื ืืืื ืืืงื ืื ืืจืฆืช ืืืื ืฉื ืขืจืื ืืขืงืืื, ืืฉ ืืคืืืช ืขืื ืืืจื ืืื ืฉืืืจืืช ืฉืืื ืงืื ืืฉืืขืืชืืช, ืืฉ ืื ืืฉืคืขื.
ืื ืืืงืื ืฉืื ืืชื ืฆืจืื ืืช ืื attribute-importance
ื ืืชืื ืืื ืืืืื ืืืื ืชืืื ืืช (ืืืื, ืืืงืจื ืื, ืจืืืืื ืฉื ืืงืืืจ ืืืืื ืื) ืืขื ืืื ืื ืืฉืคืืขืื ืขื ืืขืจื ืืืืจื.
ืืืืืืืข ืืื: ืืืื ื ืืืื ืืืจืืื ืืืฉืคืขื ืืฉืื ืืืื ืืชืืื ืืช ืืฉืืขืืชืืืช.
ืืคืขืื attribute-importance
ืืคืฉืจื ืืืจืืื ืฉืื ืืช.
ืืืืจืืช ืืื, ืื ื ืืืื ืืช ืืืืืืจืืชื randomForest
ืืืืืช R ืืืืชื ืฉื (
randomForest
, ืืคื ืฉืื ื ืืืื ืืช ืขืืืืชื ืืืืคื ืืืื ืืืช ืืืืฉื ืฉืื ืืืขืจืืช ืืฉืืืืชื ืฉื ืชืืื ืืช ืืคืจื, ืืื ื ืืืื ืืกืืื ืฉื ืืชืืืช ืฉื ืืฉืชื ื ืืชืืืื ืืชืืื ืืช.
ืืืงืจื ืฉืื ื, ืืฉืชื ื ืืชืืืื ืืื ืืื ืืืชืงืื ืืืกื ืื ืชืื ืื ืืืืื ื ืขืืืก: tps
;
ืืชืืื ืืช ืื ืืจืืืืื ืฉื ืืงืืืจ ืืืืื ืื.
ืื randomForest
ืืขืจืื ืืช ืืืฉืืืืช ืฉื ืื ืชืืื ืช ืืืื ืขื ืฉื ื ืืกืคืจืื: %IncMSE
- ืืืฆื ืื ืืืืืช/ืืืขืืจ ืฉื ืชืืื ื ืื ืืืืื ืืฉื ื ืืช ืืืืืช ื-MSE ืฉื ืืืื ืื (ืฉืืืื ืืจืืืืข ืืืืฆืข);
ื- IncNodePurity ืืื ืืกืคืจ ืฉืืฉืงืฃ ืขื ืืื, ืืืชืืกืก ืขื ืืขืจืืื ืฉื ืชืืื ื ืื, ื ืืชื ืืืืง ืืขืจื ื ืชืื ืื ืขื ืชืฆืคืืืช, ืื ืฉืืืืง ืืื ืืฉ ื ืชืื ืื ืขื ืขืจื ืืื ืฉื ืืืื ืฉืืืกืืจ, ืืืืืง ืืฉื ื ืขื ืขืจื ืืืจ ืฉื ืืืื.
ืืืื, ืืืืืจ: ืืืืื ืืืื ืื ืชืืื ื ืืกืืืืช (ืจืืืชื ืืช ืืืกืืจ ืืืจืืจ ืืืืชืจ ืืฉืคื ืืจืืกืืช ื-RandomForest
ืงืื R-ืขืืื-ืืืืจ ืืขืืืื ืืขืจื ื ืชืื ืื ืขื ืชืืฆืืืช ืฉื ืืืื ื ืขืืืก:
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
ืืืืื ื ืืื ืืช, ืืื ืืฆืืื ืืช ืืฆื ืืืืฆืืข ืฉื ืคืขืืืช ื-io ืฉื ืืชืืืช ื ืชืื ื ืืืฆืืข ืืืืฉ ืืืืืจ ืืืืื ืฉื subdb ืืงืืืฆืช ืืืืื ืื ืืืืืช: ืกืื ืืจืื ื ืื ืืกืื ืืจืื ื.
ืขืจืnowait
ืื ืฉืืืื ืืขืืืื ืืืขื ืื ืืืช ืืืจืืื ืืขืจื ืฉื ืืืื tps: ืืื ืืืืืช ืืฆื ื-io ืืืกืื ืืจืื ื ืืงืืืฆืืช redo.
ืฉืืื ื ืคืจืืช ืืื ืืื ืืืื ืืขืฉืืช ืืืช ืืืืืจ ืืืื ืื ืื. ืืื ืื ื ืืืืื ืืช ืขืฆืื ืจืง ืืืฆืืืจ: ืื ืืืจื ืืฉืืขืืชื. - ืื ืืืืื ื ืฉืืืื ืืืืจ ืืืื ืฉื ื-subd: ืืชืืจืจ ืืืืจื ืืฉืืขืืชื.
ืืื ืฉืืืื ืืืืจ ืืืืื ืงืื ืืืชืจ, ืงืืืืืช ืืืฆืืฆื ืฉืื ืงืื ื ืืืชืจ, ืื ืืื ืขืืื ืขื ืืืืชืื ืืขืชืื ืงืจืืืืช ืืืชืจ ื/ืื ืืืกืจ ืืืืืืช ืืืงืฆืืช ืื ืฉืื ืคื ืื ืืืืง ืื ืชืื ื ืืืืืจ ืืืฉืื.
ืืฉืืขืืช ืืืืจ ืืื: ืขืืืืืื ืืงืฉืืจืื ืืืงืฆืืช ืฉืื ืืืืืจ ืืืืื ื/ืื ืืฉืืืช ื ืชืื ื ืืืฆืืข ืืืืฉ ืืื ื ืืงืืืฆืืช ืืืฆืืข ืืืืฉ.
ืขืืืืืื ืืื, ืืืืื, ืฆืจืืืื ืืืฉืคืืขืื ืขื ืืชืคืืงื ืฉื ืืกื ืื ืชืื ืื ืืขืกืงืืืช. - ืคืจืืืจ
db_block_checksum
: ืืืื, ืื, ืืืืคื ืืืื ืื ืืจืืจ - ืขืืืื ืขืกืงืืืช ืืืืื ืืืืืืฆืจืืช ืฉื ืืืืงืื ืืจืืืื ืืืืืื ืืืืืจ ืฉื ืชืช ืืกื ืื ืชืื ืื.
ืืฉืจ, ืืืฉืจ ืืืืงืช ืกืืื ืืืืงื ืฉื ืืืืงืื ืฉื ื ืชืื ืื ืืืคืขืืช, ืขื ืืกื ืื ืชืื ืื ืืขืื - ืืฉื ืืช ืกืืืื ืืืืืงื ืืืื ืืืืฃ ื-Datablock, ืืืืง ืืืชื ืขื ืื ืฉืืชืื ื-datablock header: matches/ืื ืชืืื.
ืขืืืื ืืื, ืฉืื, ืืื ื ืืืืื ืฉืื ืืขืื ืืช ืขืืืื ืื ืชืื ืื, ืืืืชืื, ืืคืจืืืจ ืืืื ืื ืื ืฉืงืืืข ืคืจืืืจ ืื ืืชืืืื ืืืฉืืขืืชืืื.
ืื ืืกืืื ืฉืืกืคืง ืืฆืืข ืืชืืขืื ืฉื ืคืจืืืจ ืื ืขืจืืื ืฉืื ืื ืืืฆืืื ืื ืื, ืชืืื ืืฉืคืขื, ืืื ืืชื ืืืื ืืืืืจ ืขืจืืื ืฉืื ืื, ืืคืืื "ืืืื" ืืืฉืคืขืืช ืฉืื ืืช.
ืืืื, ืืกืงื ื ืืืืืืืช.
ืืืืฉื, ืืืืคื ืืืื, ืืชืืจืจืช ืืขืืืืช ืืืื.
ืืื ืื ืืจืฉื ืืขืฆืื, ืืฉืืืื ืืจืืฉืื ืื ืฉื ืืืืงืช ืขืืืก ืฉื ืืขืจืืช ืฉืืจืืช ืืกืืืืช, ืืื ืืืืืจ ืืช ืืชืฆืืจื ืืืืคืืืืืืช ืฉืื (ืืขืจืืช) ืืขืืืก, ืื ืืืชืขืืง ืืืชืจ ืืื ืืคืจืืื ืืกืคืฆืืคืืื ืฉื ืืงืืช ืืืขืจืืช ืืขืืืก.
ืืื ืื ืื ืฉืืื ืืช ืื ืืืืืืื - ืืคืืืช ืืจืืช ืืืื ื: ืืืขืจืืช ืืืืืช ืืืืืช ืืืืขื ืขื "ืืคืชืืจื ืืืชืืื" ืืขื ืืืืื ืืกืืืื ืืืืชืจืื ืฉื ืืืคืชืืจืื ืืืื.
ืืืืจ ืืื, ืืืืฉื ืืืืื ืืืฆืื ืืืืืจืืช ืืืกืืช ืืช ืชืฆืืจืช ืืืขืจืืช ืืืืคืืืืืืช.
ืืืืชืืกืก ืขื ืชืืฆืืืช ืืืืืงืืช, ื ืืชื ืืงืื ืืืืข ืขื ืืืคื ืืงืฉืจ ืืื ืืืื ืืืฆืืขื ืืืขืจืืช ืืืื ืขืจืื ืคืจืืืจื ืืืืจืืช ืืืขืจืืช.
ืื ืฉืืืืื ืืืืจ ืืชืจืื ืืืืคืขืชื ืฉื ืืืื ื ืืืืื ืขืืืงื ืืื ืฉื ืืืขืจืืช, ืคืขืืืชื, ืืคืืืช ืชืืช ืขืืืก ื ืชืื.
ืืคืืขื ืืืืืจ ืืืืืคื ืฉื ืขืืืืืช ืืื ืช ืืืขืจืืช ืืืืชืืืช ืืขืืืืืช ืืื ืช ืืืืงื ืืื ืฉื ืืืขืจืืช.
ืืจืฆืื ื ืืฆืืื ืื ืคืจื: ืืืืฉื ืื ืืฉื ื ืืฉืืืืช ืงืจืืืืช ืืืืืช ืืืชืืื ืฉื ืืืืงืช ืืืขืจืืช ืืชื ืื ืืืคืขืื ืฉืืืื ืื ืืคืขืืืืช ืืกืืจืืช.
ืชืืื ืขื ืชืฉืืืช ืืื ืืืืื.
ืืงืืจ: www.habr.com