enq: US - contention

查询等待事件: 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 ...

2018-12-07 18:33:47

阅读数 72

评论数 0

SQL Profiles的force_match参数在不改变代码的情况下解决没有使用绑定变量的问题

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) 如...

2018-08-07 07:22:32

阅读数 215

评论数 0

orabbix 启动报错 WARNING: Error while registering Oracle JDBC Diagnosability MBean.

一. 报错信息如下: [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.O...

2018-01-22 17:32:40

阅读数 685

评论数 0

查看统计信息脚本

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 ...

2016-11-29 16:05:30

阅读数 437

评论数 0

10046 oradebug sql跟踪

SQL> oradebug setmypid Statement processed. SQL> oradebug event 10046 trace name context forever, level 12; Statement processed. SQL> se...

2016-11-29 15:17:15

阅读数 195

评论数 0

执行计划显示执行顺序

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

2016-11-29 15:00:09

阅读数 625

评论数 0

统计信息失准导致CBO选错执行计划一例

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

2016-11-28 18:52:47

阅读数 378

评论数 0

union union all group by 优化一例

一. 原执行计划本SQL是公司显示屏报表SQL,每2min更新一次 SQL> explain plan for select distinct id_card from (select t.id_card from clspuser.crf_p2p_a...

2016-11-14 15:26:17

阅读数 3078

评论数 0

adrci 问题打包

[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. ...

2016-02-29 10:28:13

阅读数 457

评论数 0

ORA-01555 caused by SQL

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): ...

2016-01-12 11:14:37

阅读数 385

评论数 0

atch: shared pool 优化探索

首先来看赤裸裸的问题直击: Top 10 Foreground Events by Total Wait Time Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time W...

2015-12-22 16:55:27

阅读数 425

评论数 0

awr ash 等报告收集总结

@?/rdbms/admin/awrgrpt.sql   Rac 收集 @?/rdbms/admin/awrrpt.sql 2个时间段对比 @?/rdbms/admin/awrddrpt.sql SQL> @?/rdbms/admin/ashrpt.sql   Defaults to ...

2015-12-22 12:43:39

阅读数 410

评论数 0

Cursor_sharing

2

2015-12-22 11:47:58

阅读数 437

评论数 0

'library cache lock' Waits: Causes and Solutions

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

2015-12-21 12:35:50

阅读数 425

评论数 0

ORA-16957: SQL Analyze time limit interrupt

巡查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...

2015-12-21 11:09:49

阅读数 3454

评论数 0

oracle 失效对象

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

2015-12-14 14:26:34

阅读数 2954

评论数 0

oracle 执行计划 方法汇总

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

2015-12-10 10:49:12

阅读数 638

评论数 0

ADRCI

Automatic Diagnostic Repository (ADR) The Automatic Diagnostic Repository (ADR) is a file-based repository for database diagnostic data such as tr...

2015-12-09 17:18:54

阅读数 335

评论数 0

11g ADRCI

1.概述 在Oracle中,各个组件(监听器、数据库实例、各种配置工具)在安装和运行时都会有相应的日志Log和跟踪文件Trace生成。 Oracle 11g之前,这些信息都是零散的分布在Oracle组件目录中的。在11g,Oracle推出了ADR(Automatic Diagnostic Rep...

2015-12-09 14:34:11

阅读数 559

评论数 0

17 Automatic SQL Tuning

17 Automatic SQL Tuning  This chapter discusses the automatic SQL tuning features of Oracle Database. Automatic SQL tuning automates the manual proc...

2015-11-22 11:32:16

阅读数 626

评论数 0

提示
确定要删除当前文章?
取消 删除
关闭
关闭