Monitoring

    Below are Oracle Scripts to monitor an Oracle Database... feel free to use the scipts listed, all I ask is that you retain the ownership block at the top of each script.

    Disclaimer: User assumes all responsibility; please understand the objective of the script and use it accordingly.  If you do not see a script for a specific function please let me know via eMail and I can probably 'whip' one up in a matter of minutes...

Script Name

Purpose

brwusrck.sql

cache_01.sql

cache_02.sql

cache_03.sql

capt_sql.sql

capt_vw.sql

coes_ext.sql

db_dics01.sql

db_seg01.sql

db_revw1.sql

db_revw2.sql

db_revw3.sql

db_revw4.sql

db_revw5.sql

db_revw5a.sql

dbaext.sql

dbaextsy.sql

dbafiles.sql

dbaind.sql

dbaind2.sql

dbaindec.sql

dbaindmf.sql

dbausers.sql

dcstats.sql

describe.sql

diskio.sql

dsc_dba1.sql

dyn1alt.sql

ext.sql

ext_stat.sql

extent_1.sql

extent_2.sql

file_spa.sql

file_sz.sql

fileio_1.sql

lfragmntd.sql

free_spc.sql

free200.sql

freed.sql

freet.sql

locking1.sql

locking2.sql

locking3.sql

max_read.sql

max_uga.sql

morning.sql

oi_daily.sql

oraenv.sh

proc_001.sql

qry_scrp.sql

rbsegrpt.sql

recsblks.sql

redo_swt.sql

rlbk_seg.sql

rows2blk.sql

segsize.sql

sess.sql

space_01.sql

stats.sql

swdr.sql

swl.sql

swsr.sql

sysalloc.sql

sysfree.sql

tbl_blks.sql

tbl_util.sql

tblsuse.sql

tf2.sql

tot_fs01.sql

tsquota.sql

tssusage.sql

tssuser.sql

v_backup.sql

v_circit.sql

v_databa.sql

v_datafi.sql

v_db_cah.sql

v_dispat.sql

v_instac.sql

v_lib_ca.sql

v_latch.sql

v_open_c.sql

v_option.sql

v_parame.sql

v_pq_sta.sql

v_proces.sql

v_rollbk.sql

v_rowcac.sql

v_sessio.sql

v_sessta.sql

v_syssta.sql

v_waitst.sql

 

Format information about the browser users

Row Cache statistics

Dictionary Cache statistics

Buffer Cache Hit Ratio statistics

Show the current executing SQL

Show the current executing Views

REPORT: COES - Count Of Extents For DB Objects

Show all information about all objects

Display info about all the rollback segments and their status

Display information about: free space

Display tsps size, space utilization and extent growth

Display information about object size/growth patterns 

Display stats after analyzing table/indexes

Database space and storage statistics

Routine to show status of Rollbacks

REPORT: DBAEXT - Table and Index Extents(w/o system)

REPORT: DBAEXTSYS - Table and Index Extents

REPORT: DBAFILES - DATA FILES REPORT

REPORT: DBAIND - Index Column Report

REPORT: DBAIND2 - Index Column Report

REPORT: DBAINDEC - Table and Index Extents

REPORT: DBAINDMFG - Index Column Report

REPORT: DBAUSERS - DBA User Report

REPORT: DCSTATS - Dictionary Cache Stats

Script to describe "all" tables

active data files

Oracle Database Utility Procedure

Script to backup the tablespaces

Count Of Extents For Database Objects

Extent and Tablespace Report

REPORT: Segments that exceed extent cnt

Extent and Tablespace Report:

check various database files

Print the size of the AP (financial) files

detailed data file I/O statistics (BM)

Fragmented TableSpace

Generate several space reports

REPORT: FREE200 - TS Free Space Report

REPORT: Detailed Free Space

REPORT: Total Free Space

Defines who have locks and the type thereof

Determines who (sessions) have what types of locks

Defines sessions in a locking contention situation

REPORT: Sessions With The Highest I/O

session uga memory max

SQL driver to dump stats

REPORT: Orders imported from MOE system

UNIX script to see what Oracle tools are installed

script to show what activity is going on within database

Produce the report of those users accessing the database

REPORT: Rollback Segment Report

Average records per block

Redo log file statistics

show the rollback segments, status and size for a database

Show how many rows-per-block are actually being stored

Segment Sizing

Shows the stats for a given session

show space prblms

Several statistical reports; hit ratio information

Load session wait information

Load session wait information for terminal

Session Wait Summary Report

REPORT: SYSALLOC - System Space Allocated

REPORT: SYSFREE - TS Free Space Report

Table Usage Parameters

Table Utilization

Summarize tablespace usage by segment type and user

Database Freespace Summary

Total Free Space Available

REPORT: TSQUOTA - DBA TS Quotas Report

Tablespace Per Segment Type Per User Summary

REPORT:  Database Tablespace per User Summary

Show statistics about v$backup

Show statistics about v$circuit

Show statistics about v$database

Show statistics about v$datafile

Show statistics about v$db-cache

Show statistics about v$dispatch

Show statistics about v$instance

Show statistics about v$lib_cache

Show statistics about v$latch

Show statistics about v$open_cursors

Show statistics about v$option

Show statistics about v$parameter

Show statistics about v$pq_stat

Show statistics about v$process

Show statistics about v$rollback

Show statistics about v$rowcache

Show statistics about v$session

Show statistics about v$sesstat

Show statistics about v$systat

Show statistics about v$waitstat

 

[Home] [Professional] [Vacations] [All About  Rick]

Have a question or comment... please email me at Rick@Kupcunas.com