<?php # # $Id: //Infrastructure/GitHub/Database/avo/web/start_html.php#2 $ # # Html start and javascript # # # Main page needs some js etc # $uri = $_SERVER['REQUEST_URI']; if (strpos($uri, 'db_monitor.php') > 0 or strpos($uri, 'system_load.php')) { u::inc('db_monitor_html_style_and_js.php'); } else { echo "<!doctype html>\n<html>\n<head>\n</head>\n<body>\n"; }
if ($db_obj->use_local_awr_tables) { $use_our_own_history_tables = TRUE; } else { $use_our_own_history_tables = FALSE; } } } } else { #exit; $snaps_table = ''; } # # If we want a full page, the add styles etc # if (!$div_only or u::request_val('table_styles')) { u::inc('start_html.php'); } # # Database object # if ($db) { $db_obj = new db($user, $pw, $conn_str); # # Set oracle date format # $date_fmt = 'HH24:MI:SS'; $db_obj->exec_sql("ALTER SESSION SET NLS_DATE_FORMAT = '{$date_fmt}'"); $db_obj->exec_sql("ALTER SESSION SET NLS_TIMESTAMP_FORMAT = '{$date_fmt}'"); # # get database sysdate #
# # Start HTML page and menu # # $Id: //Infrastructure/GitHub/Database/avo/web/db_monitor.php#2 $ # # # Start session etc # include 'start.php'; # # Top menu # $db = @$_GET['db']; $form_name = 'db_monitor.php'; u::inc('menu.php'); # # Exit if no db selected, just display the menu # if (!$db) { exit; } # # Divs for displaying monitoring # ?> <div id="graph1" style="position:relative;"></div> <div id="graph3" style="position:relative;left:0;overflow:hidden;"></div> <div id="graph2" style="position:relative;left:0;overflow:hidden;"></div> </body> </html>
$sql_mins_hist = u::request_val('sql_mins_hist', 1); $mins_hist = u::request_val('mins_hist', 1); $start = date('o_m_d__07'); $end = date('o_m_d__H'); # # OS load # if (u::request_val('os_stats')) { u::inc('os_stats.php'); } # # Active session details now # if (u::request_val('active_sessions')) { u::inc('active_sessions_graph.php'); } # # Top sql now # if (u::request_val('top_sql')) { u::inc('top_sql.php'); } # # Top sessions # if (u::request_val('top_sessions')) { u::inc('top_sessions.php'); } if (!$div_only) { u::inc('end.php'); }