merged
authorOleksandr Gavenko <gavenkoa@gmail.com>
Wed, 26 Jun 2013 00:40:34 +0300
changeset 1497 c01be7e7545f
parent 1496 7679a0100061 (diff)
parent 1492 2f1d56eb36ca (current diff)
child 1498 094d7e74252a
child 1501 b9fa2b857249
merged
--- 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
--- 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;
+