The following three options introduced in 18c are very useful for DBA's.
I am sure how many of you find hard to limit the rows in Oracle and also finding sql_id for the statement executed. Now that has been solved.
SET FEEDBACK ON SQL_ID
You can find the sql_id for the executed statement in the sqlplus without querying v$sql or dbms_xplan.display_cursor. Here is how
SET ROWLIMIT n
Limit the Number of rows in the sql prompt, without using rownum
SET LINESIZE WINDOW
Setting Columns to adjust to the windows is no more required, you can use WINDOW option
-Thanks
Suresh
Can application users use this set feedback on sql_id ?