1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116
|
<html>
<head>
<title>DB</title>
</head>
<body>
{%header:Summary%}
<br>
<br>
<font size=+2>{%object_name%}</font><br>
{%dbinfo:connection_string%}<br>
{%dbinfo:sql_security%}<br>
<table bgcolor="white" border=0 cellpadding=2 cellspacing=0 valign=top>
<tr><td>
<!-- left table -->
<table cellspacing=1 cellpadding=2 border=0 bgcolor="black">
<tbody>
<tr bgcolor="navy">
<td nowrap colspan=2><b><font color=white>Database info</font></b></td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>ODS Version</td><td align="right" bgcolor="#CCCCFF" nowrap>{%dbinfo:ods_version%}</td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Page Size</td><td align="right" bgcolor="#CCCCFF" nowrap>{%dbinfo:page_size%}</td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Pages</td><td align="right" bgcolor="#CCCCFF" nowrap>{%dbinfo:pages%}</td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Size on Disk</td><td align="right" bgcolor="#CCCCFF" nowrap>{%dbinfo:size%}</td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>SQL Dialect</td><td align="right" bgcolor="#CCCCFF" nowrap>{%dbinfo:sql_dialect%}</td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Default Character Set</td><td align="right" bgcolor="#CCCCFF" nowrap>{%dbinfo:default_charset%}</td>
</tr>
</tbody>
</table>
<!-- left table end-->
</td><td> </td><td>
<!-- middle table -->
<table cellspacing=1 cellpadding=2 border=0 bgcolor="black">
<tbody>
<tr bgcolor="navy">
<td colspan=2><b><font color=white>Settings</font></b></td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Page Buffers</td>
<td align="right" bgcolor="#CCCCFF" nowrap><a href="fr://edit_db_page_buffers?parent_window={%parent_window%}&object_handle={%object_handle%}">{%dbinfo:page_buffers%}</a></td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Sweep Interval</td>
<td align="right" bgcolor="#CCCCFF" nowrap><a href="fr://edit_db_sweep_interval?parent_window={%parent_window%}&object_handle={%object_handle%}">{%dbinfo:sweep_interval%}</a></td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Linger</td>
<td align="right" bgcolor="#CCCCFF" nowrap><a href="fr://edit_db_linger?parent_window={%parent_window%}&object_handle={%object_handle%}">{%dbinfo:linger%}</a></td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Forced Writes</td>
<td align="center" bgcolor="#CCCCFF" nowrap><a href="fr://edit_db_forced_writes?parent_window={%parent_window%}&object_handle={%object_handle%}"><img src="{%template_root%}{%ifeq:{%dbinfo:forced_writes%}:true:ok.png:redx.png%}"></a></td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Reserve Space</td>
<td align="center" bgcolor="#CCCCFF" nowrap><a href="fr://edit_db_reserve_space?parent_window={%parent_window%}&object_handle={%object_handle%}"><img src="{%template_root%}{%ifeq:{%dbinfo:reserve_space%}:true:ok.png:redx.png%}"></a></td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Read-Only</td>
<td align="center" bgcolor="#CCCCFF" nowrap><a href="fr://edit_db_read_only?parent_window={%parent_window%}&object_handle={%object_handle%}"><img src="{%template_root%}{%ifeq:{%dbinfo:is_read_only%}:true:ok.png:redx.png%}"></a></td>
</tr>
</tbody>
</table>
<!-- left middle table end -->
</td><td> </td><td>
<!-- rigth middle table -->
<table cellspacing=1 cellpadding=2 border=0 bgcolor="black">
<tbody>
<tr bgcolor="navy">
<td nowrap colspan=2><b><font color=white>Transaction info</font></b></td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Oldest transaction</td><td align="right" bgcolor="#CCCCFF" nowrap>{%dbinfo:oldest_transaction%}</td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Oldest active transaction</td><td align="right" bgcolor="#CCCCFF" nowrap>{%dbinfo:oldest_active_transaction%}</td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Oldest snapshot</td><td align="right" bgcolor="#CCCCFF" nowrap>{%dbinfo:oldest_snapshot%}</td>
</tr>
<tr bgcolor="#DDDDFF">
<td nowrap>Next transaction</td><td align="right" bgcolor="#CCCCFF" nowrap>{%dbinfo:next_transaction%}</td>
</tr>
</tbody>
</table>
<!-- rigth middle table end -->
</td><td> </td><td>
<!-- right table -->
<table cellspacing=1 cellpadding=2 border=0 bgcolor="black">
<tbody>
<tr bgcolor="navy">
<td nowrap><b><font color=white>Connected users</font></b></td>
</tr>
{%forall:{%dbinfo:connected_users%}::
<tr bgcolor="#DDDDFF">
<td bgcolor="#CCCCFF" nowrap>%%current_value%%</td>
</tr>
%}
</tbody>
</table>
<!-- right table end -->
</td></tr>
</table>
</body>
</html>
|