SQL*Plus executes this command file whenever any user starts SQL*Plus and SQL*Plus establishes the Oracle connection. The Site Profile allows the DBA to set up SQL*Plus environment defaults for all ...

For detailed statistics, you had to run the TKPROF utility. We can now get the execution plan and trace information for any SQL statement very quickly and easily with a few SQL*Plus commands.

The other user could issue the SQL*Plus command: SQL> connect ANOTHER USER SQL> @clone SCOTT FUNCTION FOO This works but it still requires SQL*Plus sessions and scripts.