Oracloid Blog has moved!

tag:blogger.com,1999:blog-271758562011-04-22T04:21:38.312+02:00Oracloid Blog has moved!The Alex Gorbachev Oracle Blog has moved to http://blog.oracloid.comAlex Gorbachevnoreply@blogger.comBlogger181100tag:blogger.com,1999:blog-27175856.post-1150142974819444792006-06-12T21:45:00.000+02:002006-06-12T22:09:34.833+02:00Blog has moved - please update your feeds

I haven't posted anything for few days as I was actually busy choosing a hosting provider and moving the blog over to my own web site.After several days of disgusting service from blogger.com, looking at Doug's Oracle Blog hacked and reading Tom's Kidnapped Blog I decided to switch from free service to something more flexible and controllable. Some time ago I read that Doug was experimenting

Alex Gorbachevnoreply@blogger.com0tag:blogger.com,1999:blog-27175856.post-1149727720043866172006-06-08T02:46:00.000+02:002006-06-08T02:48:40.053+02:00Don't you hate blogger.com today?

I've been struggling for a while to post anything or comment on any blog on blogger.com today. Redirected to http://www.blogger.com/sorry.html with message:Down for MaintenanceBlogger is temporarily unavailable due to an unexpected problem.We will be back up as soon as possible.Update (2:20 pm PDT): We are fixing a database issue. We hope to be back up in a couple of hours.It's interesting what

Alex Gorbachevnoreply@blogger.com1tag:blogger.com,1999:blog-27175856.post-1149726767993807622006-06-08T02:04:00.000+02:002006-06-08T02:32:48.013+02:00Cloning Oracle Home

Cloning ORACLE_HOME...At the company I work for now, we used to simply copy oracle homes over another machine and/or path, recreate some links and relink. Works very well for 9i including RAC. With 10g and CRS it stopped working - it was a mess registering CRS resources afterwards. Another disadvantage was that Oracle inventory wasn't maintained so it was not possible to easily identify which

Alex Gorbachevnoreply@blogger.com0tag:blogger.com,1999:blog-27175856.post-1149723987489005772006-06-08T01:34:00.000+02:002006-06-08T01:46:27.503+02:00Munich's Lions

Doug Burns posted a long awaited Cow today. This is quite different from what I see here in Munich. :-). .PS: Others on the pix are my son, wife and sister.PPS: To many TARs updated last days - I just realized that I put dots on empty line just like on Metalink to avoid it eating up my empty formatting lines. :)

Alex Gorbachevnoreply@blogger.com4tag:blogger.com,1999:blog-27175856.post-1149428357001197302006-06-04T15:34:00.000+02:002006-06-04T15:39:17.006+02:00Snails

I took these shots couple weeks ago on the way to work. These snails are quite cute.I try to post pics first time directly from Picasa - let's see how it works.

Alex Gorbachevnoreply@blogger.com2tag:blogger.com,1999:blog-27175856.post-1148063041400410972006-05-19T19:10:00.000+02:002006-05-19T20:24:01.416+02:00Flash Recovery Area on ASM?

In yesterday's post, "VLDB with ASM?", I showed problems with ASM mirroring for high volume database. Today, I want to emphasize that you should be very careful placing flash recovery area (FRA) on ASM diskgroup with normal or high redundancy.The reason is the same as before. Whenever all or majority of disks in a failure group are "broken", ASM starts immediately rebalancing. If there is no

Alex Gorbachevnoreply@blogger.com0tag:blogger.com,1999:blog-27175856.post-1147980373796445652006-05-18T20:42:00.000+02:002006-05-18T22:00:32.740+02:00VLDB with ASM?

Today I've been on the first day of the ASM course/workshop led by Martin Gosejacob. He is quite good and knows the stuff. Since I've been playing with it before and installed the practice clusters for it, I kind of knew general content. Nevertheless, I got enough new and interesting pieces of information. Today I will mention my concerns regarding managing large amount of storage with ASM.

Alex Gorbachevnoreply@blogger.com0tag:blogger.com,1999:blog-27175856.post-1147909518578770212006-05-18T01:33:00.000+02:002006-05-18T01:47:44.420+02:00Server-side FAN callouts

Update: This is relevant to RAC environments.Fast Application Notifications mechanism was introduced in 10g as development of TAF (Transparent Application Failover). While the most important benefits are from using FAN on the client side, it's possible to receive notifications on the server and react appropriately. The beauty of it is simplicity.Setting up custom server-side callout is very easy

Alex Gorbachevnoreply@blogger.com0tag:blogger.com,1999:blog-27175856.post-1147903407030794102006-05-17T23:45:00.000+02:002006-05-18T00:18:59.690+02:00v$object_usage empty?

Yesterday, one of my collegues asked why he couldn't see anything in v$object_monitoring view when he enabled monitoring of indexes. I was scratching my head trying to remeber the trick because I recalled that I'd had a similar problem and reason wasn't obvious. I couldn't help him at that time as my memory didn't serve well at this one.Today I've come across Kirti Deshpande's post in Oracle-L

