Home » RDBMS Server » Server Administration » V$sysstat (oracle 9i)
V$sysstat [message #310667] Wed, 02 April 2008 00:30 Go to next message
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 #310668 is a reply to message #310667] Wed, 02 April 2008 00:35 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>How do we convert the statistics value into percentage.

divide by 100
Re: V$sysstat [message #310671 is a reply to message #310668] Wed, 02 April 2008 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
divide by 100

Laughing
Re: V$sysstat [message #310672 is a reply to message #310667] Wed, 02 April 2008 00:47 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
did I mis-speak?
Re: V$sysstat [message #310674 is a reply to message #310672] Wed, 02 April 2008 00:52 Go to previous messageGo to next message
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 #310676 is a reply to message #310674] Wed, 02 April 2008 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is not in v$sysstat, it does not exist.

By the way, what is the total for 'index fast full scans (full)'?

Regards
Michel
Re: V$sysstat [message #310680 is a reply to message #310667] Wed, 02 April 2008 01:13 Go to previous messageGo to next message
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
Michel Cadot
Messages: 64120
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
Previous Topic: Steps to create database
Next Topic: SQLPLUS NOT FOUND
Goto Forum:
  


Current Time: Tue Dec 06 12:33:43 CST 2016

Total time taken to generate the page: 0.05489 seconds