Skip to content

Instantly share code, notes, and snippets.

View hakunamatatatatatata's full-sized avatar

hakunamatatatatatata

View GitHub Profile
@hakunamatatatatatata
hakunamatatatatatata / 01-memory-usage-for-each-user-session.sql
Created July 13, 2022 10:47 — forked from rponte/01-memory-usage-for-each-user-session.sql
Oracle: showing memory usage by user session/process
select sess.username as username
,sess.sid as session_id
,sess.serial# as session_serial
,sess.program as session_program
,sess.server as session_mode
,round(stat.value/1024/1024, 2) as "current_UGA_memory (in MB)"
from v$session sess
,v$sesstat stat
,v$statname name
where sess.sid = stat.sid
@hakunamatatatatatata
hakunamatatatatatata / ansible_local_playbooks.md
Created December 3, 2020 12:44 — forked from alces/ansible_local_playbooks.md
How to run an Ansible playbook locally
  • using Ansible command line:
ansible-playbook --connection=local 127.0.0.1 playbook.yml
  • using inventory:
127.0.0.1 ansible_connection=local
@hakunamatatatatatata
hakunamatatatatatata / nginx.conf
Created September 21, 2020 08:06 — forked from plentz/nginx.conf
Best nginx configuration for improved security(and performance). Complete blog post here http://tautt.com/best-nginx-configuration-for-security/
# to generate your dhparam.pem file, run in the terminal
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048