php展现oracle数据(表空间监控)

<?php$db_user = "hxl";$db_pass = "hxl";$db_sid = "hxl"; $dbconn=oci_connect($db_user,$db_pass,"(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =172.18.2.15)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = hxl)))");  //$sql = "select EMPno,Ename from scott.emp"; $sql="select       t.statedate statedate,       t.instance_name,       t.tablespace_name,       to_char(t.total_size_gb,'FM9999990.0099') total_size_gb,       to_char(t.used_size_gb,'FM9999990.0099') used_size_gb,       to_char(t.total_size_gb - t.used_size_gb,'FM9999990.0099') free_size,       to_char(t.usage_pct,'FM9999990.0099') usage_pct  from tb_tablespace_usage_info t where t.statedate = to_char(sysdate, 'yyyymmdd')   and t.type_id in ('1', '2') order by t.usage_pct desc";  $oci_rs = oci_parse($dbconn,$sql);oci_execute($oci_rs,OCI_DEFAULT);//while($row=oci_fetch_array($oci_rs,OCI_ASSOC)) {//    print_r($row);//} print "<table border='1'>";print "<th align = 'center'>统计时间</th>";print "<th align = 'center'>实例名称</th>";print "<th align = 'center'>表空间名称</th>";print "<th align = 'center'>总空间大小(GB)</th>";print "<th align = 'center'>使用空间(GB)</th>";print "<th align = 'center'>剩余空间(GB)</th>";print "<th align = 'center'>使用率</th>"; while( OCIFetchInto($oci_rs, &$result_array)) {  print "<tr>";  print "<td align = 'center'>$result_array[0]</td>";        print "<td align = 'center'>$result_array[1]</td>";        print "<td align = 'center'>$result_array[2]</td>";        print "<td align = 'center'>$result_array[3]</td>";        print "<td align = 'center'>$result_array[4]</td>";        print "<td align = 'center'>$result_array[5]</td>";        print "<td align = 'center'>$result_array[6]</td>";  print "</tr>";}print "</table>";?>

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。