Oracle PL/SQL/PL SQL/Dump

Get user dump and background dump

SQL>
SQL> drop user myUser;
SQL>
SQL> set serverout on;
SQL>
SQL> create user myUser identified by myPass;
SQL>
SQL> grant create session to myUser;
SQL>
SQL> connect myUser/myPass;
SQL>
SQL> declare
  2    myString varchar2(255);
  3    myNumber  number;
  4  begin
  5     myNumber := dbms_utility.get_parameter_value ( "background_dump_dest", myNumber, myString );
  6
  7     dbms_output.put_line( "background: " || myString );
  8
  9     myNumber := dbms_utility.get_parameter_value ( "user_dump_dest", myNumber, myString );
 10
 11     dbms_output.put_line( "user:       " || myString );
 12  end;
 13  /
background: C:\ORACLE\APP\ORACLE\ADMIN\XE\BDUMP
user:       C:\ORACLE\APP\ORACLE\ADMIN\XE\UDUMP
SQL>
SQL>
SQL> drop user myUser;