Re: toad's query to find index sql

From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Mon, 18 May 2015 17:53:21 +0300
Message-ID: <OF0A40C72B.41CA6E01-ON43257E49.00519154-43257E49.0051C9F4_at_psbank.ru>

or something like that, but not all executions are SQL executions:

select ( SUM (DECODE (NAME, 'table scans (long tables)', VALUE, 0))

        + SUM (DECODE (NAME, 'table scans (short tables)', VALUE, 0))
       )
       / SUM (DECODE (NAME, 'execute count', value,0))

from v$sysstat
where name in (

               'execute count'


              ,'table scans (long tables)'

              ,'table scans (short tables)'

              )
--

http://www.freelists.org/webpage/oracle-l Received on Mon May 18 2015 - 16:53:21 CEST