home | O'Reilly's CD bookshelfs | FreeBSD | Linux | Cisco | Cisco Exam  


C.16 DBMS_UTILITY

The DBMS_UTILITY package includes several utility modules you might find useful when managing objects in the database.

C.16.1 The ANALYZE_SCHEMA procedure

This procedure analyzes all the tables, clusters, and indexes in the specified schema. The specification is:

PROCEDURE DBMS_UTILITY.ANALYZE_SCHEMA
   (schema VARCHAR2,
    method VARCHAR2,
    estimate_rows NUMBER DEFAULT NULL,
    estimate_percent NUMBER DEFAULT NULL);

C.16.2 The COMMA_TO_TABLE procedure

The COMMA_TO_TABLE procedure parses a comma-delimited list and places each name into a PL/SQL table. The specification is:

PROCEDURE DBMS_UTILITY.COMMA_TO_TABLE
   (list IN VARCHAR2,
    tablen OUT BINARY_INTEGER,
    tab OUT uncl_array);

C.16.3 The COMPILE_SCHEMA procedure

This procedure compiles all procedures, functions, and packages in the specified schema. The specification is:

PROCEDURE DBMS_UTILITY.COMPILE_SCHEMA (schema VARCHAR2);

C.16.4 The FORMAT_CALL_STACK function

This function formats and returns the current call stack. You can use this function to access the call stack in your program. The specification is:

FUNCTION DBMS_UTILITY.FORMAT_CALL_STACK RETURN VARCHAR2;

C.16.5 The FORMAT_ERROR_STACK function

This function formats and returns the current error stack. You might use this in an exception handler to examine the sequence of errors raised. The specification is:

FUNCTION DBMS_UTILITY.FORMAT_ERROR_STACK RETURN VARCHAR2;

C.16.6 The GET_TIME function

This function returns the number of 100ths of seconds which have elapsed from an arbitrary time. Without GET_TIME, Oracle functions can only record and provide elapsed time in second intervals, which is a very coarse granularity in today's world of computing. With GET_TIME, you can get a much finer understanding of the processing times of lines in your program. The specification is:

FUNCTION DBMS_UTILITY.GET_TIME RETURN NUMBER;

C.16.7 The IS_PARALLEL_SERVER function

This function helps determine if the database is running in Parallel Server mode. The specification is:

FUNCTION DBMS_UTILITY.IS_PARALLEL_SERVER RETURN BOOLEAN;

The function returns TRUE if the database is running in Parallel Server mode; otherwise it returns FALSE.

C.16.8 The NAME_RESOLVE procedure

This procedure resolves the name of an object into its component parts, performing synonym translations as necessary. The specification is:

PROCEDURE DBMS_UTILITY.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);

C.16.9 The NAME_TOKENIZE procedure

The NAME_TOKENIZE procedure calls the PL/SQL parser to parse the given name that is in the following format:

a [ . b [. c]] [@dblink ]

where dblink is the name of a database link. NAME_TOKENIZE follows these rules:

  • Strips off all double quotes

  • Converts to uppercase if there are no quotes

  • Ignores any inline comments

  • Does no semantic analysis

  • Leaves any missing values as NULL

The specification is:

PROCEDURE DBMS_UTILITY.NAME_TOKENIZE
   (name  IN VARCHAR2,
    a OUT VARCHAR2,
    b OUT VARCHAR2,
    c OUT VARCHAR2,
    dblink OUT VARCHAR2,
    nextpos OUT BINARY_INTEGER);

C.16.10 The PORT_STRING function

The PORT_STRING function returns a string that uniquely identifies the version of Oracle Server and the platform or operating system of the current database instance. The specification is:

FUNCTION DBMS_UTILITY.PORT_STRING RETURN VARCHAR2;

C.16.11 The TABLE_TO_COMMA procedure

The TABLE_TO_COMMA procedure converts a PL/SQL table into a comma-delimited list. The specification is:

PROCEDURE DBMS_UTILITY.TABLE_TO_COMMA
   (tab IN uncl_array,
   tablen OUT BINARY_INTEGER,
   list OUT VARCHAR2);








Previous: C.15 DBMS_TRANSACTION Oracle PL/SQL Programming, 2nd Edition Next: C.17 UTL_FILE
C.15 DBMS_TRANSACTION Book Index C.17 UTL_FILE

The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference