2019-06-01から1ヶ月間の記事一覧

ファイアウォール

OS

Ubuntu (16)(18) apt install ufw ufw status ufw disable ※OCIの場合、下記も確認必要iptables -L Debian (9) apt install ufw ufw status ufw disable CentOS (7) systemctl disable firewalldsystemctl stop firewalldsystemctl status firewalld firewal…

パッケージマネージャ

OS

Ubuntu (16)(18)apt updateapt upgrade Debian (9) vi /etc/apt/sources.list deb http://ftp.jp.debian.org/debian/ stretch maindeb-src http://ftp.jp.debian.org/debian/ stretch main deb http://security.debian.org/debian-security stretch/updates …

SSH

OS

Ubuntu (16)(18)apt install openssh-server systemctl enable sshsystemctl restart ssh Debian (9)apt install openssh-server systemctl enable sshsystemctl restart ssh CentOS (7) yum install openssh-server systemctl enable sshdsystemctl restart…

ネットワーク設定

OS

Ubuntu (16) ----NetworkManagerを使う場合nmtui ----NetworkManagerを使わない場合 systemctl stop NetworkManagersystemctl disable NetworkManager vi /etc/network/interfaces auto loiface lo inet loopback auto ens33iface ens33 inet staticaddress …

デフォルト値ありカラム追加時の最適化

DB

Oracle set timing on drop table tab1;create table tab1(col1 int); declarebegin for i in 1..1000000 loop insert into tab1 values(i); commit; end loop;end;/ select sum(bytes) from user_segments where segment_name = 'TAB1'; alter table tab1 a…

ダンプ関数

DB

Oracle select DUMP('a',16) from dual;select DUMP('あ',16) from dual; select DUMP('a',1016) from dual;select DUMP('あ',1016) from dual; SELECT UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW('61')) FROM DUAL;SELECT UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW('E381…

分析関数

DB

Oracle create table tab1(col1 int,col2 int); insert into tab1 values(1,100);insert into tab1 values(1,110);insert into tab1 values(1,120);insert into tab1 values(2,100);insert into tab1 values(2,200);insert into tab1 values(3,10);insert in…

プラグイン

DB

Oracle プロプラエタリのため、作成不可 MySQL https://blog.infobuild.jp/e/?c=201902010745https://gihyo.jp/dev/serial/01/mysql-road-construction-news/0084https://norikone.hatenablog.com/entry/2018/12/29/MySQL%E3%81%AE%E3%82%B9%E3%83%88%E3%83%…

リネーム

DB

MySQL (8.0.22) drop table tab22;create table tab22(col1 int,col2 int);create index ind22 on tab22(col2);alter table tab22 add constraint tab22pk primary key(col1); show create table tab22;show create table tab22rename; -- テーブル名の変更a…