dba_hist_sqltext 是Oracle 数据库中用于存储 SQL 语句历史信息的动态性能视图(Dynamic Performance View)。它记录了数据库中执行过的 SQL 语句,对于数据库性能调优和审计非常有用。 关于dba_hist_sqltext 数据保存多久的问题,这主要取决于以下几个因素: AWR(Automatic Workload Repository)保留策略: Oracle 的 AWR...
DBA_HIST_SQLTEXTは、ワークロード・リポジトリで取得された共有SQLカーソルに属するSQL文のテキストを示します。 このビューでは、V$SQLからの情報が取得され、DBA_HIST_SQLSTATビューとともに使用されます。 列データ型NULL説明 DBID NUMBER NOT NULL データベースID SQL_ID VARCHAR...
问在dba_hist_sqltext中找到SQL_ID，但在v$sql中找不到EN逻辑读 TOP 10 select * from (select sq...
SYS DBA_HIST_SYSSTAT select "SNAP_ID","DBID","INSTANCE_NUMBER","STAT_ID","STAT_NAME","VALUE","CON_DBID","CON_ID" from AWR_ROOT_SYSSTAT SYS@test> @ v2 AWR_ROOT_SYSSTAT Show SQL text of views matching "AWR_ROOT_SYSSTAT"... V_OWNER VIEW_NAME TEXT --- --- --- SYS AWR_ROOT...
5.64 DBA_HIST_SQLCOMMAND_NAME 5.65 DBA_HIST_SQLSTAT 5.66 DBA_HIST_SQLTEXT 5.67 DBA_HIST_STAT_NAME 5.68 DBA_HIST_STREAMS_APPLY_SUM 5.69 DBA_HIST_STREAMS_CAPTURE 5.70 DBA_HIST_STREAMS_POOL_ADVICE 5.71 DBA_HIST_SYS_TIME_MODEL 5.72 DBA_HIST_SYSMETRIC_HISTORY 5.73 DBA_HIST_SYSMETRIC_SUMMARY 5.74...
问在dba_hist_sqltext中找到SQL_ID，但在v$sql中找不到EN逻辑读 TOP 10 select * from (select ...
DBA_HIST_SQLTEXT displays the text of SQL statements belonging to shared SQL cursors captured in the Workload Repository.