simple %(math) problem

[clinton]

I have a simple mathematical question that I'm fighting with.
Can any one help?

Question
---------
In terms of percentage, what does this number mean
.008333333

I ran a query and I'm supposed to get less than 4%. But I received
this output .008333333. So I'm wondering if its more than 4%. How do
determine the percentage based on a value like this

[wjramsey]

Exactly what is the calculation you are doing?

It looks to me like it's probably around 8/10's of 1%

[clinton]

SQL> select d.value/m.value
2 from v$sysstat d, v$sysstat m
3 where d.name = 'sorts (disk)'
4 and m.name = 'sorts (memory)';

D.VALUE/M.VALUE
---------------
.00833333

[sambavan]

o.K now it makes sense. Modify your query to be as follows


select (d.value/m.value) *100
from v$sysstat d, v$sysstat m
where d.name = 'sorts (disk)'
and m.name = 'sorts (memory)';

This would give you .8% < 4%

Sam

[clinton]

I'm sure the answer below means 7% right?

SQL> select (d.value/m.value) *100
2 from v$sysstat d, v$sysstat m
3 where d.name = 'sorts (disk)'
4 and m.name = 'sorts (memory)';

(D.VALUE/M.VALUE)*100
---------------------
.78125

[mber]

Originally posted by clinton
I'm sure the answer below means 7% right?

SQL> select (d.value/m.value) *100
2 from v$sysstat d, v$sysstat m
3 where d.name = 'sorts (disk)'
4 and m.name = 'sorts (memory)';

(D.VALUE/M.VALUE)*100
---------------------
.78125

it should be: .078125 ===> 7.8%

[akkerend]

No 0.78%, (d.value/m.value) *100 is the percentage.

select (d.value/m.value) *100 "Percentage"
from v$sysstat d, v$sysstat m
where d.name = 'sorts (disk)'
and m.name = 'sorts (memory)';

[clinton]

ok. so based on this out put, what would you say the percentage is?
D.VALUE/M.VALUE)*100
---------------------
.78125

[sambavan]

It would be .78%.

50% of 100 would be (50/100) * 100 = 50

10% of 40 would be (10/100) * 40 = .40

In short

(value/total_value) * 100 = percentage

Hope this would help you to strainghten your math

Sam

[wjramsey]

This thread is becoming terribly scary