Author: Steve Karam
Steve Karam, the Oracle Alchemist, is an Oracle Certified Master with over 15 years of DBA and database architecture experience with multiple RDBMS and NoSQL platforms, server and storage systems, and development frameworks.
Rise and Do Honor! Oracle Awards
If you get the chance, check out the Oracle Award-Winners from the November/December edition of Oracle Magazine. You can find them at this link: http://www.oracle.com/technology/oramag/oracle/06-nov/o66eca.html I got the chance to meet a few of these fine people while at OpenWorld, and have spoken to others before and afterward as a
My APEX/AJAX Presentation at OpenWorld 2006
Now that Oracle has officially made the OpenWorld 2006 presentations public, I figured I’d make mine available from my site. You can click the link below to download it in PDF format: Putting the Express Back Into Oracle Application Express with AJAX Enjoy! I am also working on getting the
Do Frequent Commits Fix ORA-01555?
I answered a question on the OTN forum this morning that I figured is pertinent enough to post on my blog…it’s a very common question among DBAs and developers, and I think there are plenty of myths surrounding it as well. Question: I am updating 1 million rows in Oracle
Sorry Internet Explorer Users!
For any readers using IE, you may notice that the page content doesn’t position properly on the page. It looks great on other browsers, but IE has a serious issue when it comes to padding, margins, and really anything pixel related. I’m working on fixing this issue so IE users
Hot Backups, Redo, and Fractured Blocks
I received a question from a reader that I figured I’d address here. Question: The oracle documentation tells us that when we put a tablespace in backup mode, the first DML in the session logs the entire block in the redo log buffer and not just the changed vectors. i
Let’s Get Rolling!
OpenWorld is over, and it’s time to get back to blogging! I’ve got plenty of updates, including Tip #5, my trip to Jamaica, OpenWorld itself (including my presentation), and other various notes. Expect updates over the next couple days.
The Final Tip is Coming Soon
All, Sorry about the cliffhanger on the final tip of my five part series; the Windows installation my DB was on crashed, and I have to recover the OS so I can get the database back up and running. That’s why I just love the Mac. 😉 There will be
Trick #4 – Pull XML with DBMS_XMLGEN
Wouldn’t it be fantastic if you could simply pull data from the database in XML? Many shops use XML for data transfer, web services, reports, and more. Oracle’s XML Publisher product can retrieve XML from an HTTP feed and use it to generate rich reports with graphs, images, and other
Trick #3 – Store Any Data with AnyData
Today’s (well, yesterday’s really) trick deals with the storage of data. Let me first say that the methods I’m about to show you are NOT useful for where clauses or in normal database design. However, they can be very useful when you need a reference table that can store anything