-
编辑 删除
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 Target State Host -----------------------------------...
-
编辑 删除
11g的v$sql_shared_memory视图没数据
查询视图v$sql_shared_memory没有数据返回SYS@db1>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....
-
编辑 删除
Hijacking user's password
在不知道数据库账号密码的情况下，如果需要以此账号登录，有两个方法:1.临时修改密码SYS@db1>select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2...
-
编辑 删除
partition table with Pending statistics
用Pending statistics测试sql的执行计划时,如果是分区表，Pending statistics无效.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 - Pro...
-
编辑 删除
Pstart and Pstop in sql plan with interval partition
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 for Lin...
-
编辑 删除
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/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSORA-39083: Object type INDEX_STATISTICS fai...
-
编辑 删除
dbca in Silent Mode
version: 11.2.0.4DBCA response file sample: $ORACLE_HOME/assistants/dbca/dbca.rspdbca -silent -responseFile ./dbca.rspcommand line:dbca -silent -createDatabase \ -templateName General_Purpose.dbc \ -gdbname orcl -sid orcl -responseFile NO_VALUE \ -characterSet zhs16gbk \&nb...
-
编辑 删除
put table in read-only mode
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...
-
编辑 删除
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_CLIENT=/tmp/net_client_traceDIAG_ADR_ENABLED=OFF服务端(不需要重启listener):修改$ORACLE_HOME/network/admin/sqlnet.oraTRACE_LEVEL_SERVER = 16TRACE_FILE_SERVER = SERVERTRACE_DIRECTORY...
-
编辑 删除
用增量备份定期恢复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...
