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;