perf_oci8 Class Reference

Inheritance diagram for perf_oci8:

Public Member Functions
	__construct (&$conn)
	LogMode ()
	TopRecentWaits ()
	TopHistoricalWaits ()
	TableSpace ()
	RMAN ()
	DynMemoryUsage ()
	FlashUsage ()
	WarnPageCost ($val)
	WarnIndexCost ($val)
	PGA ()
	PGA_Advice ()
	Explain ($sql, $partial=false)
	CheckMemory ()
	tohtml (&$rs, $type)
	SuspiciousSQL ($numsql=10)
	ExpensiveSQL ($numsql=10)
	clearsql ()

Public Attributes
	$noShowIxora = 15
	$tablesSQL
	$version
	$createTableSQL
	$settings

Detailed Description

Definition at line 21 of file perf-oci8.inc.php.

Constructor & Destructor Documentation

__construct()

perf_oci8::__construct

(

&

$conn

)

Definition at line 203 of file perf-oci8.inc.php.

References $conn, and $gSQLBlockRows.

Member Function Documentation

CheckMemory()

perf_oci8::CheckMemory

(

)

Definition at line 451 of file perf-oci8.inc.php.

References $rs, and rs2html().

clearsql()

perf_oci8::clearsql

(

)

Definition at line 679 of file perf-oci8.inc.php.

References $sql, and adodb_perf\table().

DynMemoryUsage()

perf_oci8::DynMemoryUsage

(

)

Definition at line 301 of file perf-oci8.inc.php.

References $rs, and rs2html().

ExpensiveSQL()

perf_oci8::ExpensiveSQL

(

$numsql = 10

)

Definition at line 606 of file perf-oci8.inc.php.

References $rs, $sql, and tohtml().

Explain()

perf_oci8::Explain	(		$sql,
			$partial = false
	)

Definition at line 372 of file perf-oci8.inc.php.

References $rs, $sql, and rs2html().

FlashUsage()

perf_oci8::FlashUsage

(

)

Definition at line 314 of file perf-oci8.inc.php.

References $rs, and rs2html().

LogMode()

perf_oci8::LogMode

(

)

Definition at line 214 of file perf-oci8.inc.php.

PGA()

perf_oci8::PGA

(

)

Definition at line 339 of file perf-oci8.inc.php.

PGA_Advice()

perf_oci8::PGA_Advice

(

)

Definition at line 345 of file perf-oci8.inc.php.

References $rs.

RMAN()

perf_oci8::RMAN

(

)

Definition at line 291 of file perf-oci8.inc.php.

References $rs, and rs2html().

SuspiciousSQL()

perf_oci8::SuspiciousSQL

(

$numsql = 10

)

Definition at line 532 of file perf-oci8.inc.php.

References $rs, $sql, and tohtml().

TableSpace()

perf_oci8::TableSpace

(

)

Definition at line 275 of file perf-oci8.inc.php.

References $rs.

tohtml()

perf_oci8::tohtml	(	&	$rs,
			$type
	)

Definition at line 486 of file perf-oci8.inc.php.

References $rs, and $sql.

Referenced by ExpensiveSQL(), and SuspiciousSQL().

TopHistoricalWaits()

perf_oci8::TopHistoricalWaits

(

)

Definition at line 253 of file perf-oci8.inc.php.

References $rs, and rs2html().

TopRecentWaits()

perf_oci8::TopRecentWaits

(

)

Definition at line 240 of file perf-oci8.inc.php.

References $rs, and rs2html().

WarnIndexCost()

perf_oci8::WarnIndexCost

(

$val

)

Definition at line 329 of file perf-oci8.inc.php.

WarnPageCost()

perf_oci8::WarnPageCost

(

$val

)

Definition at line 321 of file perf-oci8.inc.php.

Member Data Documentation

$createTableSQL

perf_oci8::$createTableSQL

Initial value:

= "CREATE TABLE adodb_logsql (
          created date NOT NULL,
          sql0 varchar(250) NOT NULL,
          sql1 varchar(4000) NOT NULL,
          params varchar(4000),
          tracer varchar(4000),
          timer decimal(16,6) NOT NULL
        )"

Definition at line 30 of file perf-oci8.inc.php.

$noShowIxora

perf_oci8::$noShowIxora = 15

Definition at line 23 of file perf-oci8.inc.php.

$settings

perf_oci8::$settings

Definition at line 39 of file perf-oci8.inc.php.

$tablesSQL

perf_oci8::$tablesSQL

Initial value:

= "select segment_name as \"tablename\", sum(bytes)/1024 as \"size_in_k\",tablespace_name as \"tablespace\",count(*) \"extents\" from sys.user_extents
       group by segment_name,tablespace_name"

Definition at line 25 of file perf-oci8.inc.php.

$version

perf_oci8::$version

Definition at line 28 of file perf-oci8.inc.php.