Troubleshooting ORA-01031: Insufficient Privileges issue

1, Login in remote instance using sqlplus as sys when the target db instance password file not exists or file name is wrong.
2, If you try to execute DBMS_SESSION.SET_CONTEXT


Autotask(Optimizer statistics gathering) not working in未自动收集统计信息)

有一些表数据发生了很大变化,但是统计信息从初次导入后从没有自动收集过统计信息,导致现在的有些执行计划不成确, 手动收集是可以成功的,如何开启自动收集? oracle RAC ON AIX

, , ,

IMPDP hangs, session wait “wait for unread message on broadcast channel”

昨晚有个朋友说加班在IMPDP数据, 在导入中途突然没有了进展,挂在那里不动了,impdp 窗口也没有报错, 一直等了1个多小时,说是impdp使用了parallel,怀疑是parallel参数出了问题, 最终其实原因很简单。这里只是简单的描述遇到这类问题时的处理思路。

Duplicate (Clone) Oracle Database to the Same Machine (同一机器数据库还原)(二)

When an DB operation error occurred , and flashback technique can not be used, you can use this way do a database point in time recover on same db server, to clone a new db to recover, then drop.

Duplicate (Clone) Oracle Database to the Same Machine (同一机器数据库还原)(一)

Starting with Oracle 11g there are now two ways to clone a database:
1. Active Database Duplication
2. Backup-based Duplication