复杂应用环境下监控Oracle数据库性能(1)

#define TV_START 0 
#define TV_END 1 
int how_long(int cmd, char *res); 
struct CMD_TIME{ 
int times; 
/* times occured within specified package number */ 
struct timeval time; 
/* total time consumed by the cmd */ 
}; 
void foo() 
{ 
int id; 
how_long(TV_START, NULL); 
EXEC SQL WHENEVER SQLERROR CONTINUE; 
EXEC SQL WHENEVER NOT FOUND CONTINUE; 
EXEC SQL select user_id into :id from users where name='slimzhao';2; 
how_long(TV_END, time_consume); 
puts(time_consume); 
} 
int how_long(int cmd, char *res) 
/* return value: -1 error, 0 sucess , res: 20 bytes is enough */ 
{ 
static struct timeval before, after; 
if(cmd == TV_START) { 
gettimeofday(&before, NULL); 
return 0; 
} else if(cmd == TV_END) { 
gettimeofday(&after, NULL); 
if(res) { 
if(after.tv_usec > before.tv_usec) { 
sprintf(res, "%ld %ld", after.tv_sec - before.tv_sec, 
after.tv_usec - before.tv_usec); 
} else { 
sprintf(res, "%ld %ld", 
after.tv_sec - before.tv_sec - 1, 
1000000 + after.tv_usec - before.tv_usec); 
} 
} 
return 0; 
} else { 
return -1; 
} 
}

/how_long.inc"; 
how_long(TV_START, $timestr); 
$conn = OCILogon("username", "password", "dblink"); 
$stmt = OCIParse($conn, "select ID from users where name='slimzhao'"); 
OCIDefineByName($stmt, ID, $id); 
OCIExecute($stmt); 
OCIFetch($stmt); 
OCIFreeStatement($stmt); 
OCILogoff($conn); 
how_long(TV_END, $timestr); 
echo " 用户 ID: $id , 该操作消耗时间 :$timestr
"; 
?> 
其中 how_long 函数的 PHP 版本如下 : 
 $after_SQL["usec"]) { 
$str = ($after_SQL["sec"] - $before_SQL["sec"] - 1)." 秒 ". 
($after_SQL["usec"] + 1000*1000 -$before_SQL["usec"])." 微秒 "; 
} else { 
$str = ($after_SQL["sec"] - $before_SQL["sec"])." 秒 ". 
($after_SQL["usec"]-$before_SQL["usec"])." 微秒 "; 
} 
} else { 
return -1; 
} 
} 
?>