This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
git branch --merged master | grep -v master | xargs -n 1 git branch -D | |
git remote prune origin |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
BEGIN | |
FOR R IN (SELECT owner, table_name FROM all_tables WHERE owner='<user>') LOOP | |
EXECUTE IMMEDIATE 'grant select,insert,update,delete on '||R.owner||'.'||R.table_name||' to <username>'; | |
END LOOP; | |
END; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT dbms_metadata.get_ddl(object_type, object_name, owner) || ';' AS object_ddl | |
FROM DBA_OBJECTS | |
WHERE | |
OWNER = '<owner>' | |
AND OBJECT_TYPE IN ( | |
'TABLE' | |
, 'INDEX' | |
, 'SEQUENCE' | |
, 'VIEW' | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT 'ALTER SYSTEM KILL SESSION '''||sid||','|| s.serial#||'''IMMEDIATE;' | |
FROM sys.GV_$LOCKED_OBJECT L | |
, DBA_OBJECTS O | |
, sys.GV_$SESSION S | |
, sys.GV_$PROCESS P | |
WHERE L.OBJECT_ID = O.OBJECT_ID | |
and l.inst_id = s.inst_id | |
AND L.SESSION_ID = S.SID | |
and s.inst_id = p.inst_id | |
AND S.PADDR = P.ADDR(+) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env bash | |
# /etc/bash.bashrc | |
function proxyOff(){ | |
# stop cntlm service | |
systemctl stop cntlm.service | |
#remove all proxy env variables | |
sed -i.bak '/proxy/d' /etc/environment |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<sequence name="GetOrderIdsForDataExtractionRequest_Transform" | |
trace="disable" | |
xmlns:orders="http://imshealth.com/bdf/esb/client/orders/schemas/" | |
xmlns="http://ws.apache.org/ns/synapse"> | |
<!--Remove wrapper element (GetOrderIdsForDataExtraction) by replacing it with his child (Deliverables)--> | |
<!--example input--> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
sed -i "$(eval "grep -n '### Kibana' /usr/local/bin/start.sh | awk -F ':' '{print \$1-1}'")i curl -X PUT localhost:9200/my_index_$environment/_settings --data-binary '@/tmp/index_settings.json';curl -X PUT localhost:9200/my_index_$environment/_settings --data-binary '@/tmp/index_settings.json';echo modified index settings" /usr/local/bin/start.sh |