EVISWANG的博客

alert报错如下： Thu Dec 31 14:36:38 2015 ORA-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>    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 desc SQL>  EVENT                      ...

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参数在不改变代码的情况下解决没有使用绑定变量的问...

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

一. 原执行计划本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

sosi.txt set echo off set scan on set lines 150 set pages 66 set verify off set feedback off set termout off column uservar new_value Table_Owner noprint select user uservar from dual; set termout

SQL> oradebug setmypid Statement 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

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

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

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

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

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

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

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

首先来看赤裸裸的问题直击： Top 10 Foreground Events by Total Wait Time Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class latch: shared pool 1,592 20.

2

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

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

一.方法汇总 --环境构造 --研究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

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

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