Oracle DBA 常用 Script 第二部分（Tuning）

　　以下是目录：
　　
　　
　　Active Transactions in Rollback Segments
　　Best Tablespace Utilization Report by Far
　　Buffer Cache Hit Ratio
　　Calculate Dictionary Cache Ratio
　　Calculate Individual Cache Hit Ratios
　　Calculate the Library Cache Ratio for the Whole system
　　Calculate the number of Days Hours and Minutes Between 2 Dates
　　Catalog.txt
　　Check how may extents an object has and what tablespaces it maps to etc
　　Check Session Level Hit Ratio
　　Data Blocks Used By a Table
　　data files space usage
　　Database Space Usage Report
　　DB Block Efficiency Script
　　DB Growth over time
　　Display the current sessions with the operations they are performing
　　Estimate Space Utilization Script
　　EXPLAIN and get some statistics on your SQL
　　FILE IO
　　Find Full Table Scans
　　Fragmentation Monitor
　　Free space report by tablespace
　　Freespace in Tablespace
　　Identify top 20 Oracle Processes in Unix
　　Keep tablespace usage 80%
　　List Session Specific Memory
　　List the size of Stored Procedures and use it to tune Shared Pool
　　Monitor and Verify Deadlocks and Waiting Sessions
　　Monitor IO by Tablespace and Data File
　　Oracle DBA 常用 Script Tuning.doc
　　Quota By User
　　Rate of Storage Usage in the Tablespace
　　Reaching Max Extents
　　Read values one by one at a time from a string separated by
　　Redo Latch Contention Monitor
　　Rollback Segment Contention
　　Rollback Segment Wrap Time Monitoring Script
　　Rollback Statistics
　　Script to monitor user activity on the database
　　Script to show all free extents on tablespace
　　script to show all rollback segments
　　SGA Sizing
　　Show tablespace usage
　　Simple script to show Tablespace Size Freespace and Usage
　　Sorts Monitoring Scripts
　　Table Index Report
　　Table Shared Mem Usage Report
　　Table that is highly fragmented
　　Table usage report
　　Tablespace Coalesce Script
　　Tablespace Information Report
　　Tablespace Space Usage
　　Tablespace Summary and Freespace Report
　　Tablespace used space
　　The script takes owner of the table and the table name and detects row chaining
　　THE Tablespace Report
　　This script exports data
　　This script will monitor file system growth and email it to sysadmin
　　Transaction Processing Rate
　　Types of Contention a Database Instance is or is not Experiencing
　　Unused areas in a data file
　　Used and Free Space Comparison
　　Useful Scripts for Tablespace Management
　　View of all sessions
　　Who is currently running what SQL
　　
　　

查看本文来源