SYS.INITJVMAUX SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 49

    select num into x from v$parameter
       where name='undo_management' and value='AUTO';

Line: 63

    select segment_name into rollback_segment_name from dba_rollback_segs
      where tablespace_name='SYSTEM' and next_extent*max_extents>100000000 and
            status='ONLINE' and initial_extent>1000000 and rownum < 2;

Line: 74

        select segment_name into deallocate_rollback_name
        from dba_rollback_segs where segment_name = rollback_segment_name;

Line: 178

    select rmjvmtime into rmjvmtime from java$jvm$status
       where rmjvmtime = (select startup_time from v$instance);

Line: 205

      select 0 into free from v$parameter2
         where name='event' and value like '%10049 trace%'
         and not exists (select * from v$parameter2
                         where name='event'
                         and value='10049 trace name all off');

Line: 214

      select current_size into sga_target_value
        from v$memory_dynamic_components
        where component='SGA Target';

Line: 221

        select sum(bytes) into free from v$sgastat where pool='java pool';

Line: 232

        select bytes into free from v$sgastat
           where name='free memory' and
                 pool='shared pool' and
                 bytes < shared_pool_limit;

Line: 260

      select sum(length) into free from idl_ub1$,x$joxft
         where obj#=joxftobn and bitand(joxftflags,96)!=0;

Line: 263

      select sum(length) into free from idl_ub1$ u,obj$ o
         where o.obj#=u.obj# and o.type#=56 and name like 'Locale%';

Line: 266

      select sum(bytes) into free from dba_free_space
         where tablespace_name='SYSTEM';

Line: 277

  delete from java$jvm$steps$done where step = step_name;

Line: 311

    select status, version into stat, registry_version from dba_registry
      where comp_id='JAVAVM';

Line: 329

  SELECT version INTO v from v$instance;

Line: 402

    select action,inprogress into lastaction,inprogress from java$jvm$status;

Line: 406

    insert into java$jvm$status values('NONE','N',null,null,'TRUE');

Line: 448

    update java$jvm$status set punting = 'TRUE';

Line: 451

    update java$jvm$status set punting = 'FALSE';

Line: 454

    update java$jvm$status set
      action = newaction,
      inprogress = 'Y',
      execid = currentexecid,
      punting = 'FALSE';

Line: 474

    update java$jvm$status set punting = 'FALSE';

Line: 479

      select action into action from java$jvm$status where
         punting = 'FALSE' and
         execid = currentexecid;

Line: 482

      delete from java$jvm$steps$done;

Line: 483

      update java$jvm$status set inprogress = 'N', execid = null;

Line: 487

      update java$jvm$status set punting = 'FALSE';

Line: 507

    update java$jvm$status set action = 'LOAD';

Line: 520

    select execid, punting into execid, punting from java$jvm$status;

Line: 525

        update java$jvm$status set punting = 'TRUE';

Line: 528

          select step into oldstep from java$jvm$steps$done where step = newstep;

Line: 532

          update java$jvm$status set punting = 'TRUE';

Line: 536

        update java$jvm$status set punting = 'TRUE';

Line: 540

    insert into java$jvm$status values('NONE','N',null,null,'TRUE');

Line: 559

    insert into java$jvm$steps$done values(current_step);

Line: 562

  update java$jvm$status set punting = 'FALSE';

Line: 569

  select sid||'-'||serial# into execid from v$session
         where sid = (select unique(sid) from v$mystat);

Line: 590

  update obj$ set status=5 where obj#=(select obj# from obj$,javasnm$
    where owner#=0 and type#=29 and short(+)=name and
    nvl(longdbcs,name)='oracle/aurora/rdbms/Compiler');

Line: 595

    cursor C1 is select
       u.name, o.name
       from obj$ o,user$ u where o.type#=56 and u.user#=o.owner#;

Line: 609

      select count(*) into iterations from obj$ where type#=56;

Line: 637

  drp('delete from java$policy$shared$table');

Line: 638

  update obj$ set status=1 where obj#=(select obj# from obj$,javasnm$
    where owner#=0 and type#=29 and short(+)=name and
    nvl(longdbcs,name)='oracle/aurora/rdbms/Compiler');

Line: 652

       'select * from sys.java$jvm$system$property$defs ' ||
       'where user_name=SYS_CONTEXT(''userenv'',''SESSION_USER'') ' ||
       'with check option');

Line: 655

  exec('grant update,select,delete,insert on ' ||
        'SYS.java_system_property_settings to public');