RAC: ORA-01410: invalid ROWID

Can try flushing the cache:
alter system flush buffer_cache;

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] [] [] [] [] ".

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 . .
  

And optimizer_mode hint:

select /*+ opt_param('optimizer_mode','first_rows_10') */ col1, col2 . . .  

Session hang because 'gc cr request' and 'cr request retry'

In 11g Rac, during datapump import, session hangs at step of importing indexes or 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

----------------------------------------------------------------

gc cr request

SQL> select event from v$session_wait where sid=405;

EVENT

----------------------------------------------------------------

cr request retry

Mostly it's caused by Redo log IO performance or the interconnect performance.

You can try:
1) Improve the interconnect performance.
2) Improve the Redo log I/o performance.
3) Set undersore parameter "_cr_server_log_flush" =false.

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 log entry.

It seems to be a java bug. Updating NVIDIA video driver can improve the performance. The recommended workaround from the Java Bug DB -- set this property by adding a line in sqldeveloper.conf:

AddVMOption -Dsun.awt.nopixfmt=true

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)

Aix get last day of current month

cal | awk '($0 != "") {F=$NF} END {print F}'
or
cal |grep .|fmt -1|tail -1

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