ORACLE功能特性使用统计DBA_FEATURE_USAGE_STATISTICS

Dear 丶 2023-10-18 21:09 37阅读 0赞

## DBA\_FEATURE\_USAGE\_STATISTICS ##

`DBA_FEATURE_USAGE_STATISTICS` displays information about database feature usage statistics.

<table> 
 <thead> 
  <tr> 
   <th>Column</th> 
   <th>Datatype</th> 
   <th>NULL</th> 
   <th>Description</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td><code>DBID</code></td> 
   <td><code>NUMBER</code></td> 
   <td><code>NOT NULL</code></td> 
   <td>Database identifier of the database being tracked</td> 
  </tr> 
  <tr> 
   <td><code>NAME</code></td> 
   <td><code>VARCHAR2(64)</code></td> 
   <td><code>NOT NULL</code></td> 
   <td>Name of the feature (See&nbsp;<a href="https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3114.htm#G2023396" rel="nofollow">Table 4-1</a>)</td> 
  </tr> 
  <tr> 
   <td><code>VERSION</code></td> 
   <td><code>VARCHAR2(17)</code></td> 
   <td><code>NOT NULL</code></td> 
   <td>Database version in which the feature was tracked</td> 
  </tr> 
  <tr> 
   <td><code>DETECTED_USAGES</code></td> 
   <td><code>NUMBER</code></td> 
   <td><code>NOT NULL</code></td> 
   <td>Number of times the system has detected usage for the feature</td> 
  </tr> 
  <tr> 
   <td><code>TOTAL_SAMPLES</code></td> 
   <td><code>NUMBER</code></td> 
   <td><code>NOT NULL</code></td> 
   <td>Number of times the system has woken up and checked for feature usage</td> 
  </tr> 
  <tr> 
   <td><code>CURRENTLY_USED</code></td> 
   <td><code>VARCHAR2(5)</code></td> 
   <td>&nbsp;</td> 
   <td>Indicates whether usage was detected the last time the system checked (<code>TRUE</code>) or not (<code>FALSE</code>)</td> 
  </tr> 
  <tr> 
   <td><code>FIRST_USAGE_DATE</code></td> 
   <td><code>DATE</code></td> 
   <td>&nbsp;</td> 
   <td>First sample time the system detected usage of the feature</td> 
  </tr> 
  <tr> 
   <td><code>LAST_USAGE_DATE</code></td> 
   <td><code>DATE</code></td> 
   <td>&nbsp;</td> 
   <td>Last sample time the system detected usage of the feature</td> 
  </tr> 
  <tr> 
   <td><code>AUX_COUNT</code></td> 
   <td><code>NUMBER</code></td> 
   <td>&nbsp;</td> 
   <td>This column stores feature-specific usage data in number format.</td> 
  </tr> 
  <tr> 
   <td><code>FEATURE_INFO</code></td> 
   <td><code>CLOB</code></td> 
   <td>&nbsp;</td> 
   <td>This column stores feature-specific usage data in character format.</td> 
  </tr> 
  <tr> 
   <td><code>LAST_SAMPLE_DATE</code></td> 
   <td><code>DATE</code></td> 
   <td>&nbsp;</td> 
   <td>Amount of time (in seconds) between the last two usage sample times</td> 
  </tr> 
  <tr> 
   <td><code>LAST_SAMPLE_PERIOD</code></td> 
   <td><code>NUMBER</code></td> 
   <td>&nbsp;</td> 
   <td>Amount of time (in hours) between the last two usage sample times</td> 
  </tr> 
  <tr> 
   <td><code>SAMPLE_INTERVAL</code></td> 
   <td><code>NUMBER</code></td> 
   <td>&nbsp;</td> 
   <td>Sample interval</td> 
  </tr> 
  <tr> 
   <td><code>DESCRIPTION</code></td> 
   <td><code>VARCHAR2(128)</code></td> 
   <td>&nbsp;</td> 
   <td>Description of the feature and usage detection logic (See&nbsp;<a href="https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3114.htm#G2023396" rel="nofollow">Table 4-1</a>)</td> 
  </tr> 
 </tbody> 
</table>