Author: Alex Gorbachev

Alex Gorbachev’s RSS Feeds Aggregated

The Pythian blog has grown significantly since then and many more excellent authors started blogging there. While the Pythian blog was mostly focused on Oracle database just a couple years ago, it’s has got very broad coverage now.it might be just too much for some as few people already complained and unsubscribed to avoid being overwhelmed with information.here is a way to subscribe only to a selected category or a single author — just add /feed/ at the end of pretty much any page.

Read More >

ORA-01450 During Online Index Rebuild

We hit an ORA-01450 error today trying to do online rebuild for an index in an unusable state. This was a non-unique index on a fairly large column — VARCHAR2(800 CHAR). It rang a bell. I remembered that I encountered this issue a while ago, but I couldn’t recall the details. I know that it has nothing to do with the actual data size — it’s an error that can occur during index creation.

Read More >

Oracle 11g — Audit Enabled by Default, But What About Purging?

During my presentation at the TOUG meeting, I mentioned that when using 11g’s enhanced security settings or, at least, the audit setting, you risk the unlimited growth of the SYSTEM. Mohamed El-Shafie from Oracle quickly noticed that there is no auto-purge. I promised to have another look at the maintenance tasks in 11g to confirm that, and indeed, the audit trail is not purged automatically when auditing is enabled by default. Here is a quick remedy — scheduling an audit trail maintenance job.

Read More >

How Oracle Follows Good Database Development Standards, NOT

This is what I found in the APEX documentation that comes with Oracle 11g, in the chapter describing building a very simple application…Making sure the database instance couldn’t potentially use an index in DEPARTMENT_ID column? Why on earth would you teach novice APEX developers such a horrible practice? To me, it’s one more confirmation that Oracle can do an excellent RDBMS, but when it comes to database applications development . . .

Read More >

Alex Gorbachev at the TOUG July 2008 Meeting

Small local user group meetings have their own beauty because of the special intimate atmosphere. We expected somewhat higher attendance but it seems that people were already in the holiday mode. The presentation itself went very well and I liked my pace since I didn’t have any time pressure. I’ve done this presentation before in 45 minutes and this time it took slightly more than an hour but I was able to spend additional time on few more complex topics and explain the underlying concepts making sure we all are on the same page. I also enjoyed the questions during the presentation — always a pleasure to know which parts are more interesting to the audience and questions is one of the best indicators. Another one is when people take notes. All in all — it was a very encouraging hour. Thanks to every one who attended!

Read More >

Going to Toronto Oracle User Group Meeting (June 2008)

Today I’m doing a presentation at the Toronto Oracle User Group meeting. It’ll be my first time there and I’m really looking forward to it. My session is called Oracle 11g New Features Out of the Box. It went pretty well at Collaborate 08 and I think it will be the right audience at the TOUG meeting.

Read More >

Oracle Open World: MySQL Management Plug-in and Grid Control Extensibility?

In case you are attending Oracle Open World 2008, the biggest Oracle conference in the world, and interested in either (or both) MySQL or Oracle Enterprise Manager Extensibility — I posted a proposal for a new presentation: Extending Oracle Enterprise Manager by Example — Creating MySQL Management Plug-In

Read More >

Oracle 11g ASM Diskgroup Compatibility

Back in April I was at COLLABORATE 08 and delivered a presentation on 11g — Oracle 11g New Features Out of the Box, including Oracle 11g ASM features. The first ASM slide was about diskgroup compatibility, and I have a bit more to share than I said back then.

Read More >

MySQL plug-in 1.1 for Oracle 10g Grid Control

It’s been a while since the MySQL Management Plug-in 0.42 was released. Since then, I quietly updated it to version 1.0. The changes were very few; the biggest news was that the plug-in was certified by Oracle and added to OTN Oracle 10g Grid Control Extensions Exchange. Version 1.1 turned out to be a major rewrite for the Perl collection scripts and the net result is that compatibility across platforms is greatly improved. I have successfully tested the new version on Linux and Windows Agent hosts. So what’s new in version 1.1 compared to 0.42? Find out here.

Read More >

Oracle Open World 2008 Sessions — Vote on Oracle Mix

I just wanted to make a quick note that Oracle Mix organized an interesting hybrid between call for papers and abstract judging. Anyone registered at Oracle Mix can propose a session abstract to present themselves or as an idea for others. Everyone can give their votes to the proposed sessions. At the end of the voting deadline (25th of June) Oracle will select the top sessions to be included in the Oracle Open World schedule.

Read More >