Example #1
0
 static function filler_rows($max_rows, $current_row_count, $num_cells, $cell_content = ' ')
 {
     if ($current_row_count < $max_rows) {
         for ($row_num = $current_row_count; $row_num <= $max_rows; $row_num++) {
             $class_str = u::odd_even_class_str($row_num);
             u::filler_row($num_cells, $class_str, $cell_content);
         }
     }
 }
Example #2
0
ORDER BY
  busy_count DESC
__SQL_END;
$binds = '';
$binds[] = array(":sql_mins_hist", $sql_mins_hist);
$binds[] = array(":session_type", $session_type);
$cur = $db_obj->exec_sql($sql, $binds);
u::start_tag('div', 'style="' . $div_styles_top_10s . '"');
u::start_tag('table', 'id="data1"');
u::tr('<th>sql_id</th><th>% of ' . $sql_mins_hist . ' mins busy</th><th>Execs</th><th>Avg Disk Reads</th><th>Avg Secs</th><th>SQL Text</th>', '', 1);
$i = 0;
while ($rec = oci_fetch_object($cur)) {
    #
    # Row formatting
    #
    $class_str = u::odd_even_class_str($i++);
    u::start_tag('tr', $class_str);
    $highlight_graph_str = "onmouseover=\"highlight('{$rec->SQL_ID}');\" ";
    $sql_cell = "<div {$highlight_graph_str}>" . sql_details_link($rec->SQL_ID, $db) . "</div>";
    u::td($sql_cell, '', 1);
    #
    # Barchart
    #
    $values = array($rec->PERCENT_ON_CPU, $rec->PERCENT_USER_IO, $rec->PERCENT_SYSTEM_IO, $rec->PERCENT_BLOCKED, $rec->PERCENT_OTHER);
    u::start_tag('td', 'style="padding:0px 0px 0px 0px"');
    include 'bar_chart.php';
    u::end_tag('td');
    u::td($rec->EXECS, '', 1);
    u::td($rec->AVG_DISK_READS, '', 1);
    u::td($rec->AVG_SECS, '', 1);
    u::tagged_item('td', $rec->SQL_TEXT, 'style="border-right:0px;font-size:xx-small;font-family:Courier New;"', 1);