Posts by Alex Gorbachev
UKOUG 2006 is over and I was planning to finally provide a bit more details about it. I got a reminder that today is the last day to send IOUG abstracts. Since I planned to submit an abstract there – I rushed in and filled out two proposals based on responses I’ve got from my UKOUG presentations.
Interesting was the Anti-Tuning RAC round-table with conclusion that more or less majority is running RAC because they have way too much money/time/hardware/name it.
I can’t say a lot about presentations I went to as my head was completely empty after my 3 sessions. Last session was on Oracle Streams CDC – I am still not sure what the added value of CDC compare to regular Streams functionality. But the truth is I couldn’t think about anything else but Guinness at that point…
UKOUG 2006- I have three sessions there. These are first three right on Tuesday after the Opening Technical Keynote by Tom Kyte.
While reviewing some material in advance of my presentation at UKOUG Conference 2006, I found an interesting change in RMAN behavior in Oracle 10g. The difference is in the way RMAN handles the case when an incremental level 1 backup is taken without an available level 0 backup. This probably won’t affect anyone much, but I found it interesting. And actually, there are scenarios in which it might cause issues.
Recently we’ve had quite a few migrations to 10g Release 2 and several times been hit by one issue some users consistently get locked with status LOCKED(TIMED). One good example is with the DBSNMP and SYSMAN users, but more important are locked production accounts.
If you are using Oracle Data Pump to backup tables containing LONG or LONG RAW columns, then you might be surprised when trying a recovery. Well, you tested it already. Didn’t you? ;-) Right now I’m in the middle of a production migration. Earlier this week while testing this migration, I noticed couple strange errors during Data Pump import:
While testing a migration, I figured out that schema export using Data Pump doesn’t capture public synonyms on the objects in this schema. Does anyone know how to make Data Pump include public synonyms with schema export? Update: This is actually the same behavior as old Export utility.
A few days ago Kevin Closson (keep an eye on this new blog and expect to find something interesting there) mentioned that Oracle 8.1.7 is one of the most mature releases (at least I understood it this way). I agree with him that many people still use it, but how many? Visit Google Trend and enter “oracle 8i, oracle 9i, oracle 10g” and take in the popularity trends.
This will help when you need to investigate some past changes to your database when auditing was not enabled. This doesn’t imply that you don’t need auditing. On the contrary, I see no reason not to use it in any and every database. However, often we get systems “as is” and we need a working method now and not the next time it happens.