perf_oci8 Class Reference

Inheritance diagram for perf_oci8:

Public Member Functions
	perf_oci8 (&$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 19 of file perf-oci8.inc.php.

Member Function Documentation

CheckMemory()

perf_oci8::CheckMemory

(

)

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

References $rs, and rs2html().

clearsql()

perf_oci8::clearsql

(

)

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

References $sql, and adodb_perf\table().

DynMemoryUsage()

perf_oci8::DynMemoryUsage

(

)

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

References $rs, and rs2html().

ExpensiveSQL()

perf_oci8::ExpensiveSQL

(

$numsql = 10

)

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

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

Explain()

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

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

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

FlashUsage()

perf_oci8::FlashUsage

(

)

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

References $rs, and rs2html().

LogMode()

perf_oci8::LogMode

(

)

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

perf_oci8()

perf_oci8::perf_oci8

(

&

$conn

)

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

References $conn, and $gSQLBlockRows.

PGA()

perf_oci8::PGA

(

)

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

PGA_Advice()

perf_oci8::PGA_Advice

(

)

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

References $rs.

RMAN()

perf_oci8::RMAN

(

)

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

References $rs, and rs2html().

SuspiciousSQL()

perf_oci8::SuspiciousSQL

(

$numsql = 10

)

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

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

TableSpace()

perf_oci8::TableSpace

(

)

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

References $rs.

tohtml()

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

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

References $rs, and $sql.

Referenced by ExpensiveSQL(), and SuspiciousSQL().

TopHistoricalWaits()

perf_oci8::TopHistoricalWaits

(

)

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

References $rs, and rs2html().

TopRecentWaits()

perf_oci8::TopRecentWaits

(

)

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

References $rs, and rs2html().

WarnIndexCost()

perf_oci8::WarnIndexCost

(

$val

)

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

WarnPageCost()

perf_oci8::WarnPageCost

(

$val

)

Definition at line 319 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 28 of file perf-oci8.inc.php.

$noShowIxora

perf_oci8::$noShowIxora = 15

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

$settings

perf_oci8::$settings

Definition at line 37 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 23 of file perf-oci8.inc.php.

$version

perf_oci8::$version

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