风哥Oracle数据库巡检工具2.6-网页版(配使用视频)

教程发布:风哥 教程分类:Oracle下载, 文章资源, 资源下载 更新日期:2019-04-19 浏览学习:552

风哥Oracle数据库巡检工具2.6-网页版(配使用视频),提供100多项目oracle检查指标,生成web网页版结果,Oracle巡检内容包括6大方面:
1、Oracle数据库和实例信息
2、Oracle数据库存储信息
3、Oracle数据库对象信息
4、Oracle数据库备份信息
5、Oracle数据库性能信息
6、Oracle操作系统与硬件信息

Oracle巡检工具健康检查指标详细如下:
1.Database and Instance Information
 1.1 Database and Instance Information 
 1.2 Initialization Parameters 
 1.3 Profiles Parameters
 1.4 Props Information 
 1.5 Control Files 
 1.6 Online Redo Logs
 1.7 Redo Log Switches 
 1.8 Archiving Mode 
 1.9 Archive Destinations
 1.10 Archiving Instance Parameters 
 1.11 Archiving History 
 1.12 DataGuard Status
 1.13 Flashback Database Parameters 
 1.14 Flash Recovery Area Status 
 1.15 Database Options
 1.16 Database Registry 
 1.17 Feature Usage Statistics 
 1.18 Scn HealthCheck
2. Database Storage Information
 2.1 Asm Disk Info 
 2.2 Asm Diskgroup Info 
 2.3 Tablespaces
 2.4 Data Files 
 2.5 Temp File 
 2.6 Data Files Header
 2.7 Database Growth 2
 .8 Owner Data Size 
 2.9 Owner to Tablespace
 2.10 UNDO Retention Parameters 
 2.11 UNDO Segments 
 2.12 UNDO Segment Contention
3. Database Objects Information
 3.1 User Accounts 
 3.2 Users With DBA Privileges 
 3.3 User Priv
 3.4 Roles 
 3.5 Default Passwords 
 3.6 DB Links
 3.7 Scheduler Jobs 
 3.8 Object Summary 
 3.9 Segment Summary
 3.10 Invalid Objects 
 3.11 Procedural Object Errors 
 3.12 Collect Analyazed Tables and Indexex
 3.13Public Synonym 
 3.14 Trigger Check 
 3.15 Disabled Constraints
 3.16 Indexes Foreign Key 
 3.17 Tables With No Logging 
 3.18 LOB Segments
 3.19 Users With Default Tablespace - (SYSTEM) 
 3.20 Users With Default Temporary Tablespace - (SYSTEM) 
 3.21 Objects in the SYSTEM Tablespace
 3.22 NO-Primary-Key Table 
 3.23 Materialized Vier 3.24 Recycle Bin
4. Database Backup Information
 4.1 RMAN Backup Jobs 
 4.2 RMAN Configuration 
 4.3 RMAN Backup Sets
 4.4 RMAN Backup Pieces 
 4.5 RMAN Backup Control Files 
 4.6 RMAN Backup SPFILE
 4.7 Directories 
 4.8 Directory Privileges 
 4.9 Data Pump Jobs
 4.10 Data Pump Sessions 
 4.11 Data Pump Job Progress 
5. Database Performance Information
 5.1 Wait Event Summary 
 5.2 Current Sessions 
 5.3 Locking Information Medium Detail
 5.4 SGA Information 
 5.5 SGA (ASMM) Dynamic Components 
 5.6 PGA Target Advice
 5.7 AWR Snapshot List 
 5.8 AWR Snapshot Size Estimates 
 5.9 File IO Statistics
 5.10 File IO Timings 
 5.11 Index and Table Degree Check 
 5.12 Full Table Scans
 5.13 Sorts 
 5.14 Outline Hints 
 5.15 High Water Mark Statistics
 3.16 Tables Suffering From Row Migration 
 5.17 SQL Statements by Elapsed Time 
 5.18 SQL SQL Statements by Executions
 5.19 SQL Statements by Disk Reads 
 5.20 SQL Statements by Buffer Gets 
6. Operating System Information
 6.1 Listener And Tnsnames 
 6.2 Oracle Opatch 
 6.3 Oracle Processes
 6.4 Oracle Clusterware 
 6.5 Profile and Crontab 
 6.6 FileSystem
 6.7 OS Version 
 6.8 OS_etc_Hosts 
 6.9 OS_ip_route
 6.10 OS Swapinfo 
 6.11 OS Vmstate 
 6.12 Hardware Information

风哥Oracle数据库巡检工具2.6-网页版,免费下载地址:

风哥Oracle数据库巡检工具2.6-网页版(配使用视频)此处内容已经被作者隐藏,请输入验证码查看内容
验证码:
请关注本站微信公众号,回复“fgedu”,获取验证码。在微信里搜索“风哥教育”或者“itpux_com”或者微信扫描右侧二维码都可以关注本站微信公众号。

网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】【Oracle RAC】Linux系统Oracle11gR2 RAC安装配置详细过程V3.1(图文并茂)
【下一篇】Linux学习之面试题02_Shell脚本_互联网Shell编程35个经典面试答案