通过前面的介绍相信大家对Oracle SQL monitor华丽、直观的界面留下了深刻的印象,下面我再总结一下使用Oracle SQL monitor进行SQL优化的步骤: 通过SQL monitor监控我们可以快速地发现异常运行的SQL语句,如果您知道SQL对应的SQL ID也可以通过脚本利用SQL monitor查看SQL语句在数据库中真实的执行计划
对于绝大多数OLTP系统来说,SQL相对比较简单,每次的运行时间都非常快,绝大部分SQL的响应时间都应该在10MS以下,优化的复杂度也比较低,SQL MONITORING功能的出现并不是为了帮助DBA发现、诊断OLTP SQL的性能问题,而是为了加快DBA优化数据仓库类SQL的效率,这些SQL是偏OLAP系统的,特点是并发量低、运行时间久、SQL复杂度高。
select dbms_sqltune.report_sql_monitor from dual; 除了调用DBMS_SQLTUNE包得到报告外,此外可以采用以下2种方式来得到SQL Monitor内容: (1)EM的:Performance —〉右下角的SQL Monitoring —〉Monitored SQL Executions (2) SQL Developer的:Tools Monitor SQL 格式丰富的SQL Monitor报告 当然这些都是SQL Monitor常...
http://www.eygle.com/sqlmon/after.html 关于这个新特性的参考链接: http://www.os2ora.com/use-sql-monitor-report-to-tune-and-diagnose-sql/ http://www.os2ora.com/fantastic-11gr2-sql-monitor-report/ http://www.oracle-base.com/articles/11g/real-time-sql-monitoring-11gr1.php http://docs...
(such as, num_rows, blocks, avg_row_len and so on) of tablechecking_tablespace_growth.sql- Checking the growth of tablespacechecking_tablespace_growth_2.sql- The 2nd version of checking the growth of tablespacemonitor_big_table_size.sql- Monitoring the used size of big tables by using ...
The scripts can be generated to the screen, or they can be saved as a SQL Script. You can generate the create scripts for all objects for a specific schema, specific object types, or specific objects. To generate a DDL statement: On the Workspace home page, click the Utilities icon. ...
Monitoring Search PL/SQL Security Application Express Data Modeler Migration User Defined Basic tabular Master-detail Charts Gauges HTML Drill down Script Most of the provided reports include click-through. If a user clicks on a resulting row, the definition of the object in that row is displayed...
Oracle SQL Access Advisor 说明 一.说明 1.1 相关内容 在如下官方文档中提到了一些优化工具的说明: Monitoring and Tuning the Database http://docs.oracle.com/cd/E11882_01/server.112/e10897/montune.htm Using Advisors to Optimize DatabasePerformance...
Monitoring Search PL/SQL Security Application Express Data Modeler Migration User Defined Basic tabular Master-detail Charts Gauges HTML Drill down Script Most of the provided reports include click-through. If a user clicks on a resulting row, the definition of the object in that row is displayed...
Support for Azure Data Factory (ADF) pipeline monitoring SSMA v9.1 The v9.1 release of SSMA for Oracle contains the following changes: Support for at scale data migration from Oracle to SQL with integration of Azure Data factory Add support for exclusion of system generated invisible column for ...