-
编辑 删除
10.2和以上版本的pga动态工作区管理
10.2和以上版本的pga动态工作区管理：_pga_max_size范围为200m到2g（64位）1g（32位）当_pga_max_size=200m的时候，工作区的大小由_smm_max_size决定，_smm_max_size等于pga_aggregate_target的20%当pga_aggregate_t...
-
编辑 删除
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 copies a logThe RMAN CATALOG command catalogs a user-managed backup of an archived log...
-
编辑 删除
When RMAN Performs Control File Autobackups
By default, control file autobackups are turned off, and no control file autobackups are performed. If CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN automatically backs up the control file and th...
-
编辑 删除
Planning an Incremental Backup Strategy
Choose a backup scheme according to an acceptable MTTR (mean time to recover). For example, you can implement a three-level backup scheme so that a full or level 0 backup is taken monthly, a cumulati...
-
编辑 删除
Multiple Copies of RMAN Backups
1、 it is not possible to duplex backup sets to the flash recovery area用FRA区域存放bankupset的时候无法采用多路技术RMAN> delete noprompt backupset;using channel ORA_DISK_1RMAN> show all;RMAN conf...
-
编辑 删除
关于flashback log
Flashback Database uses its own logging mechanism, creating flashback logs which are stored in the flash recovery area. You can only use Flashback Database if flashback logs are available. Therefore, ...
-
编辑 删除
maximum control file size？？
The maximum control file size is 20000 database blocks. If DB_BLOCK_SIZE equals 8192, then the maximum control file size is 156 MB.另外只有在10g之后control file才能自动扩展
-
编辑 删除
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 database. Therefore, if you want to rename the same datafiles on the standby database, you mu...
-
编辑 删除
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 this document applies to any platform.***Checked for relevance on 15-Dec-2010*** Sym...
-
编辑 删除
Oracle backup fails with error RMAN-06056: could not access datafile
ProblemOracle backup fails with error "RMAN-06056: could not access datafile".SolutionRMAN OUTPUTcould not read file header for datafile 189 error reason 1 released channel:ch0RMAN-00571: ======...
-
编辑 删除
后台回滚的表是否能truncate
今天有个同事反映在删除大表的时候锁住了，一问是需要全部清理，竟然采用delete；一问还好没有删除多长时间，马上kill session，进行回滚，查看v$fast_sart_transactions和v$fast_start_servers是采用parallel进行...
-
编辑 删除
obj stat mem leak when global temporary tables used [ID 6347725.8]
程序用到很多事务临时表，并在执行过程中导致综合入口miscellaneous快速增加，对照两个snap日志发现perm减少的大小和正好和miscellanoues增加的大小差不多，正好和 Bug 6347725 "obj stat mem" leak when ...
-
编辑 删除
ORA-01190或1189的处理过程
SQL> startupORACLE 例程已经启动。Total System Global Area 838860800 bytesFixed Size ...
-
编辑 删除
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 (select k2gtdses from sys.x$k2gte );
-
编辑 删除
where temp segment of temp table are created
Temporary segmentTemporary segments are created by Oracle when a SQL statement needs a temporary database area to complete execution. When the statement finishes execution, the extents in the tem...
-
编辑 删除
Force dynamic sampling for Global Temporary Tables
上线前业务测试过程中，需要找出低效以及潜在的抵消语句，发现有一个语句是个潜伏的定时炸弹：select distinct CATA_ID from PD_CATA_DICT where eff_date<sysdate and exp_date>sysdate start With CATA_ID in (se...
-
编辑 删除
正在执行的cursor无法从share pool中purge
今天应用测试的时候发现一个语句执行很慢，通过session找出sql_Id，看了下执行计划，一个小表对一个大表做nl关联，而且大表是全表扫描，不用问，执行计划的问题，于是查看对象是否做表分析，发现表分析20刚做过，通...
-
编辑 删除
关于alter table modify cloumn需要注意的
alter table add columnalter table drop columnalter table modify column三种操作是有区别的，其中 alter table add columnalter table drop column两种操作不会涉及对源表的dml操作，modify可能会产生源表...
-
编辑 删除
Oracle Senior DBA Wanted
Description:The Oracle DBA is a member of a top DBA Team responsible for eBay global Oracle database system. Responsibilities:· Work with different team member to deploy ebay application with proper...
-
编辑 删除
相关truncate/drop table的bug
bug 3282805: TRUNCATE TABLE SCANS FOR SMALL TABLES ENTIRE BUFFERCACHE数据库版本9.2.0.4PROBLEM:--------Truncate table takes on system with large buffercaches to long. It scans the complete cache to f...
