ALL POSTS

Miracle Oracle Open World, The First

If you heard something about Miracle Database Forum, you might already know what to expect. Those of you who have already been there once probably registered already. For the rest of you, keep clicking these links to read reviews of last year’s event in Lalandia, and even take a peek here.

Scheduling Backups in Oracle Grid Control 10g — Mon-Fri

The latest release of Grid Control (10.2.0.3 at the time of this writing) is only able to schedule backup jobs with simple interval based on frequency (every month, week and etc). So if you want to schedule incremental backup from Backup Wizard – you will have to do a trick. First create this job using the wizard and then change its schedule. When you editing the job – more options are available. View the screen shots in this post

IOUG SELECT Journal Article and Future Plans

I’m a bit late with that “news” but I have the second article about Oracle 10g Grid Control Extensibility, published in Q3 2007 issue of IOUG SELECT Journal magazine. Few more words about my future plans.. At the end of September, I’ll be at Slovenian Oracle User Group Conference 2007, After SIOUG 2007, I’m planning to visit Laladia where newly renamed event Miracle Oracle Open World takes place, then off to the Australian Oracle User Group Conference 2007, and finally I’m heading to Birmingham for UKOUG 07. So this is it for 2007. I’m looking forward to see you on one of those events!

I’m off to Dubai for GITEX 2007

A short note to let everyone know that I’ll be heading to Dubai later today to participate in Pythian’s exhibit in the Business Solutions Hall. For those of you who haven’t heard of it, GITEX is like COMDEX for the Middle-East – it’s literally the third largest tradeshow in the world where COMDEX is #1 – and it’s big, really really big, like 120,000 attendees big. Hope to see you there!

Experience Lags Adoption: Why Oracle and SQL DBAs want to learn MySQL

There’s an interesting dynamic going on right now in the DBA world. MySQL’s growth and installed base, as a function of its size three or five years ago, is perhaps five if not ten times larger than it was. In 2002 when Pythian’s MySQL services launched, we took on the platform at the explicit request of an existing customer that was primarily an Oracle shop, but that was adopting MySQL for some bolt-on systems. Today, MySQL is our fastest-growing practice in terms of new customer acquisition. The point I want you to take away from that is simply this: there are about five to ten times more high-value environments running MySQL in the world today than there were three years ago.

Using a Function-Based Index to “Avoid” a Sort

Recently, I was asked to take a look at a query processing part of a client’s application which had started to perform slowly after the application had a maintenance downtime. The idea behind the processing was quite simple.The trick was to add a (redundant) CASE PROCESSED WHEN 0 THEN MOD(SUBS_ID, 7) end expression into ORDER BY clause..In this post I show you how I came to this solution.

Page 215 of 258« First...102030...213214215216217...220230240...Last »