Oracle DBA 常用 Script 第二部分（Tuning）
2024-08-29 13:38:34
供稿：網(wǎng)友
以下是目錄：
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 right">（出處：清風軟件下載學院）
