Archives

You are currently viewing archive for June 2009
Category: MS tips
Posted by: hajime osako
Category: MS tips
Posted by: hajime osako
The Old New Thing : Hidden gotcha: The command processor

HKEY_LOCAL_MACHINE\Software\Microsoft\Command Processor\AutoRun
Category: Web dev
Posted by: hajime osako

06/15: Linux > NAT

Category: Linux tips
Posted by: hajime osako
Category: Web dev
Posted by: hajime osako
Log memory usage using declare and ticks in PHP | DaveDevelopment


# function log_memory() {
# $_SESSION['memory'][] = array(
# 'time' => microtime(true),
# 'memory' => memory_get_usage(),
# ); // or insert your logging code here
# }
#
# declare(ticks = 50); // log every 50 ticks (low level instructions)
# register_tick_function('log_memory');
# $var = 'a';
#
# for($i=0;$i<100;$i++) {
# $var .= 'a';
# }
#
# var_dump($_SESSION['memory']);
Category: Oracle
Posted by: hajime osako
Scheduler Reference

SELECT JOB_NAME, STATUS, ERROR#
FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE JOB_NAME = 'MY_JOB1';
Category: Oracle
Posted by: hajime osako
Category: MS tips
Posted by: hajime osako
Category: Linux tips
Posted by: hajime osako
Category: Oracle
Posted by: hajime osako
データベース統計情報 - オラクル・Oracleをマスターするための基本と仕組み

SET SERVEROUTPUT ON SIZE 1000000
DECLARE
vMsg VARCHAR(250);
vList DBMS_STATS.OBJECTTAB;
BEGIN
DBMS_STATS.GATHER_DATABASE_STATS(
OPTIONS => 'LIST EMPTY'
,OBJLIST => vList
);
FOR i IN 1..vList.COUNT LOOP
vMsg := vList(i).OWNNAME;
vMsg := vMsg || ',' || vList(i).OBJTYPE;
vMsg := vMsg || ',' || vList(i).OBJNAME;
vMsg := vMsg || ',' || vList(i).PARTNAME;
vMsg := vMsg || ',' || vList(i).SUBPARTNAME;
-- vMsg := vMsg || ',' || vList(i).CONFIDENCE;
-- (パッケージ定義に未使用項目とある)
DBMS_OUTPUT.PUT_LINE(vMsg);
END LOOP;
END;
/