-
编辑 删除
用增量备份定期恢复image copy backup
SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ProductionTNS fo...
-
编辑 删除
convert range partition to interval partition
SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ProductionTNS fo...
-
编辑 删除
using 10237 event to STOP A QUERY OR TRANSACTION IN ANOTHER SESSION
OPTION 1 : DBMS_SYSTEM ( AS SYS )SQL_DBA > select v.sid,v.serial#,p.spid 2 from v$session v,v$process p 3 where v.paddr = p.addr 4 and v.username = 'TUNING'; SID SERIAL# SPID---------------- ---------------- ------------------------...
-
编辑 删除
impdp/expdp with filtering
expdp/impdp通过query参数来过滤数据:写在命令行上需要加转义符: query=\"where object_id\<1000 \"写在parfile里不要加转义符:query="where object_id<1000 "可以加多个"query="参数 "query="参数的where条件后可以加order by "query="参数加表名只对此表有效(query=t1 表示过滤条件只对t1表有效); 不加表...
-
编辑 删除
Abort PQ_SLAVE_MISMATCH
文档的解释: Top-level slave decides not to share cursor意思是说: 并行执行计划中，slave进程不能共享Query Coordinator生成的cursor, slave进程自己hard parse后生成新的cursor看一个由“TEMP TABLE TRANSFORMATION”导致PQ_SLAVE_MISMATCH的例子:SQL> select * from v$version;Oracle Database 11g Enterprise E...
-
编辑 删除
v$enabledprivs
SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ProductionTNS fo...
-
编辑 删除
Auto trace user's session
create user user1 identified by user1;grant conenct,resource,alter session to user1;conn user1/user1create or replace trigger trace_session after logon on user1.schema begin execute immediate 'begin dbms_session.SESSION_TRACE_ENABLE(waits=>true,binds=>true,plan_stat=>''AL...
-
编辑 删除
Datapump Does not Export Permissions on Other Schema
SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ProductionTNS fo...
-
编辑 删除
self lock on library cache pin
SQL> select * from v$version;BANNER----------------------------------------------------------------------------------------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4...
-
编辑 删除
handle parse fail
SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ProductionTNS ...
-
编辑 删除
Bug 4991675
隐含参数_trace_kqlidp可以定位procedure,function等对象的失效原因, 在11.2.04上需要先patch 4991675[oracle@node1 4991675]$ opatch lsinvOracle Interim Patch Installer version 11.2.0.3.4Copyright (c) 2012, Oracle Corporation. All rights reserved.Oracle Home : /oracle/app/o...
-
编辑 删除
max row number of rowid
在extended ROWID里, 最后两个字节(16bit)表示row number, 从这个角度来说最大的row number是65535, 但是实际上最大的row number是32767,这可以从两个角度理解:1.最大的block size 是32k, 所以最大的row number不可能超过327672.用dbms_rowid.rowid_create(..., row_number=>32768)生成的rowid是无效的SQL> selec...
-
编辑 删除
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 oinstall 64 Dec 3 18:04 8 -> socket:[19701]l-wx------ 1 oracle oinstall 64 Dec 3 18:04 7 -> pipe:[19698]lr-x------ 1 oracle oinstall 64 Dec 3 18:04 6 -> /opt/ora10g/produc...
-
编辑 删除
adaptive log file sync
看看polling方式下系统调用情况SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ...
-
编辑 删除
event 10261 and pga
event 10261 可以作为临时处理ora-4030错误的一个手段[oracle@node1 bdump]$ oerr ora 1026110261, 00000, "Limit the size of the PGA heap"// *Cause: the limit is one kilobyte times the level of the event. If the// pga grows bigger than this signal...
-
编辑 删除
trigger on clob
SCOTT @ db1 >select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64biPL/SQL Release 10.2.0.5.0 - ProductionCORE 10.2.0.5.0 ProductionTNS for Linux: V...
-
编辑 删除
case语句中比较null
case语句有两种:Simple CASE和Searched CASESearched CASE可以用来比较nullSQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 -...
-
编辑 删除
11g里创建手工sample schemas
如果建数据时没有选择建sample schemas，可以用以下步骤手工创建:SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionC...
-
编辑 删除
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_64 GNU/Linux SQL> select banner from v$version;BANNER------------------------...
-
编辑 删除
simulate row cache lock on dc_object_ids
TEST @ racdb1 >select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64biPL/SQL Release 10.2....
