2011-06-30

understand AWR

Understand each field of AWR [ID 884046.1]

cursor_sharing = ‘SIMILAR’ no more available in 11G

ANNOUNCEMENT: Deprecating the cursor_sharing = ‘SIMILAR’ setting [ID 1169017.1]

2011-06-29

Px Query caused Latch Free Waits

Px Query Caused Latch Free Waits [ID 1306688.1]

PX DEQ CREDIT SEND BLKD

Tips to Reduce Waits for "PX DEQ CREDIT SEND BLKD" at Database Level [ID 738464.1]

2011-06-23

Murphy

"orice persoană urcă pînă cînd atinge limita de incompetenţă"

Murphy

"orice persoană urcă pînă cînd atinge limita de incompetenţă"

2011-06-22

ORA-38788: More standby database recovery is needed

Creating Restore Point Or Open Read Only on Physical Standby Database Fails With ORA-38784 ORA-38788 OR ORA-16004 ORA-01196 ORA-01110 [ID 845013.1]


2011-06-15

Connections to 11g TNS Listener are slow

Connections To 11g TNS Listener are Slow. (Doc ID 561429.1)

ORA-32701 Possible hangs up to hang ID=0 detected


Bug 10013431  Hang / ORA-32701 during / after startup in RAC

 This note gives a brief overview of bug 10013431 (Doc ID 10013431.8 )

This problem is introduced in 11.2.0.2 .

Shortly after or during instance startup in RAC, one or many of the instances
end up in a hang state waiting for a LB or NB DLM resource.

Rediscovery Notes:
 - RAC on 11.2.0.2 
 - a hang occurs shortly after instance startup where there is no blocking
   session to be found from system state or hang analysis
 - Alert messages like below may be seen;
 "ORA-32701: Possible hangs up to hang ID=0 detected"
 
 
This bug is fixed in 11.2.0.2.1 ( 11GR2 patchset 1, PSU1 ) 

2011-06-14

banii

"De multe ori, banii costa prea mult"

a bug of JDBC 10.2 with JDK 1.5

original link : http://marist89.blogspot.com/2008/12/bug-part-ii.html
Oracle (the database software) let a bad piece of data in. Oracle says the client should type the data when binding. I agree. But I also think that the server shouldn't let non-numeric data into numeric columns, regardless. I contend that this is a bug on the server side as well as a bug on the client side. This is only one specific case of a Java program inserting bad data.

2011-06-10

ORA-3136 WARNING: inbound connection timed out

A possible cause may be SGA latch contention 
The theory is that while the shared_pool was being re-sized in the SGA, Oracle grabbed a latch. The memory resize operation took a while and while Oracle held that latch, nobody could login.

See the following link : http://marist89.blogspot.com/2009/08/sga-latch-contention.html 


2011-06-08

Memory Notification: Library Cache Object loaded into SGA

Memory Notification: Library Cache Object Loaded Into Sga [ID 330239.1]

2011-06-06

java jvm and oracle ilearning

Is A Java Virtual Machine (JVM) Required For ILearning Client Machines? (Doc ID 413598.1)


oracle ilearning

Oracle iLearning Release 5.0 

kkpo_rcinfo_defstg

UPDATE: bug 10373381 is fixed in PSU2 ( 11.2.0.2.2 ) - see below

ORA-00600[KKPO_RCINFO_DEFSTG:OBJNOTFOUND] ON 11.2 DATABASES AFTER UPGRADE [ID 1308400.1]


2011-06-01

ASM Crashes as HAIP Does not Failover When Two or More Private Network Fails

ASM Crashes as HAIP Does not Failover When Two or More Private Network Fails (Doc ID 1323995.1):

 

ofsa 4.5.39 and oracle 11g

Certification: Is OFSA 4.5.39 Certified with Oracle RDBMS 11G? (Doc ID 762238.1)

 

OFSA 4.5.39 and above is certified with Oracle RDBMS 11G Release 1 and 2.