EVISWANG的博客

17 Automatic SQL Tuning This chapter discusses the automatic SQL tuning features of Oracle Database. Automatic SQL tuning automates the manual process, which is complex, repetitive, and time-consu

[oracle@db01 ~]$ adrciADRCI: Release 11.2.0.4.0 - Production on Mon Feb 29 10:16:09 2016Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.ADR base = "/u01/PROD/db/11.2

SQL> set autotrace traceonly SQL> select t1.investment_number, 2 nvl(t1.sum1, 0), 3 t2.debt_profit, 4 nvl(t1.sum1, 0) - t2.debt_profit 5 from (select t.investmen

1. 先执行xplan.sql脚本-- -------------------------------------------------------------------------------------------------- Script: xplan.sql---- Author: Adrian Billington--

SQL> oradebug setmypidStatement processed.SQL> oradebug event 10046 trace name context forever, level 12;Statement processed.SQL> select * from scott.emp, scott.dept where emp.deptno=dept.dept

sosi.txtset echo offset scan onset lines 150set pages 66set verify offset feedback offset termout offcolumn uservar new_value Table_Owner noprintselect user uservar from dual;set termout

一. 原执行计划本SQL是公司显示屏报表SQL，每2min更新一次SQL> explain plan for select distinct id_card from (select t.id_card from clspuser.crf_p2p_account_info t where t.loan_amount <= 200000

一. 报错信息如下：[root@adminm conf]# /etc/init.d/orabbix startStarting Orabbix service:[root@adminm conf]# Jan 22, 2018 2:37:06 p.m. oracle.jdbc.driver.OracleDriver registerMBeansWARNING: Error while

How To Use SQL Profiles for Queries Using Different Literals Using the Force_Match Parameter of DBMS_SQLTUNE.ACCEPT_SQL_PROFILE (Doc ID 1253696.1)如何使用SQL Profiles的force_match参数在不改变代码的情况下解决没有使用绑定变量的问...

1.概述在Oracle中，各个组件（监听器、数据库实例、各种配置工具）在安装和运行时都会有相应的日志Log和跟踪文件Trace生成。Oracle 11g之前，这些信息都是零散的分布在Oracle组件目录中的。在11g，Oracle推出了ADR（Automatic Diagnostic Repository）的概念，将这些信息统一的列入到其中管理。在11g中，提供了ADR_HOME目

alert报错如下：Thu Dec 31 14:36:38 2015ORA-01555 caused by SQL statement below (SQL ID: 51hmywh9jz8qg, Query Duration=34461 sec, SCN: 0x0000.26f53fdc):INSERT INTO AGENT_WORKING_RATE_TEMP2( ROW_DATE ,

SQL> select count(*) from dba_objects where status='INVALID';  COUNT(*)----------19SQL>SQL> col owner for a10SQL> select owner, object_name, object_type from dba_objects where status='

16 SQL Tuning Overview  调优概述This chapter discusses goals for tuning, how to identify high-resource SQL statements, explains what should be collected, provides tuning suggestions, and discusses h

@?/rdbms/admin/awrgrpt.sql  Rac 收集@?/rdbms/admin/awrrpt.sql 2个时间段对比@?/rdbms/admin/awrddrpt.sqlSQL> @?/rdbms/admin/ashrpt.sql  Defaults to -15 minsEnter value for begin_time: 12/21/15

一.方法汇总--环境构造--研究Nested Loops Join访问次数前准备工作DROP TABLE t1 CASCADE CONSTRAINTS PURGE; DROP TABLE t2 CASCADE CONSTRAINTS PURGE; CREATE TABLE t1 (    id NUMBER NOT NULL,    n NUMBER,    con

巡查alert发现如下报错：Wed Dec 09 22:16:37 2015Errors in file /u01/PROD/oracle/diag/rdbms/prod/PROD1/trace/PROD1_j000_75313.trc:ORA-16957: SQL Analyze time limit interruptWed Dec 09 23:00:08 2015End

好吧 再去细细读读官档  'library cache lock' Waits: Causes and Solutions (文档 ID 1952395.1)转到底部

2

首先来看赤裸裸的问题直击：Top 10 Foreground Events by Total Wait TimeEventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Classlatch: shared pool1,59220.

Automatic Diagnostic Repository (ADR)The Automatic Diagnostic Repository (ADR) is a file-based repository for database diagnostic data such as traces, dumps, the alert log, health monitor report

查询等待事件：SQL&gt;   1  select s.event, count(s.event)  2   from  v$session s, v$process p  3  where s.PADDR = p.ADDR  4  group by s.event  5* order by 2 descSQL&gt; EVENT                      ...