--- 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;
+