- 博客(97)
- 收藏
- 关注
转载 10.2和以上版本的pga动态工作区管理
10.2和以上版本的pga动态工作区管理:_pga_max_size范围为200m到2g(64位)1g(32位)当_pga_max_size=200m的时候,工作区的大小由_smm_max_size决定,_smm_max_siz...
2011-12-22 15:24:06
141
转载 database records an archived log in the control file
The archiver process archives a redo logRMAN restores an archived logThe RMAN BACKUP AS COPY command c...
2011-06-03 15:00:05
138
转载 When RMAN Performs Control File Autobackups
By default, control file autobackups are turned off, and no control file autobackups are performed. If CONFIGURE...
2011-06-01 10:05:31
136
转载 Planning an Incremental Backup Strategy
Choose a backup scheme according to an acceptable MTTR (mean time to recover). For example, you can implement a ...
2011-05-31 17:20:49
129
转载 Multiple Copies of RMAN Backups
1、 it is not possible to duplex backup sets to the flash recovery area用FRA区域存放bankupset的时候无法采用多路技术RMAN> del...
2011-05-31 15:23:17
103
转载 关于flashback log
Flashback Database uses its own logging mechanism, creating flashback logs which are stored in the flash recovery ...
2011-05-31 10:54:20
249
转载 maximum control file size??
The maximum control file size is 20000 database blocks. If DB_BLOCK_SIZE equals 8192, then the maximum control fil...
2011-05-17 10:41:54
125
转载 Renaming a Datafile in the Primary Database
When you rename one or more datafiles in the primary database, the change is not propagated to the standby databas...
2011-05-12 15:14:45
80
转载 Duplicate Database fails with Rman-5001 [ID 334588.1]
Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.5 to 11.2.0.2 - Release: 9.2 to 11.2Information in...
2011-05-11 14:33:39
150
转载 Oracle backup fails with error RMAN-06056: could not access datafile
ProblemOracle backup fails with error "RMAN-06056: could not access datafile".SolutionRMAN OUTPUTcould...
2011-05-11 09:33:35
337
转载 后台回滚的表是否能truncate
今天有个同事反映在删除大表的时候锁住了,一问是需要全部清理,竟然采用delete;一问还好没有删除多长时间,马上kill session,进行回滚,查看v$fast_sart_transactions和v$fast_star...
2010-11-02 17:46:48
246
转载 obj stat mem leak when global temporary tables used [ID 6347725.8]
程序用到很多事务临时表,并在执行过程中导致综合入口miscellaneous快速增加,对照两个snap日志发现perm减少的大小和正好和miscellanoues增加的大小差不多,正好和Bug 6347725"obj sta...
2010-05-14 19:22:17
675
转载 ORA-01190或1189的处理过程
SQL> startupORACLE 例程已经启动。Total System Global Area 838860800 bytesFixed Size 1293336 byt...
2010-05-07 11:18:05
316
转载 How to identify a session started by a remote distributed transaction
select username, osuser, status, sid, serial#, machine, process, terminal, programfrom v$sessionwhere saddr in (se...
2010-03-31 22:45:23
79
转载 where temp segment of temp table are created
Temporary segmentTemporary segments are created by Oracle when a SQL statement needs a temporary databas...
2010-03-29 11:01:17
63
转载 Force dynamic sampling for Global Temporary Tables
上线前业务测试过程中,需要找出低效以及潜在的抵消语句,发现有一个语句是个潜伏的定时炸弹:select distinct CATA_ID from PD_CATA_DICT where eff_datesysdate star...
2010-03-10 10:52:27
100
转载 正在执行的cursor无法从share pool中purge
今天应用测试的时候发现一个语句执行很慢,通过session找出sql_Id,看了下执行计划,一个小表对一个大表做nl关联,而且大表是全表扫描,不用问,执行计划的问题,于是查看对象是否做表分析,发现表分析20刚做过,通过v$sql...
2010-03-08 22:52:06
119
转载 关于alter table modify cloumn需要注意的
alter table add columnalter table drop columnalter table modify column三种操作是有区别的,其中 alter table add column...
2010-03-06 15:56:56
1335
转载 Oracle Senior DBA Wanted
Description:The Oracle DBA is a member of a top DBA Team responsible for eBay global Oracle database system. Res...
2010-03-05 14:33:26
84
转载 相关truncate/drop table的bug
bug 3282805: TRUNCATE TABLE SCANS FOR SMALL TABLES ENTIRE BUFFERCACHE数据库版本9.2.0.4PROBLEM:--------Truncate tabl...
2010-02-26 19:59:05
127
转载 Range Partitioning 中VALUES LESS THAN 算法
dsi 302 lession 8The VALUES LESS THAN clause applies to all of the partitioning columns collectively. Therefore,...
2009-10-27 16:06:46
1311
转载 10g synonym也可以invalid
10g之前,同义词从来不会invalid,因为没有依赖关系,10g中synonym和base之间有了依赖关系,具体可以查看视图DBA_DEPENDENCIES;导致synonym失效的原因见如下几种:This can h...
2009-10-27 14:23:07
146
转载 assm不仅可以减少buffer busy wait等待还可以减少itl等待
对于assm可以减少buffer busy wait中的freelist断头块争用很多文章都有提到过,今天做了个实验,对于insert操作也可以分离块的选择,对于不同的session选择不同的块进行insert,test如下...
2009-07-23 11:58:09
137
转载 oracle中的userenv及sys_context的参数
1、 USERENV(OPTION) 返回当前的会话信息. OPTION='ISDBA'若当前是DBA角色,则为TRUE,否则FALSE. OPTION='LANGUAGE'返回数据库的字符集. OPTION='SESS...
2009-06-17 14:53:04
75
转载 system dump-----------Library Object Lock State Object
Example: LIBRARY OBJECT LOCK: lock=30a6d48 handle=323fe98 mode=X call pin=0 session pin=0 user=302714c session=...
2009-06-09 23:08:45
241
转载 system dump------------Enqueue State Object
Example: (enqueue) MR-00000008-00000000 [O8: DID: -- ] lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res:30...
2009-06-09 22:56:02
53
转载 gc cr request 'gcs log flush sync'
This is how it happens -1)You fired an update statement on Instance-2. 2)However, the request for desired blocks w...
2009-06-01 07:46:32
122
转载 bind peeking
Create Table PreferredMeals (EmpID Number(5), Meal Varchar2(10) ) / Begin For i in 1..74998 Loop Insert Into Pre...
2009-05-25 11:26:02
69
转载 invalidate the plans in shared pool
To invalidate any cursor,one of the followings can be done:1. Issue the command Alter System Flush Shared_Poo...
2009-05-25 11:23:55
66
转载 table 和index的parallel
在建表和索引的过程中,可以指定parallel参数来加快速度,但是很多人使用之后忘记将他们改回去,导致sql的效率低下,为了找出库中这些表和索引,我们可以使用以下语句select degree,count(*) from d...
2009-05-13 12:40:56
166
转载 批量create table出现的等待
上线过程中由于应用的需要,将大量分区非常多的分区表分成单表,于是需要批量create table,起了100个进程同时并发create table,过程中出现了大量的enq: TX - row lock contention...
2009-05-09 19:06:18
118
转载 Mutexes in Oracle10g
摘要Mutexes的介绍从http://archive.netbsd.se/?ml=oracle-l&a=2006-04&t=1969601To improve cursor execution and also...
2009-05-07 20:16:00
46
转载 cursor: pin S
OTN的解释,cursor: pin SA session waits on this event when it wants to update a shared mutex pin and another sessi...
2009-05-07 20:13:49
131
转载 sql plan enhancements in 10g
Since the days of Version 7, Oracle has been exposing more (and more detailed) diagnostic information to its users...
2009-05-07 19:40:33
105
转载 kksfbc child completion & cursor: pin S
The problem seems to be the following: Session 1 gets a child cursor for a table_x_x_xxxx_x_x ...
2009-05-07 18:07:37
111
转载 Static Service Registration (SID_LIST) Section
一直使用listener.ora中的静态注册,但一直没有系统学习其中各部分的含义,今天看到trace listener顺便学习一下You can use the SID_LIST section of the listene...
2009-05-05 12:12:59
92
转载 row cache lock等待事件一例
上线前第一次预演:有多进程ctas大表的时候数据中出现了大量的row cache lock,由于前期也用同样的脚本导过一次,速度很快,就没有非空闲等待事件,所以很奇怪,既然问题出现了,只奇怪是没用的,row cache只有看看v...
2009-05-03 16:15:28
256
转载 ORA-00600: internal error code, arguments: [ktadrprc-1]
忘记关recyclebin了,现在回收站占了很大的空间,想清一下回收站start time09050207:02:38 PMpurge dba_recyclebin*ERROR at line 1:ORA-00600: in...
2009-05-02 19:41:46
185
转载 10g Recyclebin Features And How To Disable it( _recyclebin )
Doc ID: 265253.1In this DocumentPurposeScope and Application10g Recyclebin Features And How To Dis...
2009-04-30 10:13:51
77
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人