Using Oracle
dbms_utility
The Oracle dbms_utility package to get a data block
address. Many Oracle scripts will provide
you with the file number and block number,
but you must then translate this information
into the actual data block address (DBA) for
the block, dbms_utility simplifies the
process..
For example, to dump file number 101, block
50, you could enter the following PL/SQL.
variable dba varchar2;
exec :dba :=
dbms_utility.make_data_block_address(101,50);
print dba
Displaying Time in Milliseconds:
You can use the Oracle dbms_utility.get_time
function to display the time in 100th of
second
SELECT dbms_utility.get_time FROM dual;
See related dbms_utility notes below:
|
|
