Profile cover photo
Profile photo
hw 12345
2 followers
2 followers
About
Posts

Post has attachment
Rman Duplicate database from Active database
From 11g above, you can use rman to duplicate database from an active database instead of from a backup. Two big disadvantages of the ACTIVE database duplication
method are: ·Negative performance impact on the source database. This impact applies to the who...
Add a comment...

Post has attachment
Oracle 10/11 install on Centos 7
For 10.2.0.1: If you get error “Error
in invoking target 'collector' of makefile
'/orasw/app/oracle/product/10.2.0/sysman/lib/ins_emdb.mk'” at 83% can be
ignored (Metalink 957982.1) For 11.2.0.4: If you get the following error: PRVF-7532 : Package "pdksh"
i...
Add a comment...

Post has attachment
RAC: ORA-01410: invalid ROWID
Can try flushing the cache: alter system flush buffer_cache;
Add a comment...

Post has attachment
ORA-03114 and ORA-03137
Oracle Version: 11.2.0.1 Client sessions disconnected due to error "ORA-03114: Not Connected to Oracle". In Alert log ORA-03137 is detected: "ORA-03137: TTC protocol internal error : [12333] [8] [57] [48] [] [] [] [] ". This has been reported in unpublished...
Add a comment...

Post has attachment
optimizer_index_cost_adj hint
Sometimes you want to use alter session set optimizer_index_cost_adj=<value> to change the parameter, but you can also use hint for the purpose, for example: select /*+ opt_param('optimizer_index_cost_adj',20) */ col1, col2 . .
Add a comment...

Post has attachment
Session hang because 'gc cr request' and 'cr request retry'
In 11g Rac, during datapump import, session hangs at step of importing indexes of constraints. If you check v$session_wait for the sid, you may notice  'gc cr request' and 'cr request retry': SQL> select event from
v$session_wait where sid=405; EVENT ----...
Add a comment...

Post has attachment
SqlDeveloper 4.0 or later freezes
Starting from version 4.0, you may notice SqlDeveloper "freezes" quite regularly; it simply does nothing and does not accept keyboard input or mouse clicks. It remains in that state for 20 or 30 seconds, then continues to work normally. No error message or ...
Add a comment...

Post has attachment
windows process perl.exe Consumes High CPU
The Database Control (DB Control) Consumes High CPU - BEGIN EMD_NOTIFICATION.QUEUE_READY (Doc ID 734536.1) Grid Control Agent Consumes High CPU when Executing parse-log1.pl / Log File Monitoring Metric (Doc ID 757877.1)
Add a comment...

Post has attachment
Aix get last day of current month
cal | awk '($0 != "") {F=$NF} END {print F}' You can also find out the last day of any month by providing month and year to cal. for example: cal 2 2012|awk '($0 != "") {F=$NF} END {print F}' 29 cal 10 2011|awk '($0 != "") {F=$NF} END {print F}' 11
Add a comment...

Post has attachment
Wait while more posts are being loaded