Beebee-massage - beebee-massage.ch - Ask The Real Tom
General Information:
Latest News:
What is “Enq: FB contention” in oracle? 1 Jun 2012 | 08:56 pm
“Enq: FB contention” is an ASSM enque wich ensures that only one process format the block. This happen usually on parallel inserts on the same table.
Downgrade Oracle Database 11.2.0.3 to 11.2.0.2 27 Apr 2012 | 07:02 pm
Downgrading 11.2.0.3 to 11.2.0.2 works. But like everything with oracle 11.2 you have to apply a patch. Oracle Restart (GI) is used for this setup. # current release shutdown immediate startup dow...
Check if oracle online patch is active on an specific instance 3 Aug 2011 | 07:21 pm
Actually i go an error ORA-600 [kkoipt:incorrect pwj] on 11.2 an i applied the patch 9929660. But the error occured on a instance again. So i was wondering how i can check if the online patch is acti...
ORA-00600: internal error code, arguments: [ktfa_get_hist_objn] 12 Apr 2011 | 12:39 am
I hade recently some trouble with Flashback Data Archive (Total Recal, FBDA) on Oracle 11.2.0.2 On a dissasciate Statement like: exec DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA('USER','TABLE'); Follow...
enq:CR - block range reuse ckpt 21 Mar 2011 | 11:29 pm
“enq:CR - block range reuse ckpt” http://forums.oracle.com/forums/thread.jspa?messageID=9170907 I think the problem is this: when doing parallel DML, Oracle uses direct path reads to read the data. ...
Oracle Unbreakable Enterprise Linux Kernel - Info Pice 2 Nov 2010 | 12:47 am
I am just search since hours for the oracleasm-2.6.32 package … an just coulnd find it. Now I just came across this pice of information. Maybe it shortens my search http://www.oracle.com/us/technolo...
Oracle ASM Disk Overview 31 Jul 2010 | 02:38 am
I’ve wrote a simple SQL script to list all ASM disks with state, size and their diskgroups, if any. The output looks as follow:
MySQL solution: Speed up pattern searches starting with a wildchar (like ‘%abc%’) 30 Jul 2010 | 09:04 pm
Searches on MySQL with expression like ” … like ‘%abc%’” can be incredibly slow on large tables. The problem is, MySQL can not use indices for expression starting with a wildcard “%”. Neither MySQL ...
Set lock_sga to true on Linux (SLES) 30 Jul 2010 | 12:01 am
To lock the SGA into physical memory you have to set the lock_sga parameter to true. Usually you get following Error message. SQL> startup SQL> ORA-27102: out of memory Linux-x86_64 Error: 12: Can...
Enable and Validate Constraints in Parallel (Oracle) 29 Jul 2010 | 01:51 am
Enabling and validating constraints is can take a huge amount of time in big oracle databases. To speed the validaten up, it can be done in parallel. This can save you valuable time in release windo...
