Oracle数据库实用脚本

以下是Maclean.Liu所编写或收集的Oracle数据库实用脚本的列表，在这里分享一下：  

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调优健康检查脚本 Script:列出本会话的细节信息 利用rowid分块实现非分区表的并行update与delete Script:计算Oracle Streams进程所占用的内存大小 利用RMAN检测数据库坏块的脚本 Script:利用外部表实现SQL查询Oracle告警日志Alert.log Script: 收集RAC DRM 诊断信息 Script:10g中不用EM显示Active Session Count by Wait Class Script:数据库最近的性能度量 Script:收集数据库中用户的角色和表空间等信息 Script:收集介质恢复诊断信息 Script:收集Flashback Database Log诊断信息 Script:列出Oracle每小时的redo重做日志产生量 Script:收集11g Oracle实例IO性能信息 Script:检查数据库当前是否有备份操作在执行中 Script:List Schema/Table Constraints Script:RAC Failover检验脚本loop.sh Script:Diagnostic Resource Manager Script:List Grid Control Jobs Script:GridControl Repository Health Check Script:诊断Scheduler信息 Script:优化crs_stat命令的输出 Script:Diagnostic Oracle Locks Script:列出用户表空间的定额 Backup Script:Expdp Schema to ASM Storage Script:Speed Up Large Index Create or Rebuild Script:列出失效索引或索引分区 Script:列出数据库中5%以上链式行的表 Script:列出没有主键或唯一索引的表 Script:收集ASM诊断信息 Script:收集Oracle备份恢复信息 监控一个大事务的回滚 Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql) Script:partition table into rowid extent chunks Script:Oracle EBS数据库初始化参数健康检查脚本 Script:Monitoring Memory and Swap Usage to Avoid A Solaris Hang SQL脚本:监控当前重做日志文件使用情况 Streams Health Check on 10g Release 2 从视图查询表分区的相关信息 Script To Monitor RDBMS Session UGA and PGA Current And Maximum Usage Over Time Script:收集RAC性能诊断信息 Script:收集UNDO诊断信息 Script:列出数据库中子表上没有对应索引的外键 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中需要或值得重建的索引 Script:Diagnostic 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 DEPENDENT Script:Logfile Switch Frequency Map Script:Tablespace Report Script:收集数据库安全风险评估信息 脚本:格式化的V$SQL_SHARED_CURSOR报告 脚本:监控并行进程状态 脚本:监控数据库中的活跃用户及其运行的SQL 脚本:监控临时表空间使用率 Script to show Active Distributed Transactions Gather DBMS_STATS Default parameter Script:Datafile 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 Script to Detect Tablespace Fragmentation "hcheck.sql" script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g Script to Prevent Excessive Spill of Message From the Streams Buffer Queue To Disk Oracle Systemstate dump analytic tool: ASS.AWK V1.09 SCRIPT TO GENERATE SQL*LOADER CONTROL FILE