熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle DBA 常用 Script 第二部分(Tuning)

2013-11-13 15:42:16  來源: Oracle 

  以下是目錄
  
  
  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 Dates
  Catalogtxt
  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 Oracle Processes in Unix
  Keep tablespace usage %
  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 Tuningdoc
  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
  

From:http://tw.wingwit.com/Article/program/Oracle/201311/17167.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.