How to generate XML using SQL query in Oracle 1. Selecting single column from a table SELECT SYS_XMLAGG(SYS_XMLGEN(franchisee_codes)) FROM franchisee_mapping WHERE username = '<username>'; The output will be <?xml version=&qu…
find the right command and its location in Linux # apropos # apropos "list directory" dir (1) - list directory contents ls (1) - list directory contents ntfsls (8) - list directory contents on an NTFS filesystem vdir (1) - list dir…
Linux useful commands # -Hostname. echo -e "\e[35;42m***** HOSTNAME *****\e[0m" hostname # -File system disk space usage: echo -e "\e[35;42m***** FILE SYSTEM DISK SPACE USAGE *****\e[0m" df -h # -Free and used memory …
check the statistics of a particular file like size blocks IO block and access details # stat Example $ stat ebportal-08092015.dmp File: `ebportal-08092015.dmp' Size: 11888291840 Blocks: 23219328 IO Block: 4096 regular file Dev…
To check the command run on any terminal the command used is "history" #history Sample output $ history 6 tracerout 10.19.250.181 7 traceroute 10.19.250.181 8 ping 10.220.196.64 9 traceroute [oracle@ITPFEBPAS0816P…
Top six big files in Linux eating out your space # du -hsx * | sort -rh | head -6 $ du -hsx * | sort -rh | head -6 12G ebportal-08092015.dmp 12G ebportal-06092015.dmp 11G oracle11204Patch 8.8G old_temptables.dmp 7.1G fullexp_Tue.d…
1) ssa.in - This file contains all the values for which a procedure is to be run on O/S shell $ cat ssa.in ADB ATP CDP ELR GTR KAA KHM KNL MBN NGD NLR NZB ONG RMY SGD SK TRP VJA VM VZM WGL HTD …
1. Top – Linux Process Monitoring Linux Top command is a performance monitoring program It display CPU usage , Memory usage , Swap Memory , Cache Size , Buffer Size , Process PID , User , Command s and much more. It also shows high memory …
