在循环中执行的 SQL 查询

发布于 2024-11-29 16:31:24 字数 477 浏览 1 评论 0原文

我需要您帮助解决以下查询。

SELECT
 SQL_ID,
 SNAP_ID,
 EXECUTIONS_TOTAL,
 EXECUTIONS_DELTA,
 CPU_TIME_TOTAL,
 CPU_TIME_DELTA,
 ELAPSED_TIME_TOTAL,
 ELAPSED_TIME_DELTA
from
 WRH$_SQLSTAT
where
 SQL_ID='807mzfr04qt1c' and
 SNAP_ID in (19507,19508);

我必须每小时执行上述查询才能获取结果（snap_id 值在下一小时内从 19507-19508 更改为 19508-19509）。假设一整天，开始快照 ID 从 19507 开始，到 19530 结束。我需要帮助编写一个脚本，该脚本应该从开始 id(19507) 执行它，并将其与下一个 id(19508) 和下一个 id(19508) 成为起始 id，依此类推，从而执行直到到达结束 id(19530)。

原文

I need your help with the following query.

SELECT
 SQL_ID,
 SNAP_ID,
 EXECUTIONS_TOTAL,
 EXECUTIONS_DELTA,
 CPU_TIME_TOTAL,
 CPU_TIME_DELTA,
 ELAPSED_TIME_TOTAL,
 ELAPSED_TIME_DELTA
from
 WRH$_SQLSTAT
where
 SQL_ID='807mzfr04qt1c' and
 SNAP_ID in (19507,19508);

I have to execute the above query every hour to get the results(the snap_id value changes to 19508-19509 in next hour from 19507-19508). Let us say for an entire day the begin snap id started from 19507 and ended in 19530. I would need help in writing a script that should execute it from the start id(19507) and compare it with the next id(19508) and the next id(19508) becomes the start id and so on and thus execute until the end id(19530) is reached.

分享到QQ

分享到微博