Email us [email protected]
Choose currency

Scripts

How to use TAR command in Unix

“tar” is called as tape archive a command in UNIX or Linux is one of the important command which provides archiving functionality in UNIX.

The tar command used to merge a collection of files and directories into highly compressed archive file commonly called tarball or tar, gzip and bzip in Linux. Its very widely used […]

Find active sessions in oracle

SET LINESIZE 500
SET PAGESIZE 1000

COLUMN username FORMAT A15
COLUMN machine FORMAT A25
COLUMN logon_time FORMAT A20

SELECT NVL(s.username, ‘(oracle)’) AS username,
s.osuser,
s.sid,
s.serial#,
p.spid,
s.lockwait,
[…]