DBA Data[Home] [Help]

SYS.INITJVMAUX dependencies on DBA_ROLLBACK_SEGS

Line 63: select segment_name into rollback_segment_name from dba_rollback_segs

59: if pdbname is not null and pdbname != 'CDB$ROOT' then return; end if;
60: end;
61:
62: begin
63: select segment_name into rollback_segment_name from dba_rollback_segs
64: where tablespace_name='SYSTEM' and next_extent*max_extents>100000000 and
65: status='ONLINE' and initial_extent>1000000 and rownum < 2;
66: debug_output('found good enough rollback segment ' ||
67: rollback_segment_name);

Line 75: from dba_rollback_segs where segment_name = rollback_segment_name;

71: rollback_segment_name := 'MONSTER';
72: loop
73: begin
74: select segment_name into deallocate_rollback_name
75: from dba_rollback_segs where segment_name = rollback_segment_name;
76: debug_output('skipped rollback segment ' || rollback_segment_name);
77: exception when no_data_found then
78: deallocate_rollback_name := rollback_segment_name;
79: sec_rollback_segment_name :=