perf_oci8 Class Reference

Public Member Functions
	perf_oci8 (&$conn)
	LogMode ()
	TopRecentWaits ()
	TopHistoricalWaits ()
	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 ()
Data Fields
	$noShowIxora = 15
	$tablesSQL
	$version
	$createTableSQL
	$settings

---

Detailed Description

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

---

Member Function Documentation

CheckMemory

(

)

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

Here is the call graph for this function:

clearsql

(

)

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

DynMemoryUsage

(

)

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

Here is the call graph for this function:

ExpensiveSQL

(

$

numsql = 10

)

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

Here is the call graph for this function:

Explain	(	$	sql,
		$	partial = false
	)

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

Here is the call graph for this function:

FlashUsage

(

)

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

Here is the call graph for this function:

LogMode

(

)

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

perf_oci8

(

&$

conn

)

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

PGA

(

)

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

PGA_Advice

(

)

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

RMAN

(

)

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

Here is the call graph for this function:

SuspiciousSQL

(

$

numsql = 10

)

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

Here is the call graph for this function:

tohtml	(	&$	rs,
		$	type
	)

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

Here is the caller graph for this function:

TopHistoricalWaits

(

)

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

Here is the call graph for this function:

TopRecentWaits

(

)

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

Here is the call graph for this function:

WarnIndexCost

(

$

val

)

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

WarnPageCost

(

$

val

)

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

---

Field Documentation

$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 = 15

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

$settings

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

$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

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

---

The documentation for this class was generated from the following file:

• C:/xampp/htdocs/moodle/lib/adodb/perf/perf-oci8.inc.php