我们可以通过v$sql_bind_capture 捕获到 bind values 这篇文章主要阐述v$sql_bind_capture与v$sql_plan的一些联系
SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 28 14:07[......]
August 28, 2012 Internals, oracle No comments internal
我们可以通过v$sql_bind_capture 捕获到 bind values 这篇文章主要阐述v$sql_bind_capture与v$sql_plan的一些联系
SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 28 14:07[......]
August 17, 2012 Internals, maintain, oracle 2 comments structure
帮朋友check一次中国银联数据库的坏块问题(并不是严格意义上的坏块),大致情况为smon需要trascation recover —>特定的block 发现无法读取 —>transaction recover出现问题 —>smon terminated
Wed Aug 15 19:02[……]
June 7, 2012 Internals, oracle No comments structure
对于BITMAP index的使用 一直存在一些争议 我们来看看下面几个观点：
1. Low cardinality – Some dabase vendor, like Oracle, provides very practical suggestion
If the num[……]
June 7, 2012 Internals, oracle No comments internal
今天开发因为连接数不够 强烈要求加大processes值,突然想到了processes对_cursor_db_buffers_pinned的影响,,小记之:
当会话需要pin住buffer header时它首先要获去buffer handle,实例所存在的buffer handle总数由(ea[……]
June 6, 2012 Internals, oracle 4 comments internal
Oracle latch internals
Server latch implementation called KSL, e.g. every table with name starting with x$ksl… is latch
related and every[……]
April 20, 2012 Internals, oracle No comments scripts
Execution Environment:
Access Privileges:
Requires to be run connected as SYS schema
Usage:
$ sqlplus
SQL*Plus: Release 9.2.0.2.[……]
昨天看了roger的一篇文章，如何在创建index 之前估算它的大小，这里有一种更简单的方法实现：
主要思路就是采用了dbms_space.create_index_cost这个包
–create a testing table named t
SQL> create tabl[……]
March 6, 2012 Internals, oracle, RAC No comments RAC
Rebootless Node Fencing
In versions before 11.2.0.2 Oracle Clusterware tried to prevent a split-brain with a fast reboot (better: reset) of the[……]
February 10, 2012 Internals, oracle No comments scripts
set echo off
————————————————–
— @name: lock_internal
— @author: dion cho
— @description: my own version of[……]
January 13, 2012 Internals, oracle No comments structure
NOLOGGING is supported in only a subset of the locations that support LOGGING. Only the following operations support the NOLOGGING mode:
DML:
1. Dir[……]