Alex Gorbachevnoreply@blogger.com2tag:blogger.com,1999:blog-27175856.post-1147811040961934102006-05-16T22:14:00.000+02:002006-05-16T22:24:00.970+02:00Meeting Goran Bogdanovic

Today I met Goran Bogdanovic whom I got to know from Oracle-L list. We've had mass of beer at the Hofbraukeller and spent few hours chatting nicely about life, Oracle and whatever came to our mind. Thanks Goran for nice time that let me relax a bit after a tough day.

Alex Gorbachevnoreply@blogger.com2tag:blogger.com,1999:blog-27175856.post-1147681656344841512006-05-15T10:22:00.000+02:002006-05-15T10:28:27.056+02:00Struggle "keeping up"...

A very nice one today - The myth of "keeping up". I see myself in every line of that blog but I need something stronger to change. What that should be? "John isn't keeping up either" doesn't work... it's a John's problem!

Alex Gorbachevnoreply@blogger.com0tag:blogger.com,1999:blog-27175856.post-1147202346615280902006-05-09T22:16:00.000+02:002006-05-09T22:19:16.610+02:00Is do-it-yourself PC upgrade painless these days?

Everything started 10 days ago when PSU (powersupply) of my desktop went belly up. I tested that it was definitely PSU - I checked with the tester that standby +5V was there but shortening contacts 14 and 15 didn't start it (these are the contacts that are used in ATX to turn it on). I didn't have time until last Saturday to go and get a new one. Actually, I thought to go for an upgrade but I

Alex Gorbachevnoreply@blogger.com0tag:blogger.com,1999:blog-27175856.post-1147203369265472552006-05-09T21:33:00.000+02:002006-05-09T21:36:09.276+02:00Oracle supercomputer

...ORACLE was the world's fastest computer in 1953...No comments.

Alex Gorbachevnoreply@blogger.com0tag:blogger.com,1999:blog-27175856.post-1146751396205273032006-05-04T15:18:00.000+02:002006-05-04T18:37:16.430+02:00Using index for IS NULL

Until some time I trully believed that Oracle doesn't store NULL in Oracle b-tree index. Apparently, this is not exactly true, i.e. false. Oracle doesn't store null values in index ONLY and ONLY when ALL columns in the index are null. If any of the index columns has not null value, the key is put in the index. My misconcept was so strong that I actually couldn't belive it until I dumped leaf

Alex Gorbachevnoreply@blogger.com0tag:blogger.com,1999:blog-27175856.post-1146735819986599522006-05-04T11:29:00.000+02:002006-05-04T11:43:39.993+02:00HASH GROUP BY can give wrong result in Oracle 10.2

Hit bug 4604970 in our DW environment. This is really bad one and you might not notice that your query returns wrong result until you get negative number on your payslip end of month.Some one-offs are available and workaround is _GBY_HASH_AGGREGATION_ENABLED=FALSE. Good luck with 10.2!

Alex Gorbachevnoreply@blogger.com0tag:blogger.com,1999:blog-27175856.post-1146696571406657502006-05-04T00:23:00.000+02:002006-05-04T00:49:31.416+02:00Tom Kyte's seminar, Day 2

I got so excited about ORADEBUG feature I described in the previous post that completely forgot to mention the main news of the day - the second day of Tom's seminar. It was an excellent day packed with lot of useful tricks and tips plus I cleaned quite a few things in my mind. The best one that I got straight now - so called "Write Consistency" in Tom's terms.Small but neat 10g R2 feature:SQL>

Alex Gorbachevnoreply@blogger.com0tag:blogger.com,1999:blog-27175856.post-1146694820284996612006-05-03T23:55:00.000+02:002006-05-04T00:51:47.630+02:00Closing trace file with ORADEBUG

Was playing with ORADEBUG today and figured out a cool feature - you can actually close trace file using ORADEBUG CLOSE_TRACE. The only way I knew before was to shrink the file. So now after 10046 trace you don't need to restart the process to close trace file.If your SMON, PMON, etc. Oracle process is dumping like crazy (kind of abnormal but who needs a DBA anyway if SMON is not dumping

Alex Gorbachevnoreply@blogger.com2tag:blogger.com,1999:blog-27175856.post-1146600184757133302006-05-02T21:08:00.000+02:002006-05-02T23:34:49.050+02:00First post about Oracle: no more quoting nightmare in 10g

So here I am with my first blog after a while when everyone seems to have been blogging for at least half of their internet-enabled life. Let's see how it goes.Anyway... Today I've been at the first day of Tom Kyte's 2 days seminar in Munich. I've enjoyed the day very much and I'm looking forward for tomorrow already. There is one thing that caught my attention - Oracle 10g Release 1 introduced a

Alex Gorbachevnoreply@blogger.com0