skip to main | skip to sidebar

Sam's Oracle BLOG

Oct 21, 2009

sed & awk script - find num SID entries in oratab

sed and awk command to
- remove blank lines from the start of each line
- Find entries based on input parameter - SID.
- find the number of entries.

cat oratab sed -e 's/^[ \t]*//' awk -F: '/^'"$SID"'/ { print $1 }' wc -l
Posted by Sam
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: unix
Newer Post Older Post Home

My Blog List

  • Oracle Scratchpad
    Pagination Cost – 2
    4 weeks ago
  • The Momen Blog
    Oracle Database In-Memory Advisor Released
    10 years ago
  • The Tom Kyte Blog
    Upcoming Events...
    11 years ago

www.xobni.com

Xobni outlook add-in for your inbox

Archive

  • ►  2012 (1)
    • ►  Mar (1)
  • ►  2011 (13)
    • ►  Nov (5)
    • ►  Aug (3)
    • ►  May (3)
    • ►  Feb (2)
  • ►  2010 (7)
    • ►  Nov (1)
    • ►  Sep (2)
    • ►  Jun (2)
    • ►  Apr (1)
    • ►  Feb (1)
  • ▼  2009 (17)
    • ►  Dec (2)
    • ▼  Oct (5)
      • instr, substr
      • bug - 2942857 - OERI:12327 from complex view merging
      • sed & awk script - find num SID entries in oratab
      • truss
      • SGA
    • ►  Jul (3)
    • ►  May (3)
    • ►  Apr (1)
    • ►  Mar (2)
    • ►  Jan (1)
  • ►  2008 (44)
    • ►  Dec (5)
    • ►  Nov (1)
    • ►  Oct (1)
    • ►  Sep (20)
    • ►  Aug (17)
  • ►  2007 (21)
    • ►  Dec (4)
    • ►  Nov (6)
    • ►  Oct (7)
    • ►  Sep (4)