[Appendix C] C.16 DBMS_UTILITYAppendix CBuilt-In Packages C.16 DBMS_UTILITYThe DBMS_UTILITY package includes several utility modules you might find useful when managing objects in the database. C.16.1 The ANALYZE_SCHEMA procedureThis 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 procedureThe 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 procedureThis 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 functionThis 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 functionThis 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 functionThis 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 functionThis 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 procedureThis 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 procedureThe 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 quotesConverts to uppercase if there are no quotesIgnores any inline commentsDoes no semantic analysisLeaves any missing values as NULLThe 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 functionThe 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 procedureThe 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); C.15 DBMS_TRANSACTIONC.17 UTL_FILE Copyright (c) 2000 O'Reilly & Associates. All rights reserved.