-
编辑 删除
后台回滚的表是否能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...
