Tag: linux

How to find which SQL is executed by a process

Reading Time: < 1 minute

If you are looking for the last SQL query ran by a specific process, try this: 

 
select substr(sa.sql_text,1,1000) txt
from v$process p, v$session s, v$sqlarea sa
where p.addr=s.paddr
and s.username is not null
and s.sql_address=sa.address(+)
and s.sql_hash_value=sa.hash_value(+)
and spid=&SPID;

How to delete empty line with vi

Reading Time: < 1 minute

How to delete empty lines with vi?

Just type this in:

 
<esc>:g/^$/d

NOTE:  This means that all the lines that just have a carriage return on them (NO Spaces), will be removed. 

If you want to remove lines with empty spaces as well:

 
<esc>:g/^ *$/d

rename and shorten many files with bash

Reading Time: < 1 minute

Bash supports a surprising number of string manipulation functions.

For example if you want to get rid of the beginning of the name of a file or a folder on many files at a time you could do the following:

 
bash> ls
mylongfile1
mylongfile2
mylongfile3
mylongfile4
mylongfile5
mylongfile6
mylongfile7
 
bash> for i in *
> do
> mv $i ${i:6}
> done
bash> ls
file1
file2
file3
file4
file5
file6
file7
So to extract the end of a variable after a NUMBER of characters you just need to specify ${variable:NUMBER}
 

Change permanently the ethernet parameters of interface in redhat

Reading Time: < 1 minuteIn the file: 

/etc/sysconfig/network-scripts/ifcfg-eth0

Add the following at the end of the file:

ETHTOOL_OPTS="speed 100 duplex full autoneg off"