文件名称：oracle数据库健康检查及调优脚本
文件大小：274KB
文件格式：SQL
更新时间：2023-05-15 05:55:43
oracle sql 脚本 优化
参加oracle原厂培训，老师给的，很好用，介绍给大家 Produces an HTML report with a list of observations based on health-checks performed in and around a SQL statement that may be performing poorly. Inputs a memory-resident SQL_ID. In addition to the health_check report, it generates some additional diagnostics files regarding SQL performance. This script does not install any objects in the database. It does not perform any DDL commands. It only performs DML commands against the PLAN_TABLE then it rolls back those temporary inserts. It can be used in Dataguard or any read-only database.