Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)

Part Number E25788-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
ARPLS366

97 DBMS_ODCI

DBMS_ODCI package contains a single user function related to the use of Data Cartridges.

See Also:

This chapter contains the following topic:

ARPLS67280

Summary of DBMS_ODCI Subprograms

ARPLS67281Table 97-1 DBMS_ODCI Package Subprograms

Subprogram Description

ESTIMATE_CPU_UNITS Function

Returns the approximate number of CPU instructions (in thousands) corresponding to a specified time interval (in seconds)


ARPLS67282

ESTIMATE_CPU_UNITS Function

This function returns the approximate number of CPU instructions (in thousands) corresponding to a specified time interval (in seconds). This information can be used to associate the CPU cost with a user-defined function for the extensible optimizer.

The function takes as input the elapsed time of the user function, measures CPU units by multiplying the elapsed time by the processor speed of the machine, and returns the approximate number of CPU instructions that should be associated with the user function. For a multiprocessor machine, ESTIMATE_CPU_UNITS considers the speed of a single processor.

Syntax

DBMS_ODCI.ESTIMATE_CPU_UNITS(
   elapsed_time     NUMBER) 
  RETURN NUMBER;

Parameters

Parameter Description
elapsed_time The elapsed time in seconds that it takes to execute a function.

Usage Notes

When associating CPU cost with a user-defined function, use the full number of CPU units rather than the number of thousands of CPU units returned by ESTIMATE_CPU_UNITS; multiply the number returned by ESTIMATE_CPU_UNITS by 1,000.

Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Page

  • Summary of DBMS_ODCI Subprograms
    • ESTIMATE_CPU_UNITS Function

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF