eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.RMJVM dependencies on DBMS_OUTPUT

Line 32: dbms_output.enable(10000000); -- biggest size we can get

28: -- This procedure requires a significant amount of rollback
29: -- to execute.
30: --
31:
32: dbms_output.enable(10000000); -- biggest size we can get
33:
34: initjvmaux.rollbacksetup;
35:
36: commit;

Line 67: dbms_output.put_line('drop or disable triggers with java implementations');

63:
64: commit;
65: initjvmaux.rollbackset;
66:
67: dbms_output.put_line('drop or disable triggers with java implementations');
68:
69: drp('drop trigger JIS$ROLE_TRIGGER$');
70:
71: drp('delete from duc$ where owner=''SYS'' and pack=''JIS$INTERCEPTOR$'' ' ||

Line 85: dbms_output.put_line('drop synonyms with java targets');

81: commit;
82:
83: initjvmaux.rollbackset;
84:
85: dbms_output.put_line('drop synonyms with java targets');
86:
87: DECLARE
88: cursor C1 is select name from java$rmjvm$aux2;
89:

Line 148: dbms_output.put_line('### Failure ('||my_err||') executing '||cmd);

144:
145: EXCEPTION
146: WHEN OTHERS THEN
147: my_err := SQLCODE;
148: dbms_output.put_line('### Failure ('||my_err||') executing '||cmd);
149: loss_count := loss_count+1;
150: if loss_count > 100 then raise; end if;
151: END;
152:

Line 165: dbms_output.put_line('flush shared_pool');

161:
162: END;
163: commit;
164:
165: dbms_output.put_line('flush shared_pool');
166: execute immediate 'alter system flush shared_pool';
167: execute immediate 'alter system flush shared_pool';
168: execute immediate 'alter system flush shared_pool';
169:

Line 177: dbms_output.put_line('delete from dependency$');

173: begin
174:
175: initjvmaux.rollbackset;
176:
177: dbms_output.put_line('delete from dependency$');
178:
179: if remove_all then
180: select count(*) into total_to_delete from dependency$
181: where p_obj# in (select obj# from java$rmjvm$aux);

Line 189: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));

185: end if;
186: commit;
187:
188: loop
189: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
190: initjvmaux.rollbackset;
191: if remove_all then
192: delete from dependency$ where p_obj# in
193: (select obj# from java$rmjvm$aux)

Line 207: dbms_output.put_line('delete from error$');

203: end loop;
204:
205: initjvmaux.rollbackset;
206:
207: dbms_output.put_line('delete from error$');
208:
209: if remove_all then
210: select count(*) into total_to_delete from error$
211: where obj# in (select obj# from java$rmjvm$aux);

Line 219: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));

215: where type#=28 or type#=29 or type#=30 or type#=56);
216: end if;
217: commit;
218: loop
219: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
220: initjvmaux.rollbackset;
221: if remove_all then
222: delete from error$ where obj# in
223: (select obj# from java$rmjvm$aux)

Line 237: dbms_output.put_line('delete from objauth$');

233: end loop;
234:
235: initjvmaux.rollbackset;
236:
237: dbms_output.put_line('delete from objauth$');
238:
239: select count(*) into total_to_delete from objauth$
240: where obj# in (select obj# from java$rmjvm$aux);
241: commit;

Line 243: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));

239: select count(*) into total_to_delete from objauth$
240: where obj# in (select obj# from java$rmjvm$aux);
241: commit;
242: loop
243: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
244: initjvmaux.rollbackset;
245: delete from objauth$ where obj# in (select obj# from java$rmjvm$aux)
246: and rownum <= deletions_per_iteration;
247: commit;

Line 254: dbms_output.put_line('delete from javaobj$');

250: end loop;
251:
252: initjvmaux.rollbackset;
253:
254: dbms_output.put_line('delete from javaobj$');
255:
256: select count(*) into total_to_delete from javaobj$
257: where obj# in (select obj# from java$rmjvm$aux);
258: commit;

Line 260: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));

256: select count(*) into total_to_delete from javaobj$
257: where obj# in (select obj# from java$rmjvm$aux);
258: commit;
259: loop
260: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
261: initjvmaux.rollbackset;
262: delete from javaobj$ where obj# in (select obj# from java$rmjvm$aux)
263: and rownum <= deletions_per_iteration;
264: commit;

Line 271: dbms_output.put_line('delete from access$');

267: end loop;
268:
269: initjvmaux.rollbackset;
270:
271: dbms_output.put_line('delete from access$');
272:
273: select count(*) into total_to_delete from access$
274: where d_obj# in (select obj# from java$rmjvm$aux);
275: commit;

Line 277: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));

273: select count(*) into total_to_delete from access$
274: where d_obj# in (select obj# from java$rmjvm$aux);
275: commit;
276: loop
277: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
278: initjvmaux.rollbackset;
279: delete from access$ where d_obj# in (select obj# from java$rmjvm$aux)
280: and rownum <= deletions_per_iteration;
281: commit;

Line 289: dbms_output.put_line('delete from javasnm$');

285:
286: if remove_all then
287: initjvmaux.rollbackset;
288:
289: dbms_output.put_line('delete from javasnm$');
290: delete from javasnm$;
291: commit;
292: end if;
293:

Line 296: dbms_output.put_line('delete from idl_ub1$');

292: end if;
293:
294: initjvmaux.rollbackset;
295:
296: dbms_output.put_line('delete from idl_ub1$');
297:
298: select count(*) into total_to_delete
299: from idl_ub1$ where obj# in (select obj# from java$rmjvm$aux);
300: commit;

Line 302: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));

