Module pysqlaudit

source code

This module defines all high level audit functions of pysql

Author: Sébastien Delcros (Sebastien.Delcros@gmail.com)

License: GNU GPL V3

Functions

[hide private]

listSnapshotId(db, numDays=1)
Prompts user to choose a snapshot id

source code

addmReport(db, begin_snap="0", end_snap="0", type="TEXT", level="TYPICAL")
Generates ADDM report

source code

awrReport(db, type="txt", begin_snap="0", end_snap="0")
Generates AWR report

source code

sqlTune(db, statement, type="TEXT", level="TYPICAL")
Generates a SQL tunung advice report

source code

duReport(db, segmentType, tbs="%", user="%", nbRows=-1)
Generates storage report

source code

assmReport(db, name)
Generates a storage report (may take a while)

source code

Function Details

[hide private]

listSnapshotId(db, numDays=1)

source code

Prompts user to choose a snapshot id

Parameters:

db - connection object
numDays - the number of days of snapshots

addmReport(db, begin_snap="0", end_snap="0", type="TEXT", level="TYPICAL")

source code

Generates ADDM report

Parameters:

db - connection object
begin_snap - snapshot
end_snap - snapshot

awrReport(db, type="txt", begin_snap="0", end_snap="0")

source code

Generates AWR report

Parameters:

db - connection object
type - output format (html or text)
begin_snap - snapshot
end_snap - snapshot

sqlTune(db, statement, type="TEXT", level="TYPICAL")

source code

Generates a SQL tunung advice report

Parameters:

db - connection object
statement - sql statement to be tuned

duReport(db, segmentType, tbs="%", user="%", nbRows=-1)

source code

Generates storage report

Parameters:

db - connection object
segmentType - type (table or index)
tbs - tablespace to analyze, all if not specified
user - user to analyze, all users if not specified
nbRows - number of lines to return, all if not specified

assmReport(db, name)

source code

Generates a storage report (may take a while)

Parameters:

db - connection object
name - table name