Example 1: Shows the syntax for establishing a row limit within an interactive SQL session. SQL> set query limit rows 10000; SQL> show query limit; Query limit Time is OFF Query limit Row count is 10000 rows Query limit CPU time is OFF Execution limit CPU time is OFF Execution limit Elapsed time is OFF Execution limit Row count is OFF SQL> set query nolimit rows; SQL> show query limit; Query limit Time is OFF Query limit Row count is OFF Query limit CPU time is OFF Execution limit CPU time is OFF Execution limit Elapsed time is OFF Execution limit Row count is OFF Example 2: Uses SET QUERY to establish a two second elapsed time limit for a query, and shows the error message that is displayed. SQL> set query execution limit elapsed time 2 seconds; SQL> delete from EMPLOYEES; %RDB-E-EXQUOTA, Oracle Rdb runtime quota exceeded -RDMS-E-MAXTIMLIM, query governor maximum timeout has been reached SQL> set query execution nolimit elapsed time;