copyright : (C) 2000 by Thomas Fromm
email : tf@tfromm.com
***************************************************************************/
/***************************************************************************
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* the Free Software Foundation; either version 2 of the License, or *
* (at your option) any later version. *
* *
***************************************************************************/
include "prepend.inc.php";
$Server = getData("Server", "integer");
$Sortorder = getData("Sortorder");
$Sortfield = rawurldecode(getData("Sortfield"));
$html = "<H1> Database " . $DB->Name($Server) . " - Tablespace Overview</H1>\n";
$tbl = new DataTable($Server);
$tbl->setSql("SELECT tablespace_name \"Tablespace Name\", initial_extent \"Initial Extent\", " . "next_extent \"Next Extent\", min_extents \"Min Extents\", max_extents \"Max Extents\", " . "pct_increase \"% Increase\", status \"Status\" FROM dba_tablespaces order by \"Tablespace Name\"");
$tbl->setSorting(1);
$tbl->setSort($Sortfield, $Sortorder);
$tbl->loadData();
$tbl->setColorToggle(1);
$tbl->setDataLink("Tablespace Name", "tblsp_detail.php?Server={$Server}&Tablespacename=\$value&" . SID);
$tbl->renderHTML("tblsp_main.php?Server={$Server}&" . SID);
$html .= $tbl->getHTML();
$page = new Page("Tablespace Overview");
$page->setHead();
$page->setBody();
$page->setSQL();
$page->setBody($html);
$page->Display();
***************************************************************************/
/***************************************************************************
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* the Free Software Foundation; either version 2 of the License, or *
* (at your option) any later version. *
* *
***************************************************************************/
include "prepend.inc.php";
$Server = getData("Server", "integer");
$User = getData("User");
$Userurl = rawurlencode($User);
$tbl = new Table($Server);
$tbl->getDatas($User);
$html = "<H1> Database " . $DB->Name($Server) . " - Table overview of User {$User}</H1>\n";
$dtbl = new DataTable($Server);
$dtbl->setSorting(0);
$dtbl->setData($tbl->datas[$User]);
unset($tbl);
$dtbl->setColorToggle(1);
$dtbl->setDataLink("TABLE_NAME", "tbl_detail.php?Server={$Server}&Tablename=\$value&User={$Userurl}&" . SID);
$dtbl->renderHTML();
$html .= $dtbl->getHTML();
unset($dtbl);
$page = new Page("Table Overview");
$page->setHead();
$page->setBody();
$page->setSQL();
$page->setBody($html);
$page->Display();
$html .= $tbl->getHTML();
unset($tbl);
}
// end submode content
break;
case "triggers":
switch ($submode) {
default:
$tbl = new DataTable($Server);
$tbl->setSql(sprintf("select TRIGGER_NAME \"Trigger Name\", TRIGGER_TYPE \"Type\", " . "status \"Status\", triggering_event \"Triggering on\" " . "from all_triggers where table_name='%s' and table_owner='%s'", $Tablename, $User));
$tbl->setSorting(1);
$tbl->setSort($Sortfield, $Sortorder);
$tbl->loadData();
$tbl->setColorToggle(1);
if ($CF->get("ENABLE_TRIGGERS")) {
$tbl->setDataLink("Trigger Name", "tri_detail.php?Server={$Server}&Triggername=\$value&User={$Userurl}&" . SID);
}
$tbl->renderHTML($defaultget . "mode={$mode}&" . SID);
$html .= $tbl->getHTML();
unset($tbl);
}
// end submode content
break;
case "main":
switch ($submode) {
case "rownum":
$html .= "<h1>Number of Rows</h1>";
$tbl = new DataTable($Server);
$tbl->setSql("SELECT COUNT(*) FROM {$User}.{$Tablename}");
$tbl->loadData();
$tbl->renderHTML();
$html .= $tbl->getHTML();
unset($tbl);
}
// end switch submode
break;
case "datafiles":
switch ($submode) {
default:
$tbl = new DataTable($Server);
$tbl->setSql(sprintf("SELECT file_name \"Filename\", bytes / 1024 \"Kilobytes\", " . "status \"Status\" FROM dba_data_files WHERE tablespace_name = '%s' " . "ORDER BY file_name", $Tablespacename));
$tbl->setSorting(1);
$tbl->setSort($Sortfield, $Sortorder);
$tbl->loadData();
$tbl->setColorToggle(1);
if ($CF->get("ENABLE_DATAFILES")) {
$tbl->setDataLink("Filename", "datafile_detail.php?Server={$Server}&Datafilename=\$value&" . "Tablespacename={$Tablespacenameurl}&" . SID);
}
$tbl->renderHTML($defaultget . "mode={$mode}&" . SID);
$html .= $tbl->getHTML();
unset($tbl);
}
// end switch submode
break;
case "users":
switch ($submode) {
default:
}
// end switch submode
break;
}
$page = new Page("Tablespace Management - " . $Tablespacename);
