Oracle數(shù)據(jù)庫實用腳本

maclean

以下是Maclean.Liu所編寫或收集的Oracle數(shù)據(jù)庫實用腳本的列表，在這里分享一下：

Script:收集Enterprise Manager Grid Control/Agent/Database Control診斷信息Script:收集Exadata診斷信息
Script:收集RAC診斷信息Script:收集自動SGA內存管理ASMM診斷信息
Script:Collect vip resource Diagnostic Information
11g新特性:hangdiag.sql實例hang診斷腳本
Script:verify Oracle Object timestamp discrepancy
Script:SQL調優(yōu)健康檢查腳本
Script:列出本會話的細節(jié)信息
利用rowid分塊實現(xiàn)非分區(qū)表的并行update與delete
Script:計算Oracle Streams進程所占用的內存大小
利用RMAN檢測數(shù)據(jù)庫壞塊的腳本
Script:利用外部表實現(xiàn)SQL查詢Oracle告警日志Alert.log
Script: 收集RAC DRM 診斷信息
Script:10g中不用EM顯示Active Session Count by Wait Class
Script:數(shù)據(jù)庫最近的性能度量
Script:收集數(shù)據(jù)庫中用戶的角色和表空間等信息
Script:收集介質恢復診斷信息
Script:收集Flashback Database Log診斷信息
Script:列出Oracle每小時的redo重做日志產生量
Script:收集11g Oracle實例IO性能信息
Script:檢查數(shù)據(jù)庫當前是否有備份操作在執(zhí)行中
Script:List Schema/Table Constraints
Script:RAC Failover檢驗腳本loop.sh
Scriptiagnostic Resource Manager
Script:List Grid Control Jobs
Script:GridControl Repository Health Check
Script:診斷Scheduler信息
Script:優(yōu)化crs_stat命令的輸出
Scriptiagnostic Oracle Locks
Script:列出用戶表空間的定額
Backup Script:Expdp Schema to ASM Storage
Script:Speed Up Large Index Create or Rebuild
Script:列出失效索引或索引分區(qū)
Script:列出數(shù)據(jù)庫中5%以上鏈式行的表
Script:列出沒有主鍵或唯一索引的表
Script:收集ASM診斷信息
Script:收集Oracle備份恢復信息
監(jiān)控一個大事務的回滾
Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)
Script:partition table into rowid extent chunks
Script:Oracle EBS數(shù)據(jù)庫初始化參數(shù)健康檢查腳本
Script:Monitoring Memory and Swap Usage to Avoid A Solaris Hang
SQL腳本:監(jiān)控當前重做日志文件使用情況
Streams Health Check on 10g Release 2
從視圖查詢表分區(qū)的相關信息
Script To Monitor RDBMS Session UGA and PGA Current And Maximum Usage Over Time
Script:收集RAC性能診斷信息
Script:收集UNDO診斷信息
Script:列出數(shù)據(jù)庫中子表上沒有對應索引的外鍵
Script: Listing Memory Used By All Sessions
Collecting Diagnostic Data for OCFS2 Issues
Script to Identify Objects and Amount of Blocks in the Buffer Pools – Default, Keep, Recycle, nK Cache
Script:Generate A DDL Script For A Table
SCRIPT TO CHECK FOR FOREIGN KEY LOCKING ISSUES
如何找出Oracle中需要或值得重建的索引
Scriptiagnostic ORA-01000 maximum open cursors exceeded
ORA-4030 PGA Usage Diagnostic Script
Script:Tune Very Large Hash Join
Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql)
Script:List Buffer Cache Details
Script:List NLS Parameters and Timezone
Script:List SORT ACTIVITY
Script:List OBJECT DEPENDENTScript:Logfile Switch Frequency MapScript:Tablespace ReportScript:收集數(shù)據(jù)庫安全風險評估信息腳本:格式化的V$SQL_SHARED_CURSOR報告腳本:監(jiān)控并行進程狀態(tài)腳本:監(jiān)控數(shù)據(jù)庫中的活躍用戶及其運行的SQL
腳本:監(jiān)控臨時表空間使用率
Script to show Active Distributed Transactions
Gather DBMS_STATS Default parameter
Scriptatafile Report
Script to Collect Data Guard Diagnostic Information
Script:To Report Information on Indexes
ORA-4031 Common Analysis/Diagnostic Scripts
Script:when transaction will finish rollback
Script: Computing Table Size

renxiao2003

東西挺多啊。

cow977

好東東。

doni

更希望LZ直接把原創(chuàng)內容放到CU上來

pandu

支持一下��！

oncb

好東西，感謝分享

guyeh

牛人一個

boe163

東西夠多的

baiyangdw

謝謝分享，我是來學習和獲取積分的。呵呵

moon38sun

看著很好，可惜我都訪問不了