- 博客(44)
- 收藏
- 关注
转载 AUDIT_SYS_OPERATIONS in 12c
12c里AUDIT_SYS_OPERATIONS参数的缺省值是TRUE, 以前的版本缺省值是FALSE导致的结果是audit_file_dest目录的aud文件变大,因为很多系统任务的sql写到了aud文件里,比如收集...
2017-04-01 10:59:08
258
转载 unused column
由于对大表dorp column很耗时,可以先用 set unused逻辑删除,等找到时间窗口再做物理删除,所以usused的列是不可以恢复的。create table t ( x int not null, y...
2017-03-31 15:41:28
237
转载 multi index on same column in 12c
12c可以在相同的列上建多个索引,但是只能有一个是"visible"的,应用这个功能,可以比较方便地把某个索引修改为分区索引来减少"热块"。create table t as select * from dba_ob...
2017-03-30 09:13:04
109
转载 vector i/o and BATCHED TABLE ACCESS
从11g开始,Nested Loop Joins 的i/o操作有了优化, 叫做vector i/oOracle Database 11g introduces a new implementation for nested...
2017-03-29 08:39:07
198
转载 abou AMM
在12cR2的文档中建议使用AMMAbout Memory Management (page 6-2)The memory structures that must be managed are the system g...
2017-03-24 10:51:11
121
转载 using sql prfile to ignore hints
有些开发工程师喜欢在sql里加hint, 希望走自认为高效的执行计划,但往往事与愿违,加了hint的sql反而走了不好的执行计划,碰到这种情况,在不能修改代码的情况下,可以用sql profile来忽略这些hint,创建...
2017-03-22 15:01:38
115
转载 sqlplus -L
用shell脚本执行sql,经常会需要写入账号,密码,例如:cat a.sqlselect * from dual;exitcat a.shsqlplus test/test @a.sqlsh...
2017-03-13 15:00:10
477
转载 adjust scn by poke kcsgscn_
11g以后手工修改scn的手段:adjust_scn,_minimum_giga_scn都失效了但是可以修改内存变量来修改scnSYS@bbb>select current_scn from v$datab...
2017-02-26 18:15:35
125
转载 where did the data of function:scn_to_timestamp come from?
scn_to_timestamp的scn和time的对应关系从何而来?是来自于系统表smon_scn_time吗?用10046去trace"select scn_to_timestamp(xxxxxxx) from du...
2017-02-26 16:59:03
92
转载 根据hint手工创建sqlprofile
TEST@bbb>select * from v$version;BANNER----------------------------------------------------------------...
2017-02-24 05:23:40
104
转载 VIPs Often Go Offline Unexpectedly and Relocate to Another Node
两个两节点的RAC数据库(OS:AIX 5300-11-04-1015, DB:10.2.0.4/10.2.0.5),经常发生VIP漂移到另一个节点.$ crs_stat -tName Type ...
2016-11-22 10:21:09
134
转载 11g的v$sql_shared_memory视图没数据
查询视图v$sql_shared_memory没有数据返回SYS@db1>select * from v$version;BANNER--------------------------------------...
2016-10-19 15:43:03
120
转载 Hijacking user's password
在不知道数据库账号密码的情况下,如果需要以此账号登录,有两个方法:1.临时修改密码SYS@db1>select * from v$version;BANNER--------------------...
2016-10-18 13:56:45
83
转载 partition table with Pending statistics
用Pending statistics测试sql的执行计划时,如果是分区表,Pending statistics无效.select * from v$version;BANNER-----------------...
2016-10-13 15:46:47
88
转载 Pstart and Pstop in sql plan with interval partition
select * from v$version;BANNER--------------------------------------------------------------------------------...
2016-10-13 12:33:28
165
转载 impdp with ORA-39083: Object type INDEX_STATISTICS failed to create with error
version(source,destination): 11.2.0.4impdp导入数据时报错:Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXPr...
2016-10-12 16:35:38
441
转载 dbca in Silent Mode
version: 11.2.0.4DBCA response file sample: $ORACLE_HOME/assistants/dbca/dbca.rspdbca -silent -responseFil...
2016-10-12 13:42:31
115
转载 put table in read-only mode
SQL> select * from v$version;BANNER------------------------------------------------------------------------...
2016-10-11 16:04:25
253
转载 Setting up Oracle Network Tracing on the Client and Server in 11g
客户端:修改$ORACLE_HOME/network/admin/sqlnet.oraTRACE_LEVEL_CLIENT=16TRACE_UNIQUE_CLIENT=ONTRACE_DIRECTORY_CL...
2016-10-11 15:23:13
75
转载 用增量备份定期恢复image copy backup
SQL> select * from v$version;BANNER------------------------------------------------------------------------...
2016-10-11 10:10:24
359
转载 convert range partition to interval partition
SQL> select * from v$version;BANNER------------------------------------------------------------------------...
2016-10-10 14:35:19
84
转载 impdp/expdp with filtering
expdp/impdp通过query参数来过滤数据:写在命令行上需要加转义符: query=\"where object_id\<1000 \"写在parfile里不要加转义符:query="where objec...
2016-09-29 10:10:02
131
转载 Abort PQ_SLAVE_MISMATCH
文档的解释: Top-level slave decides not to share cursor意思是说: 并行执行计划中,slave进程不能共享Query Coordinator生成的cursor, slave进程自己...
2016-09-28 16:00:07
334
转载 v$enabledprivs
SQL> select * from v$version;BANNER------------------------------------------------------------------------...
2016-09-28 08:12:37
111
转载 Auto trace user's session
create user user1 identified by user1;grant conenct,resource,alter session to user1;conn user1/user1create o...
2016-09-25 14:03:29
129
转载 Datapump Does not Export Permissions on Other Schema
SQL> select * from v$version;BANNER------------------------------------------------------------------------...
2016-09-25 10:14:02
66
转载 self lock on library cache pin
SQL> select * from v$version;BANNER--------------------------------------------------------------------...
2015-12-17 16:57:10
66
转载 handle parse fail
SQL> select * from v$version;BANNER--------------------------------------------------------------------...
2015-12-17 13:30:23
336
转载 Bug 4991675
隐含参数_trace_kqlidp可以定位procedure,function等对象的失效原因, 在11.2.04上需要先patch 4991675[oracle@node1 4991675]$ opatch lsinv...
2015-12-17 08:48:42
93
转载 max row number of rowid
在extended ROWID里, 最后两个字节(16bit)表示row number, 从这个角度来说最大的row number是65535, 但是实际上最大的row number是32767,这可以从两个角度理解:1...
2015-12-11 10:06:25
192
转载 From 11G listener log is opened on every write
1.10.2.0.5total 0lrwx------ 1 oracle oinstall 64 Dec 3 18:04 9 -> socket:[19702]lrwx------ 1 oracle oins...
2015-12-08 07:36:11
53
转载 adaptive log file sync
看看polling方式下系统调用情况SQL> select * from v$version;BANNER--------------------------------------------------...
2015-12-07 18:32:01
149
转载 event 10261 and pga
event 10261 可以作为临时处理ora-4030错误的一个手段[oracle@node1 bdump]$ oerr ora 1026110261, 00000, "Limit the size of the ...
2015-12-07 17:07:01
103
转载 trigger on clob
SCOTT @ db1 >select * from v$version;BANNER-------------------------------------------------------...
2015-12-03 13:37:45
92
转载 case语句中比较null
case语句有两种:Simple CASE和Searched CASESearched CASE可以用来比较nullSQL> select * from v$version;BANNER...
2015-11-27 16:54:18
241
转载 11g里创建手工sample schemas
如果建数据库时没有选择建sample schemas,可以用以下步骤手工创建:SQL> select * from v$version;BANNER-----------------------------...
2015-11-27 16:37:51
125
转载 get full view definition from v$fixed_view_definition
[oracle@node1 ~]$ uname -aLinux node1 2.6.32-200.13.1.el5uek #1 SMP Wed Jul 27 21:02:33 EDT 2011 x86_64 x86_64 x86...
2013-07-03 20:00:22
58
转载 simulate row cache lock on dc_object_ids
TEST @ racdb1 >select * from v$version;BANNER---------------------------------------------------------------...
2013-05-28 08:44:31
122
转载 how does to find all events ?
os:linuxdb:102051.alter session set events 'immediate trace name events';2.oradebug eventdump sessio...
2012-08-09 14:26:58
53
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人