yoshikaw

@@ -4,7 +4,7 @@
 
 STDOUT.sync = 1
 
-if / (\d+) rows; (\d+) columns/ =~ `env LANG=C stty -a`
+if / rows (\d+); columns (\d+)/ =~ `env LANG=C stty -a`
   rows = $1.to_i
   cols = $2.to_i
 else

yoshikaw

# while :; do date; sleep 1; done
Wed Jul  1 08:59:41 JST 2015
Wed Jul  1 08:59:42 JST 2015
Wed Jul  1 08:59:43 JST 2015
Wed Jul  1 08:59:44 JST 2015
Wed Jul  1 08:59:45 JST 2015
Wed Jul  1 08:59:46 JST 2015
Wed Jul  1 08:59:47 JST 2015
Wed Jul  1 08:59:48 JST 2015
Wed Jul  1 08:59:49 JST 2015

yoshikaw

SQL> r
  1* select inst_id, start_time,case when time_remaining > 0 then last_update_time+1/24/60/60*time_remaining else last_update_time end last_update_time,elapsed_seconds elaps,(sofar/totalwork)*100 "%",sql_id,qcsid, message from gv$session_longops where instr(message, 'RMAN') != 1 and last_update_time > trunc(sysdate)-3 and totalwork > 0 order by start_time, last_update_time

INST_ID START_TIME          LAST_UPDATE_TIME      ELAPS       % SQL_ID         QCSID MESSAGE
------- ------------------- ------------------- ------- ------- ------------- ------ ------------------------------------------------------------------------------------------------------------------------
      1 2015/06/08 10:57:53 2015/06/08 10:58:19      26  100.00 5r18zhaddnvbp      0 Flashback Database: Flashback Data Applied : 657 out of 657 Megabytes done
...
      1 2015/06/08 15:27:07 2015/06/08 16:00:11    1984  100.00 566xv98dg4pff      0 Table Scan:  SCOTT.TEST_TBL: 22082 out of 22082 Blocks done
      1 2015/06/08 16:15:54 2015

yoshikaw

  1* select count(1) from work_*********

--------------------------------------------------------------------------------------
| Id  | Operation                   | Name           | Rows  | Cost (%CPU)| Time     |
--------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                |     1 |    20   (0)| 00:00:01 |
|   1 |  SORT AGGREGATE             |                |     1 |            |          |
|   2 |   EXTERNAL TABLE ACCESS FULL| WORK_********* |  8168 |    20   (0)| 00:00:01 |
--------------------------------------------------------------------------------------

yoshikaw

@@ -6,14 +6,14 @@
     [email protected]:/usr/obj/usr/src/sys/GENERIC amd64
 FreeBSD clang version 3.3 (tags/RELEASE_33/final 183502) 20130610
 module vtnet already present!
-CPU: QEMU Virtual CPU version 0.12 (2196.49-MHz K8-class CPU)
-  Origin = "AuthenticAMD"  Id = 0x623  Family = 0x6  Model = 0x2  Stepping = 3
-  Features=0x783fbfd<FPU,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,MMX,FXSR,SSE,SSE2>
-  Features2=0x80802001<SSE3,CX16,POPCNT,HV>
+CPU: QEMU Virtual CPU version 2.1.2 (2196.49-MHz K8-class CPU)
+  Origin = "AuthenticAMD"  Id = 0x663  Family = 0x6  Model = 0x6  Stepping = 3

yoshikaw

# docker ps | awk '! /CONTAINER/ { cmd="docker inspect --format \"{{ .NetworkSettings.IPAddress }}\" "$1; cmd | getline t; close(cmd); printf("%-15s %s\n", t, $0) }'

yoshikaw

SQL> l
  1* select 1 from dual;
SQL> r

1
1


Elapsed: 00:00:00.003
SQL> ed

yoshikaw

(gdb) info thread
* 1 Thread 25658  0x0000003c83a32925 in raise () from /lib64/libc.so.6
(gdb) thread apply all where

Thread 1 (Thread 25658):
#0  0x0000003c83a32925 in raise () from /lib64/libc.so.6
#1  0x0000003c83a34105 in abort () from /lib64/libc.so.6
#2  0x00000000004066f0 in CoreDump ()
#3  <signal handler called>
#4  0x0000000000419dfe in rem ()

yoshikaw

SELECT px.SID "SID", p.PID, p.SPID "SPID", px.INST_ID "Inst",
       px.SERVER_GROUP "Group", px.SERVER_SET "Set",
       px.DEGREE "Degree", px.REQ_DEGREE "Req Degree", w.event "Wait Event"
       ,w.seconds_in_wait
       ,w.p1text
       ,w.p1
       ,w.p2text
       ,w.p2
       ,w.p3text
       ,w.p3

yoshikaw

#!/bin/sh
/usr/local/bin/grip --export -