dbms_utility

procedure active_instances (
 instance_table                 out table of record                 ,
 instance_count                 out number                          
);

procedure analyze_database (
 method                          in varchar2                        ,
 estimate_rows                   in number                   default,
 estimate_percent                in number                   default,
 method_opt                      in varchar2                 default
);

procedure analyze_part_object (
 schema                          in varchar2                 default,
 object_name                     in varchar2                 default,
 object_type                     in char                     default,
 command_type                    in char                     default,
 command_opt                     in varchar2                 default,
 sample_clause                   in varchar2                 default
);

procedure analyze_schema (
 schema                          in varchar2                        ,
 method                          in varchar2                        ,
 estimate_rows                   in number                   default,
 estimate_percent                in number                   default,
 method_opt                      in varchar2                 default
);

procedure canonicalize (
 name                            in varchar2                        ,
 canon_name                     out varchar2                        ,
 canon_len                       in binary_integer                  
);

procedure comma_to_table (
 list                            in varchar2                        ,
 tablen                         out binary_integer                  ,
 tab                            out table of varchar2(227)          
);

procedure comma_to_table (
 list                            in varchar2                        ,
 tablen                         out binary_integer                  ,
 tab                            out table of varchar2(4000)         
);

procedure compile_schema (
 schema                          in varchar2                        ,
 compile_all                     in boolean                  default
);

procedure create_alter_type_error_table (
 schema_name                     in varchar2                        ,
 table_name                      in varchar2                        
);

function current_instance returns number (
);

function data_block_address_block returns number (
 dba                             in number                          
);

function data_block_address_file returns number (
 dba                             in number                          
);

procedure db_version (
 version                        out varchar2                        ,
 compatibility                  out varchar2                        
);

procedure exec_ddl_statement (
 parse_string                    in varchar2                        
);

function format_call_stack returns varchar2 (
);

function format_error_backtrace returns varchar2 (
);

function format_error_stack returns varchar2 (
);

function get_cpu_time returns number (
);

procedure get_dependency (
 type                            in varchar2                        ,
 schema                          in varchar2                        ,
 name                            in varchar2                        
);

function get_endianness returns number (
);

function get_hash_value returns number (
 name                            in varchar2                        ,
 base                            in number                          ,
 hash_size                       in number                          
);

function get_parameter_value returns binary_integer (
 parnam                          in varchar2                        ,
 intval                         out binary_integer          in/        ,
 strval                         out varchar2                in/        ,
 listno                          in binary_integer           default
);

function get_sql_hash returns number (
 name                            in varchar2                        ,
 hash                           out raw                             ,
 pre10ihash                     out number                          
);

function get_time returns number (
);

procedure get_tz_transitions (
 regionid                        in number                          ,
 transitions                    out raw(32767)                      
);

function is_bit_set returns number (
 r                               in raw                             ,
 n                               in number                          
);

function is_cluster_database returns boolean (
);

function make_data_block_address returns number (
 file                            in number                          ,
 block                           in number                          
);

procedure name_resolve (
 name                            in varchar2                        ,
 context                         in number                          ,
 schema                         out varchar2                        ,
 part1                          out varchar2                        ,
 part2                          out varchar2                        ,
 dblink                         out varchar2                        ,
 part1_type                     out number                          ,
 object_number                  out number                          
);

declare
  context       number := 2;
  schema        varchar2(30);
  part1         varchar2(30);
  part2         varchar2(30);
  dblink        varchar2(128);
  part1_type    number;
  object_number number;
begin

  dbms_utility.name_resolve( '&1', context, schema, part1, part2, dblink, part1_type, object_number);

  dbms_output.put_line('Schema:      ' || schema);
  dbms_output.put_line('Part 1:      ' || part1);
  dbms_output.put_line('Part 2:      ' || part2);
  dbms_output.put_line('DB Link:     ' || dblink);
  dbms_output.put_line('Part 1 type: ' || part1_type);
  dbms_output.put_line('Object No:   ' || object_number);
end;
/

procedure name_tokenize (
 name                            in varchar2                        ,
 a                              out varchar2                        ,
 b                              out varchar2                        ,
 c                              out varchar2                        ,
 dblink                         out varchar2                        ,
 nextpos                        out binary_integer                  
);

function old_current_schema returns varchar2 (
);

function old_current_user returns varchar2 (
);

function port_string returns varchar2 (
);

SQL> select dbms_utility.port_string from dual;

PORT_STRING
-----------------------------------------------
IBMPC/WIN_NT-8.1.0

function sqlid_to_sqlhash returns number (
 sql_id                          in varchar2                        
);

procedure table_to_comma (
 tab                             in table of varchar2(227)          ,
 tablen                         out binary_integer                  ,
 list                           out varchar2                        
);

procedure table_to_comma (
 tab                             in table of varchar2(4000)         ,
 tablen                         out binary_integer                  ,
 list                           out varchar2                        
);

procedure validate (
 object_id                       in number                          
);