Query to find the space used by a table in Oracle
Query to find the space used by a table SELECT DS.TABLESPACE_NAME , SEGMENT_NAME , ROUND(SUM(DS.BYTES) / (1024 \ * …
Blog
Query to find database uptime in Oracle
Query to find database uptime SELECT host_name , instance_name , TO_CHAR(startup_time, 'DD-MM-YYYY HH24:MI:SS') …
Query to find the queries executed by an user in Oracle
Query to find the queries executed by an user in Oracle SELECT VS.USERNAME , VS.MACHINE , VS.PROGRAM , VS.STATUS , …
Query to find service name
This article explains the steps to find the service name of a database running on your local windows machine. Open …
DataStage Log Analyzer - FindJobsByKeyWord Utility
This is a utility to scan the DataStage job run logs to find the usage of a given table OR file. We can find where a …
ClearDS_RTLogRTStatus - Script & DataStage job to Clear DataStage RTLOG and RTSTATUS
Introduction DataStage job logs and status files can grow huge at times due to system issues or poor design which cause …
AuditDataStageJobLogs - Script & DataStage job to check the status of DataStage jobs
In most of the applications with a batch cycle, IT and Business stakeholders will be interested to know the status of …
Pogoplug(E02 & V4) - Arch Linux, Samba, Webmin and my.pogoplug.com service
Notes If you get a command not found for “wget” or “reboot”, try adding “busybox” in …