References
GENERAL
Information
qgeninfosrdb.sql
Display information on Server and database
1.0
01.09.2010
JON
Init. Parameter
qgenparachgt.sql
Display init parameter had been changed
1.0
01.09.2010
JON
NLS parameters
qgenparanls.sql
Display NLS database parameters
1.0
01.09.2010
JON
Oracle Options
qgenpaidopt.sql
Display paying option activated and resources setting, limits and HWM
1.0
01.09.2010
JON
Alertlog
qgenalerora.sql
Display information error ORA- on Alertlog
1.0
01.09.2010
JON
MEMORY
Information
qmemparainfo.sql
Display init parameter for memory
1.0
01.09.2010
JON
AMM
qmemammadvce.sql
Display Automatic Memory Managment advisor for memory
1.0
01.09.2010
JON
SGA
qmemsgacompo.sql
Display SGA componant for memory
1.0
01.09.2010
JON
qmempoolresz.sql
Display resizing in the SGA for memory
1.0
01.09.2010
JON
qmemsgaadvce.sql
Display SGA advisor for memory
1.0
01.09.2010
JON
qmembuffstats.sql
Display Buffer Cache pool ratio for memory
1.0
01.09.2010
JON
qmembufadvce.sql
Display Buffer cache advisor for memory
1.0
01.09.2010
JON
qmemshaadvce.sql
Display Shared pool advisor for memory
1.0
01.09.2010
JON
qmemjavadvce.sql
Display java pool advisor for memory
1.0
01.09.2010
JON
qmemstradvce.sql
Display stream pool advisor for memory
1.0
01.09.2010
JON
PGA
qmempgaadvce.sql
Display PGA advisor for memory
1.0
01.09.2010
JON
qmempgastats.sql
Display PGA statistics for memory
1.0
01.09.2010
JON
DATABASE STRUCTURE
Storage
qdbsstotype.sql
Display Storage Type
1.0
01.09.2010
JON
Controlfiles
qdbsctrldate.sql
Display date information on Controlfiles
1.0
01.09.2010
JON
qdbsctrlpath.sql
Display path information on Controlfiles
1.0
01.09.2010
JON
Redologs
qdbsredoswcd.sql
Display switch information per day on Redologs
1.0
01.09.2010
JON
qdbsredoswch.sql
Display switch information per hour on Redologs
1.0
01.09.2010
JON
qdbsredopath.sql
Display path and size information on Redologs
1.0
01.09.2010
JON
Tablespaces
qdbstbssize.sql
Display Information & sizing about tablespaces
1.0
01.09.2010
JON
Datafiles
qdbsdatfsize.sql
Display Information & sizing about datafiles and tempfiles
1.0
01.09.2010
JON
Segments Distribution
qdbsownsize.sql
Display size by owner and segment type
1.0
01.09.2010
JON
qdbsowncach.sql
Display segments in cache
1.0
01.09.2010
JON
qdbstbsdist.sql
Display segment distribution by tablespace
1.0
01.09.2010
JON
Triggers
qdbstrigown.sql
Display Trigger and Event by schema
1.0
01.09.2010
JON
qdbstrigdb.sql
Display Trigger and Event on database
1.0
01.09.2010
JON
Others
qdbsothdblink.sql
Display db link information
1.0
01.09.2010
JON
qdbsothlobs.sql
Display lobs information
1.0
01.09.2010
JON
qdbsothtempt.sql
Display temporary table information
1.0
01.09.2010
JON
qdbsothextt.sql
Display external table information
1.0
01.09.2010
JON
INSTANCE ACTIVITY
Information
qinaparainfo.sql
Display optimizer parameter informations
1.0
01.09.2010
JON
Objects Statistics
qinaobjtstat.sql
Display tables without statistics
1.0
01.09.2010
JON
qinaobjistat.sql
Display indexes without statistics
1.0
01.09.2010
JON
qinastalestat.sql
Display objects with stale Statistics Informations
1.0
01.09.2010
JON
System Statistics
qinasysstat.sql
Display System Statistics Informations
1.0
01.09.2010
JON
Undo Activity
qinaundosegm.sql
Display undo segment information
1.0
01.09.2010
JON
Lock Activity
qinalocksess.sql
Display lock session information
1.0
01.09.2010
JON
qinalockobj.sql
Display lock object information
1.0
01.09.2010
JON
Parallel Activity
qinaparaacti.sql
Display parallel information
1.0
01.09.2010
JON
High Water Mark
qinahwmacti.sql
Display high water mark information
1.0
01.09.2010
JON
qinahwminfo.sql
Display High Water Mark, usage: @qinahwminfo.sql schema object
1.0
13.02.2012
NIJ
BACKUP
Information
qbacparainfo.sql
Display backup parameters Informations
1.0
01.09.2010
JON
RMAN
qbacrmaninca.sql
Display RMAN incarnations Information
1.0
01.09.2010
JON
qbacrmaninfo.sql
Display RMAN datafile Backup Information
1.0
01.09.2010
JON
qbacrmandata.sql
Display RMAN datafile Backup Information
1.0
01.09.2010
JON
qbacrmanfreq.sql
Display RMAN Type and frequency Informations
1.0
01.09.2010
JON
qbacrmanarch.sql
Display RMAN archivelogs status Informations
1.0
01.09.2010
JON
qbacrmanctrl.sql
Display RMAN controlfile status Informations
1.0
01.09.2010
JON
qbacrmanspfi.sql
Display RMAN Spfile status Informations
1.0
01.09.2010
JON
qbacrmanobso.sql
Display RMAN Obsolete status Informations
1.0
01.09.2010
JON
Flash Recovery Usage
qbacflashreco.sql
Display flashback recovery usage
1.0
01.09.2010
JON
Recyclebin Usage
qbacrecyusag.sql
Display recyclebin usage
1.0
01.09.2010
JON
SECURITY
Information
qsecparainfo.sql
Display security parameter informations
1.0
01.09.2010
JON
Roles and Grants
qsecroledba.sql
Display role DBA granted
1.0
01.09.2010
JON
qsecsyspriv.sql
Display system privilege information
1.0
01.09.2010
JON
qsecrolepubl.sql
Display role granted to public
1.0
01.09.2010
JON
qsecgranpck.sql
Display privilege on package with security holes
1.0
01.09.2010
JON
Audit
qsecaudiinfo.sql
Display audit Information
1.0
01.09.2010
JON
qsecaudiobj.sql
Display audit object Information
1.0
01.09.2010
JON
qsecaudipriv.sql
Display audit privilege Information
1.0
01.09.2010
JON
qsecauditrai.sql
Display audit trails Information
1.0
01.09.2010
JON
Policies
qsecpolifunc.sql
Display policies function Information
1.0
01.09.2010
JON
HIGH AVAILABILITY
Data Guard
qhavdatginfo.sql
Display Data Guard Informations
1.0
01.09.2010
JON
qhavdatgconf.sql
Display Data Guard configuration
1.0
01.09.2010
JON
qhavdatglogf.sql
Display Data Guard standby Log File Informations
1.0
01.09.2010
JON
qhavdatggap.sql
Display Data Guard archives gap Informations
1.0
01.09.2010
JON
RAC
qhavracinfo.sql
Display RAC Informations
1.0
01.09.2010
JON
Free Hand Scripts
Parameter
qvfhparameter.sql
Display parameters and hidden parameters with matches patterns
1.0
01.09.2010
JON
Create roles
qvfhcrerole.sql
Display creation role statments from a source
1.0
01.07.2011
JON
Create users
qvfhcreuser.sql
Display creation user statments from a source
1.0
01.07.2011
JON
Show Session
qvfhselsession.sql
Display active session and statment
1.0
01.07.2011
JON
Privileges
qvfhgrantsys.sql
Display grant statement for direct granted sys privileges
1.0
23.06.2010
HER
Performance
qvfhawrcheckio.sql
Display average I/O waits for a specific tablespace at a given hour from AWR snapshots
1.0
17.02.2012
YAN
Last updated