Search Results

I am still having a mystery here....
I have tested it on my side on LINUX and AIX but I get same results as I pasted in my earlier reply....this is really a strange issue....

My input file is......

can anyone fix this?

Thanks vidyadhar85 (https://www.unix.com/members/302044378.html) I got that meaning now.
But, still the script dont work for other input files....plz see this input file...

$ cat test.txt
192 ...

Thanks vidyadhar85 (https://www.unix.com/members/302044378.html) for details.

Now im getting good results but...there is something diff from your results...check the 1st row. It has NaNQ.

$...

can anyone fix this problem?

awk -F"[( ]" '{if ($1=="0"){print "0.000000 "$NF}else{printf "%f %s\n",($3+($5/1000000000))/$1,$NF}}'perf.fmt|sort -r -k1
Syntax Error The source line is 1.
The error context is
...

I have a file say test.txt, data in that file is in format such that
1st column represents number of executions of particular function
2nd column represents total amount of time
3rd column...

@ summer_cherry (https://www.unix.com/members/302025484.html)
I dont understand your script.
How to run your script if I have to run it against file test.txt ?

Vidyadhar85....your script doesn't work....
this is output...

$ awk -F"[( ]" '{printf "%f %s\n",($3+($5/1000000000))/$1,$NF}' test.txt|sort -r -k1 | more
awk: 0602-566 Cannot divide by zero.
...

I dont know how to do division...of
records like... 721 (253 sec, 632655866 nanosec) efgh
plz help me to write the awk or any other script....

Hello ALL,

I have a file say test.txt, data in that file is in format such that
1st column represents number of executions of particular function
2nd column represents total amount of time
3rd...

Correct working script....
awk -F "=" '/physical reads/{p+=$2;next}/logical reads/{l+=$2}END{cal=(1-(p/l))*100;print cal}' file

Thanks guys for your quick reply.

@ghostdog74 : Sorry I dont have Python.

@devtakh :
I really don't understand your code, why would anyone pull the lines from file and put in the script like...

Hello Unix gurus,
Can anyone tell me the most efficient way to create script for the formula?

Formula:

Ans = 1 - ((Buffer pool data physical reads + Buffer pool xda physical reads + Buffer...

"shamrock (https://www.unix.com/members/302031670.html)" your getting correct result BECAUSE your using only first 30 lines from 12.txt (the file which I use as input)....

Actual 12.txt has 3052...

Did you get the (correct ) output in "SORTED" format ??
Like....
41.095447/2 = 20.548 <---- correct sort
47.139053/3 = 15.713 <---- correct sort
9.396545/1 = 9.397
9.039183/1 = 9.039...

I tried on diff machine...but same behavior :-(

$ uname -a
Linux matrix05 2.6.5-7.283-smp #1 SMP Wed Nov 29 16:55:53 UTC 2006 x86_64 x86_64 x86_64 GNU/Linux

uname -a
AIX panipuri 3 5 00C5EFD04C00

Firstly, sorry for reposting but the folks who were responding to earlier thread were not understanding the problem at all and were just claming I changed the input file...this is ridiculous !! ...

Hello all,
I have a file - 12.txt

cat 12.txt
===============================================
Number of executions = 2 Total execution time (sec.ms) = 0.009883
Number...

Hello Perderabo OR anyone else...can you help to fix this ?

Perderabo,
I haven't changed any input.
Why I should do that? Rather I know you guys r helpful why I should delay my desired task ?

Also, as I said I have already uploaded the test input...

Hello rubionis and Perderabo,
I appreciate your help.
But, Still I am not getting the desired output.

@Perderabo - I didn't change my input file after you gave me script.
@rubionis - the code...

sort -r -k3,3n
- doesn't work either....
rather gives wrong result....
check below....

cat 12.txt | awk '{ printf "%s/%s = %3.3f\n", $11, $5, $11/$5}' | sort -r -k3 | more
9.396545/1 =...

Hello all,
I have a file - 12.txt

cat 12.txt
===============================================
Number of executions = 2 Total execution time (sec.ms) = 0.009883
Number...