sudo tcpdump -A -s 0 -i eth0 dst or src host
Reference : http://code.google.com/support/bin/answer.py?answer=71567&topic=12022
Technical tid-bits and more ! Leave a comment if you found something useful.
select /*+ parallel(x 4) */ count(1)
from huge_table
where huge_table.x = 'somevalue'