DBA_HIST_SYSSTAT 一时失言乱红尘 2023-10-05 14:58 33阅读 0赞 ## **DBA\_HIST\_SYSSTAT** ## `DBA_HIST_SYSSTAT`显示历史系统统计信息。此视图包含的快照`V$SYSSTAT`。 <table> <thead> <tr> <th style="text-align:left;vertical-align:bottom;"><span style="color:#000000;">柱</span></th> <th style="text-align:left;vertical-align:bottom;"><span style="color:#000000;">数据类型</span></th> <th style="text-align:left;vertical-align:bottom;"><span style="color:#000000;">空值</span></th> <th style="text-align:left;vertical-align:bottom;"><span style="color:#000000;">描述</span></th> </tr> </thead> <tbody> <tr> <td style="vertical-align:top;"><span style="color:#000000;"><code>SNAP_ID</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"><code>NUMBER</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"> </span></td> <td style="vertical-align:top;"><span style="color:#000000;">唯一的快照ID</span></td> </tr> <tr> <td style="vertical-align:top;"><span style="color:#000000;"><code>DBID</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"><code>NUMBER</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"> </span></td> <td style="vertical-align:top;"><span style="color:#000000;">快照的数据库ID</span></td> </tr> <tr> <td style="vertical-align:top;"><span style="color:#000000;"><code>INSTANCE_NUMBER</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"><code>NUMBER</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"> </span></td> <td style="vertical-align:top;"><span style="color:#000000;">快照的实例号</span></td> </tr> <tr> <td style="vertical-align:top;"><span style="color:#000000;"><code>STAT_ID</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"><code>NUMBER</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"> </span></td> <td style="vertical-align:top;"><span style="color:#000000;">统计标识符</span></td> </tr> <tr> <td style="vertical-align:top;"><span style="color:#000000;"><code>STAT_NAME</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"><code>VARCHAR2(64)</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"> </span></td> <td style="vertical-align:top;"><span style="color:#000000;">统计名称</span></td> </tr> <tr> <td style="vertical-align:top;"><span style="color:#000000;"><code>VALUE</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"><code>NUMBER</code></span></td> <td style="vertical-align:top;"><span style="color:#000000;"> </span></td> <td style="vertical-align:top;"><span style="color:#000000;">统计值</span></td> </tr> </tbody> </table>
还没有评论，来说两句吧...