{"width":"100%","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2020%2F08%2F29%2F215853\" title=\"OS\u30d7\u30ed\u30bb\u30b9\u78ba\u8a8d - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","version":"1.0","provider_name":"Hatena Blog","published":"2020-08-29 21:58:53","type":"rich","blog_title":"HTN20190109\u306e\u65e5\u8a18","categories":["DB"],"author_name":"HTN20190109","author_url":"https://blog.hatena.ne.jp/HTN20190109/","url":"https://htn20190109.hatenablog.com/entry/2020/08/29/215853","image_url":null,"title":"OS\u30d7\u30ed\u30bb\u30b9\u78ba\u8a8d","description":"MySQL (5.6) \u30de\u30eb\u30c1\u30b9\u30ec\u30c3\u30c9\u30e2\u30c7\u30eb Oracle (12cR1) \u524d\u63d0\uff1aOracle\u30de\u30eb\u30c1\u30d7\u30ed\u30bb\u30b9/\u30de\u30eb\u30c1\u30b9\u30ec\u30c3\u30c9\u6a5f\u80fd\u304c\u7121\u52b9 select s.username,s.process,s.program,p.spid,p.programfrom v$session s, v$process pwhere s.paddr = p.addr; PostgreSQL (9.4) select * from pg_stat_activity; SQL Server (2014)\u30de\u30eb\u30c1\u30b9\u30ec\u30c3\u30c9\u30e2\u30c7\u30eb","blog_url":"https://htn20190109.hatenablog.com/"}