298: select count(*) into total_to_delete
299: from idl_ub1$ where obj# in (select obj# from java$rmjvm$aux);
300: commit;
301: loop
302: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
303: initjvmaux.rollbackset;
304: delete from idl_ub1$ where obj# in (select obj# from java$rmjvm$aux)
305: and rownum <= deletions_per_iteration;
306: commit;

Line 311: dbms_output.put_line('delete from idl_ub2$');

307: exit when total_to_delete <= deletions_per_iteration;
308: total_to_delete := total_to_delete - deletions_per_iteration;
309: end loop;
310:
311: dbms_output.put_line('delete from idl_ub2$');
312:
313: execute immediate
314: 'select count(*) from idl_ub2$ ' ||
315: 'where obj# in (select obj# from java$rmjvm$aux)' into total_to_delete;

Line 318: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));

314: 'select count(*) from idl_ub2$ ' ||
315: 'where obj# in (select obj# from java$rmjvm$aux)' into total_to_delete;
316: commit;
317: loop
318: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
319: initjvmaux.rollbackset;
320: execute immediate
321: 'delete from idl_ub2$ where obj# in (select obj# from java$rmjvm$aux) ' ||
322: 'and rownum <= :deletions_per_iteration' using deletions_per_iteration;

Line 328: dbms_output.put_line('delete from idl_char$');

324: exit when total_to_delete <= deletions_per_iteration;
325: total_to_delete := total_to_delete - deletions_per_iteration;
326: end loop;
327:
328: dbms_output.put_line('delete from idl_char$');
329:
330: select count(*) into total_to_delete
331: from idl_char$ where obj# in (select obj# from java$rmjvm$aux);
332: commit;

Line 334: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));

330: select count(*) into total_to_delete
331: from idl_char$ where obj# in (select obj# from java$rmjvm$aux);
332: commit;
333: loop
334: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
335: initjvmaux.rollbackset;
336: delete from idl_char$ where obj# in (select obj# from java$rmjvm$aux)
337: and rownum <= deletions_per_iteration;
338: commit;

Line 343: dbms_output.put_line('delete from idl_sb4$');

339: exit when total_to_delete <= deletions_per_iteration;
340: total_to_delete := total_to_delete - deletions_per_iteration;
341: end loop;
342:
343: dbms_output.put_line('delete from idl_sb4$');
344:
345: execute immediate
346: 'select count(*) from idl_sb4$ ' ||
347: 'where obj# in (select obj# from java$rmjvm$aux)' into total_to_delete;

Line 350: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));

346: 'select count(*) from idl_sb4$ ' ||
347: 'where obj# in (select obj# from java$rmjvm$aux)' into total_to_delete;
348: commit;
349: loop
350: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
351: initjvmaux.rollbackset;
352: execute immediate
353: 'delete from idl_sb4$ where obj# in (select obj# from java$rmjvm$aux) ' ||
354: 'and rownum <= :deletions_per_iteration' using deletions_per_iteration;

Line 360: dbms_output.put_line('delete from obj$');

356: exit when total_to_delete <= deletions_per_iteration;
357: total_to_delete := total_to_delete - deletions_per_iteration;
358: end loop;
359:
360: dbms_output.put_line('delete from obj$');
361: --
362: -- only delete from obj$ if all the java information was deleted
363: -- from the other tables correctly. Once we run this delete
364: -- there is no going back to remove the information from

Line 437: dbms_output.put_line('All java objects removed');

433: commit;
434: delete from java$rmjvm$aux;
435: commit;
436:
437: dbms_output.put_line('All java objects removed');
438: ELSE
439: dbms_output.put_line('c1: '||c1||' c2: '||c2||' c3: '||c3||
440: ' c4: '||c4||' c5: '||c5||' c6: '||c6);
441: dbms_output.put_line('Java objects not completely removed. ' ||

Line 439: dbms_output.put_line('c1: '||c1||' c2: '||c2||' c3: '||c3||

435: commit;
436:
437: dbms_output.put_line('All java objects removed');
438: ELSE
439: dbms_output.put_line('c1: '||c1||' c2: '||c2||' c3: '||c3||
440: ' c4: '||c4||' c5: '||c5||' c6: '||c6);
441: dbms_output.put_line('Java objects not completely removed. ' ||
442: 'Rerun rmjvm.run');
443: END IF;

Line 441: dbms_output.put_line('Java objects not completely removed. ' ||

437: dbms_output.put_line('All java objects removed');
438: ELSE
439: dbms_output.put_line('c1: '||c1||' c2: '||c2||' c3: '||c3||
440: ' c4: '||c4||' c5: '||c5||' c6: '||c6);
441: dbms_output.put_line('Java objects not completely removed. ' ||
442: 'Rerun rmjvm.run');
443: END IF;
444: END;
445:

Line 452: dbms_output.put_line('flush shared_pool');

448: commit;
449:
450: initjvmaux.rollbackcleanup;
451:
452: dbms_output.put_line('flush shared_pool');
453: execute immediate 'alter system flush shared_pool';
454: execute immediate 'alter system flush shared_pool';
455: execute immediate 'alter system flush shared_pool';
456: end;

Line 499: dbms_output.enable(10000000); -- biggest size we can get

495: -- do such stripping, allowing 8.1.6 optimization codes that cannot
496: -- be correctly interpreted by 8.1.5 to remain in place.
497: --
498:
499: dbms_output.enable(10000000); -- biggest size we can get
500: initjvmaux.rollbacksetup;
501: commit;
502: initjvmaux.rollbackset;
503:

Line 517: dbms_output.put_line('strip 8.1.6 bytecode optimizations');

513:
514: commit;
515: initjvmaux.rollbackset;
516:
517: dbms_output.put_line('strip 8.1.6 bytecode optimizations');
518:
519: DECLARE
520: done boolean;
521: already_done number := 0;