DBA_HIST_SQLTEXTは、ワークロード・リポジトリで取得された共有SQLカーソルに属するSQL文のテキストを示します。
* sqt.logicr) / (SELECT sum(e.VALUE) - sum(b.value) FROM DBA_HIST_SYSSTAT b, DBA_HIST_...
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...
DBA_HIST_SQLTEXTは、ワークロード・リポジトリで取得された共有SQLカーソルに属するSQL文のテキストを示します。
* sqt.logicr) / (SELECT sum(e.VALUE) - sum(b.value) FROM DBA_HIST_SYSSTAT b, DBA_HIST_...
DBA_HIST_SQLTEXT displays the text of SQL statements belonging to shared SQL cursors captured in the Workload Repository.