V$sysstat [message #310667] |
Wed, 02 April 2008 00:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
meys
Messages: 5 Registered: October 2007
|
Junior Member |
|
|
Hi All,
How do we convert the statistics value into percentage.
Quote: | select * from v$sysstat
where name ='index fast full scans (full)'
|
Thanks in advance
meys
|
|
|
|
|
|
Re: V$sysstat [message #310674 is a reply to message #310672] |
Wed, 02 April 2008 00:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
meys
Messages: 5 Registered: October 2007
|
Junior Member |
|
|
It should be (statistic value/ some total value )* 100 , I am unable to get that total value.
meys
|
|
|
|
Re: V$sysstat [message #310680 is a reply to message #310667] |
Wed, 02 April 2008 01:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
meys
Messages: 5 Registered: October 2007
|
Junior Member |
|
|
Michel,
when we say the fts scan /index scan value is high, there should be a min and max value to define.
Am I wrong ?
Thanks
meys
|
|
|
Re: V$sysstat [message #310695 is a reply to message #310680] |
Wed, 02 April 2008 01:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | when we say the fts scan /index scan value is high, there should be a min and max value to define.
|
I never say that so I don't what you meant with that.
Regards
Michel
|
|
|