| V$sysstat [message #310667] |
Wed, 02 April 2008 00:30  |
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  |
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 |
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 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
