Understand each field of AWR [ID 884046.1]
You've got to have a dream. When you lose your dreams, you die.
2011-06-30
cursor_sharing = ‘SIMILAR’ no more available in 11G
ANNOUNCEMENT: Deprecating the cursor_sharing = ‘SIMILAR’ setting [ID 1169017.1]
2011-06-29
PX DEQ CREDIT SEND BLKD
Tips to Reduce Waits for "PX DEQ CREDIT SEND BLKD" at Database Level [ID 738464.1]
2011-06-24
kxfrSmGetSlaveByPnum
ORA-7445 [kxfrSmGetSlaveByPnum] from Parallel merge into INTERVAL partitioned table [ID 1332825.1]
2011-06-23
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
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.
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
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)
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]
ORA-00600[KKPO_RCINFO_DEFSTG:OBJNOTFOUND] ON 11.2 DATABASES AFTER UPGRADE [ID 1308400.1]