<?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>";?>

鄭重聲明：本文版權歸原作者所有，轉載文章僅為傳播更多信息之目的，如作者信息標記有誤，請第一時間聯系我們修改或刪除，多謝。