# HG changeset patch # User Oleksandr Gavenko # Date 1372196434 -10800 # Node ID c01be7e7545f2e3adeb634b7ece9ae3192c86a8e # Parent 7679a0100061e468a1ce17d15c31c39f6b345349# Parent 2f1d56eb36ca55b028743c6cba3ca2c7a5fcd90d merged diff -r 2f1d56eb36ca -r c01be7e7545f fs.rst --- a/fs.rst Sat May 25 11:23:08 2013 +0300 +++ b/fs.rst Wed Jun 26 00:40:34 2013 +0300 @@ -161,3 +161,17 @@ UUID=D474CB9874CB7C2C /mnt/winbin ntfs-3g rw,default_permissions,gid=1000,fmask=113,dmask=002,noatime,silent 0 0 ... +Stop fsck running every 27 boots. +================================= + +Check current settings:: + + $ tune2fs -l /dev/$DISK + +and tune them:: + + $ tune2fs -c 0 /dev/$DISK + $ tune2fs -i 2w /dev/$DISK + +Or disable checks in ``/etc/fstab`` completely (by setting last colon to ``0`` +value)! \ No newline at end of file diff -r 2f1d56eb36ca -r c01be7e7545f oracle.rst --- a/oracle.rst Sat May 25 11:23:08 2013 +0300 +++ b/oracle.rst Wed Jun 26 00:40:34 2013 +0300 @@ -27,6 +27,20 @@ Oracle Reports is a tool for developing reports against data stored in an Oracle database. +Useful PL/SQL stub. +=================== +:: + + set serveroutput on; + set autotrace on statistics; + set timing on; + + declare + begin + null; + end; + / + Информация о таблицах в БД Oracle. ================================== @@ -117,3 +131,18 @@ ============================== * http://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm + +Adjust date format. +=================== +:: + + column parameter format a32; + column value format a32; + select parameter, value from v$nls_parameters; + + alter session set NLS_DATE_FORMAT = 'yyyy-mm-dd HH:MI:SS'; + alter session set NLS_TIMESTAMP_FORMAT = 'MI:SS.FF6'; + alter session set NLS_TIME_FORMAT = 'HH24:MI:SS.FF6'; + + select sysdate from dual; +