Here is my code, pretty straight forward, but it wont work. Thank you all!
begin
-- to set the max dump file size for a given session
sys.dbms_system.set_int_param_in_session( 217, 36575, 'MAX_DUMP_FILE_SIZE', 1073741824 );
end;
It generates:
ORA-44737: Parameter MAX_DUMP_FILE_SIZE did not exist.
ORA-06512: at "SYS.DBMS_SYSTEM", line 122 ORA-06512: at line 3
I've been researching around and it seems there is an alternative method using alter session, but I don't see how I can set a specific user's session dump size to a value as you can with set_int_param_in_session. Thank you all!