Database » September 4, 2008

« Expand/Collapse

(20 unread)

September 05, 2008
6:50
Mule2.X ESB with OpenMQ4.1 JMS Broker
» ‎ TheServerSide.com

Pawan Modi writes, "Mule2.0 is working fine with the OpenMQ 4.1 broker" and provides all the configuration files necessary for starting and interoperating both.

1:24
How quickly you should expect to see bugs fixed
» ‎ MySQL Performance Blog

Over a year ago I wrote about pretty nasty Innodb Recovery Bug. I ran in the same situation again (different system, different customer) and went to see the status of the bug... and it is still open.

You may thing it is minor issue but in fact with large buffer pool this bug makes database virtually unrecoverable (if 10% of progress in 2hours qualifies as that). It is especially nasty as it is quite hard to predict. Both customers had MySQL crash recovery happening in reasonable time... most of the times until they run into this problem.

So what is the point ? Have modest expectations about when your favorite MySQL bugs are fixed (This is actually Innodb one, so Innobase/Oracle is responsible for fixing it not MySQL/Sun but there are MySQL bugs not fixed for years too). Look for workarounds or ways to fix things yourself.

In particular case workaround was rather easy - reducing Innodb buffer pool size to 4GB instead of 24G and disabling innodb_flush_method=O_DIRECT so OS cache can be used for IOs. This made database to complete crash recovery in 30 minutes.

Entry posted by peter | No comment

Add to: | | | |

September 04, 2008
21:41
Converting CHAR to Numeric via user written function
» ‎ Ask Tom MOST RECENT ARTICLES

Hi Tom, We use the following function to convert numbers in CHAR format to numeric. The data is very dirty so if it can't convert or you get "infinity" we just put in a zero. We run in parallel over billions of rows. It used to be quite slow un...
21:41
outer join to contant
» ‎ Ask Tom MOST RECENT ARTICLES

Hi Tom select * from test where dc_i(+)=552 create table t ( t1 number); insert into t values(1); insert into t values(2); commit; select * from t where t1(+)=3 why last query gives no data
21:41
Long Raw to BLOB
» ‎ Ask Tom MOST RECENT ARTICLES

<code>Hi Tom, We are using an Oracle 8.1.7 database. Is there a way in PL/SQL or Java Stored Procedure to convert a Long Raw into a BLOB? Thanks, Firas Khasawneh </code>
21:41
How to delete duplicated check constraints ?
» ‎ Ask Tom MOST RECENT ARTICLES

<code>Dear Tom, I found there are a lot of duplication checking constraitns in our database. How can I delete all of duplicated checking constraints ? Thanks ! </code>
21:41
Checksum within UTL_FILE
» ‎ Ask Tom MOST RECENT ARTICLES

Hi Tom I have used your example http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:68212348056 to create flat files from the database using UTL_FILE, however I have modified this slightly as below to amend the output file f...

21:38
Introducing Exadel Fiji
» ‎ TheServerSide.com

Exadel Fiji is an extension to JavaServer Faces to fully encapsulate Flex.
21:11
Skyway Builder release supports Mac and WebLogic
» ‎ TheServerSide.com

Skyway Software announces the release and general availability of Skyway Builder version 6.0.2.

20:02
Oracle Communications Converged Application Server
» ‎ Oracle Software Downloads

Oracle Communications Converged Application Server

19:24
Swag Upgrades at the OTN Lounge, Oracle OpenWorld 2008 Edition
» ‎ OTN TechBlog

This post is strictly about swag - specifically, a new twist on swag that you will enjoy at Oracle OpenWorld, if and only if you visit us at The OTN Lounge.

