09-26-2006
I just tested this. very nice!
there is only one extra line that I don't need, but it is not a big deal.
PHP Code:
sed -n "/Tablespace Percent Total Free/,/Tablespace Free Space Avg Fragmentation/ p" /export/home/oracle/dba/spcchk.lis | sed "$ d"
09/25/06 SPCCHK - Tablespace Percent Total Free Values on BAT
%chg Days
Tablespace Today since till
Name 09/18 09/19 09/20 09/21 09/22 09/23 09/24 09/25 yest zero
----------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----
FILE_NDX 25.6 25.5 25.5 25.5 25.4 25.4 25.3 25.3 .0
SYSAUX 40.3 43.0 42.2 41.2 40.3 42.8 42.1 41.2 -.9
SYSTEM 61.4 61.2 61.2 61.2 61.1 61.1 61.1 61.1 .0
UNDOTBS1 81.4 81.0 81.2 80.8 81.0 80.8 81.0 81.2 .2
USERS 87.1 87.1 87.1 87.1 86.6 86.6 86.6 86.6 .0
## don't need "Fragmentation" line below -- I could just grep -v it out however
09/25/06 SPCCHK - Tablespace Free Space Avg Fragmentation Pct on BAT
09/25/06 SPCCHK - Tablespace Percent Total Free Values on CCST
%chg Days
Tablespace Today since till
Name 09/18 09/19 09/20 09/21 09/22 09/23 09/24 09/25 yest zero
----------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----
ACTIVE_SEATS 14.1 14.1 14.1 12.5 12.5 12.5 12.5 12.5 .0 42
ACTIVE_SEATS_NDX 43.7 43.7 43.7 43.7 43.7 42.2 42.2 42.2 .0 158
ATTEMPTS 25.0 24.2 24.2 24.2 24.2 24.2 24.2 24.2 .0 361
ATTEMPTS_NDX 86.0 86.0 86.0 86.0 86.0 85.9 85.9 85.9 .0
GEN_NDX 48.8 48.8 48.8 48.8 48.8 48.8 48.8 48.6 -.2
SYSAUX 44.0 46.7 45.8 45.1 44.1 46.7 45.8 45.1 -.7
SYSTEM 44.2 44.2 44.2 44.2 44.2 44.0 44.0 44.0 .0
UNDOTBS 85.1 84.8 84.9 84.6 84.2 84.1 84.5 85.2 .7
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have this text file name test.txt which contain :
aaaaa bbb
iiiiiiiiiiiii ccf
ddaaa ddd
and i need a script that can print out the line numbers using a while loop..
so when the script is run..it will have this:
1
2
3
any ideas? :) thanks guys (4 Replies)
Discussion started by: forevercalz
4 Replies
2. Shell Programming and Scripting
Hi all
How to add line numbers in text file..
ex
abcd
cdef
result
1. abcd
2. cdef
thx in advance (4 Replies)
Discussion started by: suryanarayana
4 Replies
3. Shell Programming and Scripting
Dear Friends,
I have a flat file from which I want to grep line no. 7,10, 19 to 35, 37.
How can it be done?
Thank you in advance
Anushree (6 Replies)
Discussion started by: anushree.a
6 Replies
4. Shell Programming and Scripting
hi dudes, I nee you kind assistance, I have to find the matched numbers from 2 text files and output of matched numbers should be in another text file..
I do have text files like this , for example
File 1
787
665*5-p
5454
545-p
445-p
5454*-p
File 2
5455
787
445-p
4356
2445
144
... (3 Replies)
Discussion started by: sureshraj
3 Replies
5. Shell Programming and Scripting
Hi
I have a text file with rows like this:
7 Herman ASI-40 Jungle (L) Blueprint (L) Weapon Herman ASI-40 Jungle (L) 215.00 57 65.21 114.41
and
9 Herman CAP-505 (L) Blueprint (L) Weapon Herman CAP-505 (L) 220.00 46.84 49.1 104.82
and
2 ClericDagger 1C blueprint Melee - Shortblade... (2 Replies)
Discussion started by: pesa
2 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I am trying to extract lines from a text file given a text file containing line numbers to be extracted from the first file. How do I go about doing this? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies
7. Shell Programming and Scripting
I have a text file with a line of text that contains numbers and text formatted into groups. I need to extract the number that can be either 1,2 or 3 digits long. Then write it to a variable, but i need to remove any leading spaces in the number first.
I can get the numbers out but how to remove... (12 Replies)
Discussion started by: kcpoole
12 Replies
8. Shell Programming and Scripting
Hi,
I need to number the lines in my text file. I know how to do this with standard numbering (1,2,3,4, etc) but I need to count in multiples of 5, beginning 0,5,10,15...
example existing file:
abcd
efg
hijklm
nopqrs
desired output
0 abcd
5 efg
10 hijklm
15 ... (11 Replies)
Discussion started by: livbaddeley
11 Replies
9. Shell Programming and Scripting
data:
8iW5iPACIb5fafafEU24f3EOOjpakx6VwxBX+NafafxJMWX8iW5iPACIb5fafafEU24f3EOOjpakx6VwxBX+NafafxJMWX8iW5i
PACIb5fafafEU24f3EOOjpakx6VwxBX+NafafxJMWX8iW5iPACIb5fafafEU24f3EOOjpakx6VwxBX+
8nwR15UzfeZafaf2bGr8akx6VwxBX+NafafxJMWX8iW5iPACIb5fafafEU24f3EOOjp
lVpOoMLXJ ... (19 Replies)
Discussion started by: SkySmart
19 Replies
10. UNIX for Beginners Questions & Answers
Hello All,
This is a noob question. I tried searching for the answer but the answer found did not help me .
I have a file that can have duplicates.
100
200
300
400
100
150
the number 100 is duplicated twice. I want to find the duplicate along with the line number.
expected... (4 Replies)
Discussion started by: vatigers
4 Replies