I found this setting useful:
set timing on; Or such coding technique:
Start the time; Choose ...; Stop time; But this product uses a few digits for the second partial part:
Ð ?? Ð ° N ?? Ñ ?? Ð ° N ?? Ð²Ñ ?? ÐμÐ¼Ñ ??: 00: 00:? 00.02 is possible to adjust the time Sql output format for * plus I like for time stamps To add more points for the partial part, you want:
change session set NLS_TIMESTAMP_FORMAT = 'MI: SS.FF6'; PS I use select LAST_LOAD_TIME, ELAPSED_TIME, module, SQL_TEXT v $ sql order by LAST_LOAD_TIME by elasped desc For high precision time (microsecond), but this is particularly uncomfortable for PL / SQL.
"itemprop =" text "> I do not think this is possible.
DBMS_UTILITY.GET_TIME also gives you information in each other's 100th.
GET_TIME Function
This function determines the current time of each other at the 100th time. (...)
Source:
(Oracle Database Pl / SQL Package and Type Reference)
No comments:
Post a Comment