MySQL (5.6) show binary logs; Oracle (12cR1) select * from v$log order by group#,thread#; select * from v$logfile order by group#,member; PostgreSQL https://tihiro.hatenablog.com/entry/2020/04/24/080849 (9.4)select pg_xlogfile_name( pg_cur…

Ubuntu (16) useradd -d /home/user01 -s /bin/bash user01passwd user01 chage -l user01 chage -M 99999 user01 Debian (9) useradd -d /home/user01 -s /bin/bash user01passwd user01 chage -l user01 chage -M 99999 user01 CentOS (7)useradd user01ec…

http://akiniwa.hatenablog.jp/entry/2014/04/08/220430 vim a.txt 20200601 AAA 1020200602 AAA 2020200603 AAA 3020200604 BBB 10020200605 BBB 12020200606 CCC 1020200607 CCC 1220200608 CCC 1220200609 DDD 300 vim a.awk { sum[$2]+=$3 count[$2]+=1 …

MySQL (5.6)status; Oracle (12cR1) alter session set nls_date_format='yyyy/mm/dd hh24:mi:ss'; select startup_time from v$instance; PostgreSQL (9.4) select pg_postmaster_start_time(); SQL Server (2014) select sqlserver_start_time from sys.dm…

MySQL (5.6) select @@read_only; Oracle (12cR1) select database_role from v$database; PostgreSQL (9.4) select setting from pg_settingswhere name like 'transaction_read_only'; SQL Server (2019) select is_primary_replicafrom sys.dm_hadr_datab…