Welcome the the 101st edition of Log Buffer, the weekly review of database blogs.
he Boston MySQL User Group was lucky enough to get Keith Murphy to speak at the June User Group meeting, about backups. here are links to the video and presentation materials, and reference information in this post. Enjoy!
Simple auditing can save you tons of time while troubleshooting. I came up with some simple stored procedure that will compare two data sets and keep track of the changes historically. It’s loosely based on slowly-changing dimension type 2 in the data warehouse world. This method tracks only changes, so you should be able to keep historical rows forever, unless you are constantly dropping and creating whatever you are tracking.
From my previous post on TXK rollup patch, you already know the significance of adctxinf.tmp file in $AD_TOP/admin/template directory. It has wealth of information about different XML tags in the Context XML file of an Apps 11i instance. In relation to the same file, now I want to share with you all a small XSL (XML style sheet) file I wrote back in 2005. It makes adctxinf.tmp much more readable; all tags are presented in a tabular format in the browser.
It turns out that there are a few statements that will update the LAST_DDL_TIME without changing the table structure. An item to note is that a prerequisite to FLASHBACK TABLE is to enable row movement on that table, via (you guessed it) an ALTER TABLE statement. The ALTER TABLE foo ENABLE ROW MOVEMENT statement also bumps LAST_DDL_TIME, but obviously doesn’t block FLASHBACK TABLE from going past it in time.
The bottom of all this is that you can’t use LAST_DDL_TIME to determine just how far back you can go with a FLASHBACK TABLE statement, as you can most likely go past it due to various non-structure-changing DDL statements that affect that timestamp. Here’s a little demonstration to illustrate this point
So, we have all heard that Billy Joel played a concert at Oracle’s OpenWorld in 2007. What follows is an actual IRC conversation among Don Seiler, Dave Edwards, and myself. Comment here with your own database-themed parody of a Billy Joel song. Perhaps if we get enough MySQL-themed entries, we can get him to come to the MySQL Conference in April.
This post is the first of a series of ten posts that will explore some of the Oracle Universal Installer (OUI), Network Assistant (NETCA), Database Creation Assistant (DBCA), Database Upgrade Assistant (DBUA), and many more syntaxes you can use to script or speed up Oracle Installations. Let’s start with covering the Installation of 10.2 And 11.1 Databases.
Log Buffer, the weekly review of database blogs, is 100 editions (and almost two-years) old today! Lewis Cunningham has returned to LB to publish The Big 100th edition of LB on An Expert’s Guide to Oracle Technology.
In the case when the error log writes to a non-default path, FLUSH LOGS actually does not work as specified for the error log. I have not seen issues with binary logs in non-default paths, but we just ran into this issue on a client site and it threw us for a big loop. The bug description is here…
At last night’s event, a lot of the questions were really implicitly asking, “Is open source better? Why?” The first answer everyone comes up with is that it’s free, and that’s better. However, that is neither necessary nor sufficient to deem it “better”. Let me explain….