HOW TO EXECUTE SQL STATEMENT IN RMAN

HOW TO EXECUTE SQL STATEMENT IN RMAN

In 12c, you can now execute any SQL and PL/SQL commands in RMAN without the need of a SQL prefix: you can execute any SQL and PLS/SQL commands directly from RMAN. How 

you can execute SQL statements in RMAN:

RMAN> SELECT username,machine FROM v$session;

RMAN> ALTER TABLESPACE users ADD DATAFILE SIZE 121m;