TYPO3 CMS  TYPO3_6-2
•All Classes Namespaces Files Functions Variables Pages
Public Member Functions | Public Attributes | List of all members
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.