Results for DBMS_UTILITY


1 to 20 of 117 results. Prev  Next
Results per page:   20  | 40 | 60


Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 1 of 2

79 DBMS_UTILITYThis package provides various utility subprograms. DBMS_UTILITY submits a job for each partition … reported in SNP trace files. This chapter discusses the following topics: Requirements and Types for DBMS_UTILITY Summary of DBMS_UTILITY Subprograms

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

Summary of DBMS_UTILITY SubprogramsTable 79-1 DBMS_UTILITY Subprograms Subprogram Description COMPILE_SCHEMA Procedure Compiles all

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 1 of 2

Requirements and Types for DBMS_UTILITYRequirements DBMS_UTILITY runs with the privileges of the calling user for the NAME_RESOLVE

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

ParametersTable 79-2 COMPILE_SCHEMA Procedure Parameters Parameter Description schema Name of the schema.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

SyntaxDBMS_UTILITY.FORMAT_ERROR_STACK RETURN VARCHAR2;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

FORMAT_CALL_STACK FunctionThis function formats the current call stack. This can be used on any stored procedure or trigger to access the call stack. This can be useful for debugging.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

GET_PARAMETER_VALUE FunctionThis function gets the value of specified init.ora parameter.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

ExampleDECLARE parnam VARCHAR2(256); intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp:= dbms_utility.get_parameter_value('max_dump_file_size', intval, strval); dbms_output.put('parameter value is: '); IF partyp = 1 THEN dbms_output.put_line(strval); ELSE dbms_output.put_line(intval); END IF; IF partyp = 1 THEN dbms_output.put('parameter value length is: '); dbms_output.put_line(intval);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

MAKE_DATA_BLOCK_ADDRESS FunctionThis function creates a data block address given a file number and a block number. A data block address is the internal structure used to identify a block in the database. This function is useful when accessing certain fixed tables that contain data block addresses.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

ReturnsTable 79-15 MAKE_DATA_BLOCK_ADDRESS Function Returns Returns Description dba Data block address.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

DATA_BLOCK_ADDRESS_FILE FunctionThis function gets the file number part of a data block address.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

Pragmaspragma restrict_references(data_block_address_block, WNDS, RNDS, WNPS, RNPS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

ParametersTable 79-22 EXEC_DDL_STATEMENT Procedure Parameters Parameter Description parse_string DDL statement to be executed.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

CURRENT_INSTANCE FunctionThis function returns the current connected instance number. It returns NULL when connected instance is down.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

ParametersTable 79-23 ACTIVE_INSTANCES Procedure Parameters Procedure Description instance_table Contains a list of the active instance numbers and names. When no instance is up, the list is empty. instance_count Number of active instances. Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

COMPILE_SCHEMA ProcedureThis procedure compiles all procedures, functions, packages, and triggers in the specified schema. After calling this procedure, you should select from view ALL_OBJECTS for items with status of INVALID to see if all objects were successfully compiled. To see the errors associated with INVALID objects, you may use the Enterprise Manager command: SHOW ERRORS.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

SyntaxDBMS_UTILITY.COMPILE_SCHEMA ( schema VARCHAR2);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

Pragmaspragma restrict_references(format_call_stack,WNDS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

ReturnsThis returns the call stack, up to 2000 bytes.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

ReturnsTime is the number of 100th's of a second from some arbitrary epoch.





Was this page helpful?

Integrated Cloud Applications & Platform Services