--- a/audio.rst Wed Oct 15 02:26:42 2014 +0300
+++ b/audio.rst Fri Oct 17 22:40:46 2014 +0300
@@ -34,6 +34,14 @@
$ pactl list
+Play simple sounds.
+===================
+::
+
+ $ sudo apt-get install sox
+ $ play -n synth sin 440 vol -40dB
+ $ play -n synth 10 square 100-10000 synth sin fmod 100 vol -40dB
+
Suitable convertors?
====================
::
@@ -44,14 +52,9 @@
$ sudo apt-get install sox
-List of sox supported format.
-=============================
+List of sox supported format: See sox(1).
-See sox(1).
-
-List of ffmpeg supported format.
-================================
-::
+List of ffmpeg supported format::
$ ffmpeg -formats
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/csv.rst Fri Oct 17 22:40:46 2014 +0300
@@ -0,0 +1,17 @@
+.. -*- coding: utf-8; -*-
+.. include:: HEADER.rst
+
+======
+ CSV.
+======
+.. contents::
+
+DBF to CSV.
+===========
+::
+
+ $ sudo aptitude install libdbd-xbase-perl
+ $ dbf_dump --fs="=" BSPR.DBF > BSPR.csv
+
+Seems that ``dbf_dump`` can't quote fields, so use rare char as separator!
+
--- a/java.rst Wed Oct 15 02:26:42 2014 +0300
+++ b/java.rst Fri Oct 17 22:40:46 2014 +0300
@@ -180,6 +180,10 @@
$ jdb -attach $PORT
+Dump current thread traces and memory statistic to stdout::
+
+ $ kill -QUIT $PID
+
Find jar by class.
==================
--- a/maven.rst Wed Oct 15 02:26:42 2014 +0300
+++ b/maven.rst Fri Oct 17 22:40:46 2014 +0300
@@ -93,6 +93,12 @@
mvn dependency:resolve -Dclassifier=javadoc
mvn dependency:resolve -Dclassifier=sources
+Deploy parent pom without building children.
+============================================
+::
+
+ $ mvn -N deploy
+
Run Ant from Maven.
===================
--- a/oracle.rst Wed Oct 15 02:26:42 2014 +0300
+++ b/oracle.rst Fri Oct 17 22:40:46 2014 +0300
@@ -41,38 +41,70 @@
end;
/
-Информация о таблицах в БД Oracle.
-==================================
+Database info.
+==============
+
+List of users::
+
+ select distinct(OWNER) from ALL_TABLES;
-Список таблиц::
+List of current user owned tables::
- select * from user_tables;
+ select * from USER_TABLES;
+ select TABLE_NAME from USER_TABLES;
-Занимаемый размер таблиц и индексов::
+List of tables by owner::
- select segment_name, segment_type, sum(bytes) from user_extents
- group by segment_name, segment_type order by sum(bytes);
+ select OWNER || '.' || TABLE_NAME from ALL_TABLES
+ order by OWNER;
- select sum(bytes) from user_extents;
+List of current user table sizes::
+
+ select SEGMENT_NAME, SEGMENT_TYPE, sum(BYTES) from USER_EXTENTS
+ group by SEGMENT_NAME, SEGMENT_TYPE order by sum(BYTES);
-Список индексов по таблицам::
+ select sum(BYTES) from USER_EXTENTS;
+
+Tables indexes::
- select * from user_indexes order by table_name;
+ select * from USER_INDEXES order by TABLE_NAME;
-Список размеров индексов по таблицам::
+List of index sizes::
select index_name, table_name, sum(user_extents.bytes) as bytes from user_indexes
left outer join user_extents on user_extents.segment_name = table_name
group by index_name, table_name
order by table_name;
-Список ограничений::
+List of tables without primary keys::
- select * from user_constraints;
+ select OWNER || '.' || TABLE_NAME from ALL_TABLES
+ where TABLE_NAME not in (
+ select distinct TABLE_NAME from ALL_CONSTRAINTS where CONSTRAINT_TYPE = 'P'
+ ) and OWNER in ('USER1', 'USER2')
+ order by OWNER, TABLE_NAME;
+
+List of currenct user constraints::
+
+ select * from USER_CONSTRAINTS;
+
+List of tablespaces::
-Используемое пространство таблиц::
+ select distinct TABLESPACE_NAME from USER_TABLES;
+
+List of current user permissions::
+
+ select * from SESSION_PRIVS;
+
+List of user permissions to tables::
- select distinct tablespace_name from user_tables;
+ select * from ALL_TAB_PRIVS where TABLE_SCHEMA not like '%SYS' and TABLE_SCHEMA not like 'SYS%';
+
+List of user privileges::
+
+ select * from USER_SYS_PRIVS
+ select * from USER_TAB_PRIVS
+ select * from USER_ROLE_PRIVS
Profiling.
==========
--- a/ssh.rst Wed Oct 15 02:26:42 2014 +0300
+++ b/ssh.rst Fri Oct 17 22:40:46 2014 +0300
@@ -22,7 +22,7 @@
$ ssh-keygen -t dsa -f my_dsa_key # store priv key under my_dsa_key
# and pub key under my_dsa_key.pub
- $ ssh-keygen -y -f my_dsa_key # recover pub key from priv
+ $ ssh-keygen -y -f ~/.ssh/id_dsa >~/.ssh/id_dsa.pub # recover pub key from priv
$ ssh-keygen -p -N "newphrase" -P "oldphrase" -f ~/.ssh/id_dsa
# change passphrase of priv key
--- a/web-search.rst Wed Oct 15 02:26:42 2014 +0300
+++ b/web-search.rst Fri Oct 17 22:40:46 2014 +0300
@@ -25,10 +25,11 @@
=================
http://www.mail-archive.com/
- turns your mailing list into a searchable archive
+ Turns your mailing list into a searchable archive.
http://www.gmane.org/
- USENET gateway/archive service, some lists may have delay in
- indexing.
+ USENET gateway/archive service, some lists may have delay in indexing.
+ http://markmail.org/
+ Free service for searching mailing list archives.
Image by image search.
======================