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
Category: Oracle
Oracle is my focus profession and the big kahuna among transactional databases on the market today. This category features in-depth technical posts regarding Oracle, musings, projects, and Oracle related news.
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
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
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
Trick #2 – Rewrite a Query at Runtime
There are many Oracle tools that can wreak havoc on an unsuspecting DBA or developer, but all in all they are for the common good. Though Oracle never puts procedures in place that are made for practical jokes, the DBMS_ADVANCED_REWRITE package comes close. DBMS_ADVANCED_REWRITE allows you to transform queries on
Trick #1 – Copying Users the Right Way
Yesterday I announced that I would be doing a five day series entitled “The 5 Oracle Tricks You Never Knew.” Today’s trick is pretty simple, and it allows you to copy user accounts from one instance to another with the same password, grants, roles, etc, without using the exp/imp tools.
The 5 Oracle Tricks You Never Knew
Hello all! Over the next few days I’ll be updating my blog with 5 Oracle tricks that you may not even know about. They’re all pretty neat, and actually useful to a DBA (one of them is even useful for practical jokes)! These tips will be presented daily in the
Oracle and the World of Open Source
According to this article, it only takes a few words from Oracle CEO Larry Ellison to sink stocks…not Oracle stocks, but Novell. Mr. Ellison gave indications that Oracle will be re-distributing RedHat Linux, the world’s most popular Linux distribution. The idea is a forked RedHat, where the OS is RedHat
Oracle OpenWorld 2006 in San Francisco
It looks like we’re all set for OpenWorld 2006! Burleson Oracle Consulting and Training, has FOUR Oracle gurus invited to OpenWorld as speakers. Don Burleson Oracle Brain Cramps? How simple mistakes can cripple your database Steve Karam Putting the Express Back Into Oracle Application Express with AJAX Mike Ault Welcome