Many thanks to those who attended my webcast "Secure Your Database in a Single Day" for IOUG's wecast series. I hope you found it useful. I would highly appreciate if you take a moment to let me know how you felt - good, bad and ugly. Please write to me at email@example.com.
You can find the scripts referenced in the webcast here.
According to the documentation the GET_COMPRESSION_RATIO procedure of the DBMS_COMPRESSION package can be used to assess the impact of different compression options for a given table. In other words, it allows us to find out the expected compression ratio for a given set of data without having to really create a compressed table. The question [...]
I’ve previously published a couple of notes (here and here) about the driving_site() hint. The first note pointed out that the hint was deliberately ignored if you write a local CTAS or INSERT that did a remote query. I’ve just found another case where the hint is ignored – this time in a simple SELECT [...]
Not a tree, actually Just dump. Index dump. Custom index dump with blackjack and hookers (c) Check it out here if you haven’t seen this yet. Filed under: Oracle Tagged: indexes, scripts
When is the last time you looked at the listener logs? Perhaps never. Not a very good idea. Listener logs contain a wealth of information on security events - it shows you the profile of hosts connecting to the database, the programs they are using and attempting to communicate but failed, among other things. But reading the listener logs is not exactly a pleasant experience. A while ago I wrote a series of articles on an online eZine called DBAZine.com on how to create an external table to read the listener logs using simple SQL; but unfortunately DBAZine.com has folded.
I have placed the articles on my website for your reference. As always, I would love to hear from you how you felt about these, stories of your own use and everything in between.
For those who attended my seminars in Shanghai, Beijing, Shenzhen, Kualalampur and Singapore - I thank you very much for taking the time. I sincerely appreciate the gesture and hope that you found them useful.
As I mentioned during the seminars, I would love to hear from you your thoughts - what you liked, didn't like, wanted to learn but didn't, or specific areas you applied in your workplace. Please drop me a line at firstname.lastname@example.org.
Is it really that time already? I'll be working in London, but for those of you who can make it, this just in from Thomas Presslie ...
"The annual Scottish Oracle Conference is being held in Glasgow on 27th May 2010. Now with five streams and keynote by David Callaghan, Senior Vice President Oracle, UK, Ireland and Israel a local event in Scotland not to be missed! More information can be found at http://scotland.ukoug.org/ The OUG Scotland Chairman, Thomas Presslie, has some free places to give away to readers of Doug's Oracle Blog. Please email Thomas email@example.com for details of the discount code for registration."
Sorry I'll miss it
In the latest Quiz Night, I asked how you could make a query more efficient by changing a two table join into a three table join – with the clue that my third table was a repeat of the first table. Gary Myers, in comment 4, provided the type of answer I was looking for. Sometimes [...]
I will get back to the stats stuff at some point, but I'm quite busy at the moment working on something that I can't talk too much about, but which is throwing up enough generic issues to talk about. This is one that I meant to blog about ages ago when I first noticed it but when it caused us some problems last week, it was a useful reminder.
In summary you need to be careful when you upgrade to 11g because Resource Manager is enabled by default!
I don't want to blog about the ins and outs of Resource Manager and whether it's a good thing or not, but I do think this is a pretty extreme change to implement without a lot of surrounding publicity. It's a bit like the auto stats gather job that appeared in 10g that caused so many problems for Oracle users. It seems like it might be a good idea, but would you really want to introduce it on to a stable system that you're upgrading to 11g?
But rather than just talk about the change, I wanted to highlight how I first realised it was going on ...
I've been meaning to blog about a couple of interesting events coming up in London during the same week in the very near future - the week after next.
Oracle University are running - Advanced Oracle 10g Performance Analysis and Tuning with Kyle Hailey on 3rd - 4th June. For those of you who aren't aware of Kyle, he was one of the primary movers behind tools like OEMs Top Activity when he worked at Oracle, one of the guys behind ashmasters.com, is a member of the Oak Table Network and has a long history in the Oracle world. You can read more about him at his website.
Meanwhile Miracle Benelux are running two of Tanel Poder's seminars back to back. Advanced Oracle SQL Tuning (1st -3rd June) followed immediately by Oracle Partitioning and Parallel Execution for Performance on 4th June. I imagine most readers are more than familiar with Tanel's work via his blog, presentations and forum contributions and know that he's absolutely top-notch.
They both look like terrific events and I would have attended one of them if it wasn't for the fact that I have a holiday booked in the U.S. that week. Which one? I really don't know because I know they'll both be excellent, so I suggest you read the agendas carefully and pick the one that you think has the most appropriate agenda for your needs.