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/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) |
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 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 |