First of all, let me address the topic of boring plastic conference badges. You've seen one, you've seen them all, right? Not so anymore. Courtesy of OTN, you can now take steps to make that badge representative of the "inner" you. (But don't take this too far!)

Stop by the OTN Lounge to pick up a full sheet of Mikons that you can use to dress up/personalize your show badge. (Thanks to Oracle ACE alum Matt Topper for suggesting this!) So if you want to tell the world that you're a Apex-head, DBA, blogger, WebLogic fan, or whatever, this is your chance! Plus, you'll easily recognize people with the same affinity without the need for minor chit-chat first. It beats putting a sign on your chest!:

Furthermore, those special ones among you who own an Apple iPhone or iPod Touch just may - and I say, may - be able to acquire an OTN-branded Gelaskin if you keep your eyes and ears open (credit to Dan Kildahl!):

What's more, BEA customers can count on receiving a free Welcome Kit (while supplies last). And OTN "alumni" - long-term members who can prove their status by bringing in an OTN membership card (yeah, we actually had one at one point) or other memorabilia - will get yet another gift of appreciation.

As you can see, at OTN, we are working hard to constantly upgrade your swag experience. Remember, the OTN Lounge can be found in Moscone West, Floor 3. Don't be fooled by imitators!

18:13
DataNucleus Access Platform 1.0 (final) released
» ‎ TheServerSide.com

AccessPlatform 1.0 provides Java persistence using JDO/JPA APIs to a range of datastores including RDBMS, db4o, Excel, LDAP, and XML.

17:46
New/Old features
» ‎ Ask Tom MOST RECENT ARTICLES

Hi Tom: What are your favorite features in 11.1? Over the years you have mentioned many tools, like JDeveloper that you thought were great, but today, what do you think the essential tools to analyze problems are? It seems to me that RTFM an...
17:46
import database by pipe
» ‎ Ask Tom MOST RECENT ARTICLES

I use pipe to export whole database in the unix(sol). and want to import to another database. 1. can I use pipe to import the data and how? 2. do I need to re-create the new database. or just truncate all schema(except system and sys)?
17:46
SQLLDR from PL/SQL procedure?
» ‎ Ask Tom MOST RECENT ARTICLES

Tom, Is it possible to run sqlldr from a stored procedure in Oracle 8.1.7.4 Standard Edition on Windoze 2000 Server? Thanks, Sinan
17:46
AUDITING OF USERS ACTIVITIES IN DATABASE
» ‎ Ask Tom MOST RECENT ARTICLES

hi tom i want to audit / track of user's activities in database (like updation,insertion,deletion with date and time ) in oracle. frontend applicatoin is in form 6i. thanks in advance waiting for your prompt response san khan
17:46
"Gapless" sequence using a table of sequence values
» ‎ Ask Tom MOST RECENT ARTICLES

Ti Tom, I especially loved all of your postings and comments regarding the need (or rather not in your opinion) of gapless sequences but unfortunately there is one article you wrote I'm no longer able to find. You explained how to build a gapless se...
17:46
Command to inhibit display of SQL*PLUS results on Windows
» ‎ Ask Tom MOST RECENT ARTICLES

<code>Tom, I know that I can do a "SET TERMOUT OFF" in SQL*PLUS on Unix to inhibit the results of the output going to the display. This doesn't work in Windows, either in the GUI SQL*PLUS [sqlplusw.exe] or the command line SQL*PLUS [sqlplus.exe]. Th...
17:46
PL/SQL and Consitent point
» ‎ Ask Tom MOST RECENT ARTICLES

hi If I were to call a SQL that calls PL/SQL which in turn calls its own SQL, say select FunctA(1) from dual Where FunctA is FunctA (a in number) begin Select xxx from mytable etc End Is there some way to set the consistent ...

15:19
Oracle buys performance specialist ClearApp
» ‎ TheServerSide.com

Oracle Corp. yesterday announced the acquisition of SOA performance specialist ClearApp, which provides model-driven management for composite applications built on J2EE middleware, not the least of which is BEA Weblogic, itself recently purchased by hard-charging Oracle.

← September 3 (9 items) September 5 (9 items) →

Database » September 4, 2008

Feeds

(20 unread)