Skip to content

Instantly share code, notes, and snippets.

@dudor
dudor / webp.py
Last active January 24, 2022 05:30
CONVERT JPG , PNG TO WEBP
#!/usr/bin/python3
import sys
import subprocess
import os
def cwebp(dir):
for item in os.listdir(dir):
file = os.path.join(dir,item)
if(os.path.isfile(file)):
ext =os.path.splitext(file)
@dudor
dudor / oracle trace.sql
Created May 19, 2021 01:24
oracle trace
select a.MODULE,A.USERNAME,A.OSUSER,A.MACHINE,A.PROGRAM,A.STATE,B.SQL_TEXT,B."SQL_FULLTEXT",B."LAST_ACTIVE_TIME" from v$session a
INNER JOIN V$SQL b ON a.MODULE =b.MODULE
where a.username = USER
AND a.OSUSER = 'administrator'
AND a.MODULE LIKE '%MainProgram%'
AND B.LAST_ACTIVE_TIME IS NOT NULL
ORDER BY B.LAST_ACTIVE_TIME DESC