.🤯 luca’s mind blowers

Shell
> Change file times from .gz.tmp to .gz
for i in ./*.gz.tmp; do mv -vi "$i" "${i%.tmp}"; done


Git
> Track every branch from origin
for branch in $(git branch --all | grep '^\s*remotes' | egrep --invert-match '(:?HEAD|master)$'); do git branch --track "${branch##*origin/}" "$branch"; done


OC
> Create a new batch job from command line
oc create job --from=cronjob/cb1-collector-batch test   

> Login noprod/prod
oc login https://api.wepay-noprod.unicreditgroup.eu:6443 --username ac331996
oc login https://api.prod-de-vr1.ocp.unicreditgroup.eu:6443 --username ac331996


Helm
> Install
helm upgrade --install 'wep-nas-col-deploy-ba-prd' --values 'helm/nas-nginx/values-ba-col-prd.yaml' --set image.repository='artifactory.devops.internal.unicreditgroup.eu/mdt-docker-group/mdt/nginx-nas' --set image.tag='1.0.0' --cleanup-on-fail --atomic --wait --timeout 300s 'helm/nas-nginx'

> Template
helm template releasename ./helm/initcontainer -f ./helm/initcontainer/values-ba-uat.yaml --debug > out.txt 

> Uninstall
helm uninstall wep-nas-col-deploy-ba-prd


DBs
> Find all non-system indexes
SELECT 
    index_name, 
    index_type, 
    visibility, 
    status 
FROM 
    all_indexes
WHERE
    OWNER = TABLESPACE_NAME and TABLE_OWNER <> 'SYSTEM';

> create/drop/rebuild indexes
CREATE INDEX index_custom_uetr 
ON MESSAGE(UETR_CODE, OTHER_COLUMN);

DROP INDEX INDEX_CUSTOM_UETR;

ALTER INDEX TWEPBACOL.SYS_C006579 REBUILD;

> Compress columns  / Search for compressed column

select * from user_lobs where securefile = 'YES';

ALTER TABLE MESSAGE MOVE LOB(RAW_MESSAGE) STORE AS SECUREFILE(COMPRESS HIGH);

> STORAGE RELATED 
select  blocks, pct_free , compression, compress_for
from    user_tables
where   table_name = 'MESSAGE';

SELECT PROPERTY_VALUE/1024/1024/1024 PDB_QUOTA_GB 
FROM database_properties 
WHERE property_name = 'MAX_PDB_STORAGE';

SELECT segment_type,SUM(bytes)/1024/1024/1024 GB 
FROM user_segments 
GROUP BY ROLLUP (segment_type);

> Search by  clob content

SELECT *
FROM   MESSAGE
WHERE  DBMS_LOB.INSTR( RAW_MESSAGE, '16T16:19:20' ) > 0;