SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

maximum sleep interval for the REPEAT command

Jochen BandhauerAug 9 2025

Hello,

I wanted to use the repeat command to monitor values from v$sql_bind_capture. I think the values in v$sql_bind_capture are updated at most every 15 minutes. Currently the repeat command has a sleep interval of maximum 120s. Would it be possible to raise that limit? That would be great. I am using version 25.2.

SQL> repeat 96 900
Usage: REPEAT  <iterations> <seconds>
        SQL is the sql from the current buffer
        Maximum sleep is 120s
        Maximum repeats are 2.147.483.647
SQL>

Regards

Jochen

Added on Aug 9 2025

#sqlcl

0 comments

31 views