Being Oracle DBA we all are aware of the relationship between instance and database. Today we are going to have look on “SQL*Plus Customize User Profile“. On daily basis, DBAs works on SQL*Plus at many stages of the database. Execution of all commands on the correct database is the main focus of any DBA. We have to perform multiple […]
Articles Tagged: sqlplus
Display the sql_id for a query in Oracle 18c
The SET FEEDBACK command has an SQL_ID option to display the sql_id for the currently executed SQL or PL/SQL statements. The sql_id will be assigned to the predefined variable SQL_ID. Displays the number of records returned by a script when a script selects at least n records. SQL_ID returns the sql_id for the SQL or PL/SQL […]