Kafka commands
Overview Article to show the usage of some common Kafka commands. These commands are executed from Kafka’s command …
Blog
HIVE Commands
Login into hive Command : hive Logoff from hive Command : quit; Command : exit; Create managed table hive CREATE TABLE …
Hadoop/HDFS Commands
In this article, we will go over some frequently used HDFS commands Hadoop Commands The Hadoop Distributed File System …
Update the linux .bashrc_profile to add ORACLE
bashrc is the best place to add aliases and Bash related functions. The Bash shell looks for the . bashrc file in the …
How to run FTP script in windows command line / Task Scheduler
Let’s say we need to FTP a file (say filename.txt) from my local windows machine/server (say C:\ftp\output) to a …
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 \ * …
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 …