Wednesday 15 July 2015

oracle - Change format of 'timing show' or 'set timing on' in sqlplus (to increase precision) -


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