original_string: function SuspiciousSQL($numsql=10)
  	{
  		$sql = "
  select
    substr(to_char(s.pct, '99.00'), 2) || '%'  load,
    s.executions  executes,
    p.sql_text
  from
    (
      select
        address,
        buffer_gets,
        executions,
        pct,
        rank() over (order by buffer_gets desc)  ranking
      from
        (
  	select
  	  address,
  	  buffer_gets,
  	  executions,
  	  100 * ratio_to_report(buffer_gets) over ()  pct
  	from
  	  sys.v_\$sql
  	where
  	  command_type != 47 and module != 'T.O.A.D.'
        )
      where
        buffer_gets > 50 * executions
    )  s,
    sys.v_\$sqltext  p
  where
    s.ranking <= $numsql and
    p.address = s.address
  order by
    1 desc, s.address, p.piece";
  
    		global $ADODB_CACHE_MODE;
    		if (isset($_GET['expsixora']) && isset($_GET['sql'])) {
  				$partial = empty($_GET['part']);
  				echo "<a name=explain></a>".$this->Explain($_GET['sql'],$partial)."\n";
  		}
  
  		if (isset($_GET['sql'])) return $this->_SuspiciousSQL($numsql);
  
  		$s = '';
  		$timer = time();
  		$s .= $this->_SuspiciousSQL($numsql);
  		$timer = time() - $timer;
  
  		if ($timer > $this->noShowIxora) return $s;
  		$s .= '<p>';
  
  		$save = $ADODB_CACHE_MODE;
  		$ADODB_CACHE_MODE = ADODB_FETCH_NUM;
  		if ($this->conn->fetchMode !== false) $savem = $this->conn->SetFetchMode(false);
  
  		$savelog = $this->conn->LogSQL(false);
  		$rs = $this->conn->SelectLimit($sql);
  		$this->conn->LogSQL($savelog);
  
  		if (isset($savem)) $this->conn->SetFetchMode($savem);
  		$ADODB_CACHE_MODE = $save;
  		if ($rs) {
  			$s .= "\n<h3>Ixora Suspicious SQL</h3>";
  			$s .= $this->tohtml($rs,'expsixora');
  		}
  
  		return $s;
  	}
code: function SuspiciousSQL($numsql=10)
  	{
  		$sql = "
  select
    substr(to_char(s.pct, '99.00'), 2) || '%'  load,
    s.executions  executes,
    p.sql_text
  from
    (
      select
        address,
        buffer_gets,
        executions,
        pct,
        rank() over (order by buffer_gets desc)  ranking
      from
        (
  	select
  	  address,
  	  buffer_gets,
  	  executions,
  	  100 * ratio_to_report(buffer_gets) over ()  pct
  	from
  	  sys.v_\$sql
  	where
  	  command_type != 47 and module != 'T.O.A.D.'
        )
      where
        buffer_gets > 50 * executions
    )  s,
    sys.v_\$sqltext  p
  where
    s.ranking <= $numsql and
    p.address = s.address
  order by
    1 desc, s.address, p.piece";
  
    		global $ADODB_CACHE_MODE;
    		if (isset($_GET['expsixora']) && isset($_GET['sql'])) {
  				$partial = empty($_GET['part']);
  				echo "<a name=explain></a>".$this->Explain($_GET['sql'],$partial)."\n";
  		}
  
  		if (isset($_GET['sql'])) return $this->_SuspiciousSQL($numsql);
  
  		$s = '';
  		$timer = time();
  		$s .= $this->_SuspiciousSQL($numsql);
  		$timer = time() - $timer;
  
  		if ($timer > $this->noShowIxora) return $s;
  		$s .= '<p>';
  
  		$save = $ADODB_CACHE_MODE;
  		$ADODB_CACHE_MODE = ADODB_FETCH_NUM;
  		if ($this->conn->fetchMode !== false) $savem = $this->conn->SetFetchMode(false);
  
  		$savelog = $this->conn->LogSQL(false);
  		$rs = $this->conn->SelectLimit($sql);
  		$this->conn->LogSQL($savelog);
  
  		if (isset($savem)) $this->conn->SetFetchMode($savem);
  		$ADODB_CACHE_MODE = $save;
  		if ($rs) {
  			$s .= "\n<h3>Ixora Suspicious SQL</h3>";
  			$s .= $this->tohtml($rs,'expsixora');
  		}
  
  		return $s;
  	}
code_tokens: function SuspiciousSQL ( $ numsql = 10 ) { $ sql = "
  select
    substr(to_char(s.pct, '99.00'), 2) || '%'  load,
    s.executions  executes,
    p.sql_text
  from
    (
      select
        address,
        buffer_gets,
        executions,
        pct,
        rank() over (order by buffer_gets desc)  ranking
      from
        (
  	select
  	  address,
  	  buffer_gets,
  	  executions,
  	  100 * ratio_to_report(buffer_gets) over ()  pct
  	from
  	  sys.v_\$sql
  	where
  	  command_type != 47 and module != 'T.O.A.D.'
        )
      where
        buffer_gets > 50 * executions
    )  s,
    sys.v_\$sqltext  p
  where
    s.ranking <= $numsql and
    p.address = s.address
  order by
    1 desc, s.address, p.piece" ; global $ ADODB_CACHE_MODE ; if ( isset ( $ _GET [ 'expsixora' ] ) && isset ( $ _GET [ 'sql' ] ) ) { $ partial = empty ( $ _GET [ 'part' ] ) ; echo "<a name=explain></a>" . $ this -> Explain ( $ _GET [ 'sql' ] , $ partial ) . "\n" ; } if ( isset ( $ _GET [ 'sql' ] ) ) return $ this -> _SuspiciousSQL ( $ numsql ) ; $ s = '' ; $ timer = time ( ) ; $ s .= $ this -> _SuspiciousSQL ( $ numsql ) ; $ timer = time ( ) - $ timer ; if ( $ timer > $ this -> noShowIxora ) return $ s ; $ s .= '<p>' ; $ save = $ ADODB_CACHE_MODE ; $ ADODB_CACHE_MODE = ADODB_FETCH_NUM ; if ( $ this -> conn -> fetchMode !== false ) $ savem = $ this -> conn -> SetFetchMode ( false ) ; $ savelog = $ this -> conn -> LogSQL ( false ) ; $ rs = $ this -> conn -> SelectLimit ( $ sql ) ; $ this -> conn -> LogSQL ( $ savelog ) ; if ( isset ( $ savem ) ) $ this -> conn -> SetFetchMode ( $ savem ) ; $ ADODB_CACHE_MODE = $ save ; if ( $ rs ) { $ s .= "\n<h3>Ixora Suspicious SQL</h3>" ; $ s .= $ this -> tohtml ( $ rs , 'expsixora' ) ; } return $ s ; }
docstring: requires oracle 8.1.7 or later
docstring_tokens: requires oracle 8 . 1 . 7 or later