HISTTIMEFORMAT: How to See the Linux commands History with Date and Time?

Linux command prompt provides history of all commands which got executed under that login. If you give normal history command it will not show the date and time for the command execution. But in many cases you would need the date and time of the command execution which we can easily get it by formatting the HISTTIMEFORMAT environment variable.
Please find some examples and allowable formats below.
Example
  1. Normal history command output
$ history|more
    2  . oraenv
    3  export ORACLE_SID=PRODCMT41
    4  sqlplus / as sysdba
    5  echo $ORACLE_SID
  1. Formatted history command output – With date
$ export HISTTIMEFORMAT='%D'
$ history |more
   30  07/19/12 date
   31  07/19/12 date
   32  07/19/12 sqlplus "/as sysdba"
   33  07/19/12 cd
   34  07/19/12 ls –tlr
  1. Formatted history command with date and Day
$  export HISTTIMEFORMAT='%D %A:'
$  history |more
   42  07/19/12 Thursday:ls -ltrh
   43  07/19/12 Thursday:pwd
   44  07/19/12 Thursday:sqlplus "/as sysdba"

These are the format which you can use.
       %%     a literal %

       %a     abbreviated weekday name (e.g., Sun)

       %A     full weekday name (e.g., Sunday)

       %b     abbreviated month name (e.g., Jan)

       %B     full month name (e.g., January)
       %c     date and time (e.g., Thu Mar  3 23:05:25 2005)

       %C     century; like %Y, except omit last two digits (e.g., 21)

       %d     day of month (e.g, 01)

       %D     date; same as %m/%d/%y

       %e     day of month, space padded; same as %_d

       %F     full date; same as %Y-%m-%d

       %g     last two digits of year of ISO week number (see %G)

       %G     year of ISO week number (see %V); normally useful only with %V

       %h     same as %b

       %H     hour (00..23)

       %I     hour (01..12)

       %j     day of year (001..366)

       %k     hour ( 0..23)
       %l     hour ( 1..12)

       %m     month (01..12)

       %M     minute (00..59)

       %n     a newline

       %N     nanoseconds (000000000..999999999)

       %p     equivalent of either AM or PM; blank if not known

       %P     like %p, but lower case

       %r     12-hour clock time (e.g., 11:11:04 PM)

       %R     24-hour hour and minute; same as %H:%M

       %s     seconds since 1970-01-01 00:00:00 UTC

       %S     second (00..60)

       %t     a tab

       %T     time; same as %H:%M:%S
       %u     day of week (1..7); 1 is Monday

       %U     week number of year, with Sunday as first day of week (00..53)

       %V     ISO week number, with Monday as first day of week (01..53)

       %w     day of week (0..6); 0 is Sunday

       %W     week number of year, with Monday as first day of week (00..53)

       %x     date representation (e.g., 12/31/99)

       %X     time representation (e.g., 23:13:48)

       %y     last two digits of year (00..99)

       %Y     year

       %z     +hhmm numeric timezone (e.g., -0400)

       %:z    +hh:mm numeric timezone (e.g., -04:00)

       %::z   +hh:mm:ss numeric time zone (e.g., -04:00:00)

       %:::z  numeric time zone with : to necessary precision (e.g., -04, +05:30)
       %Z     alphabetic time zone abbreviation (e.g., EDT)
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google