../E40758-03.epub /> ../E40758-03.mobi />
DBMS_ODCI package contains a single user function related to the use of Data Cartridges.
This chapter contains the following topic:
Returns the approximate number of CPU instructions (in thousands) corresponding to a specified time interval (in seconds)
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.
||The elapsed time in seconds that it takes to execute a function.|