These commands must be prepended with cmd /C to be executed appropriately. However, this step is unnecessary when invoking SQL*Plus from Groovy on Windows because SQL*Plus is a separate executable.

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.