About

Martin Klier

usn-it.de

Oracle DML Parallel Execution Don’ts

Have you ever waited on a parallelized statement? Parallel execution is said to be fast, efficient, system-exhausting. Far from that! There’s a 10.2.0.4 x86_64 system with 16 cores and over 600MB/s write-IO ability, one statement running, one CPU burning, one developer waiting. For days. Finally, at the end of the week, the admin is involved. […]

read more

Nerd compliments.

If anybody ever considers joining irc.freenode.net #oracle (what I’d recommend for all Oracle interested folks), be prepared for being treated like that: <nayyares> it worked !!! <usn> wait some time, it might crash, or restart all cluster services to see if there is a boot bug <nayyares> ok, i am monitoring usn <Rudemeister> Im also […]

read more

Sun ZFS – cool stuff

Basically, I don’t like mirroring google. But this one is really cool stuff, and, by the way, it’s merely linking google. ZFS-Video by Systemhelden Yeah, I really like it! But the video has a weak point: After randomizing the devices this way, you can’t simply pull the plug of one USB hub any more. Anyway, […]

read more

New blood in IT sector (partially German)

Doing chat support in several IRC channels, I’m hardened in several ways. Especially newbie questions are not always easy to handle for all participants. Let me give you an example (in German), how things sometimes are seen by the youngsters. […]

read more

TEMP tablespace too small

Today I got a mail from my grid control: “Tablespace TEMP1 is 97% full”, acting for one of the single instance servers. No problem, you may think, this might happen. It’s an OLAP database, so I wasn’t afraid of big numbers as well. But as you can see, using all this huge temp tablespace for […]

read more

Cleanly removing an agent or host target from Oracle Grid Control 10.2.0.4

Removing a host/agent in Oracle’s Grid Control can be unnerving: There are enough dependencies between the agent, the (cluster-)database, the listener, the host and so to make your deleting action an endless sequence if you are following them. But GC really becomes stubborn if the agent we are about to remove is unavailable: due to […]

read more

Blocking network loopback slows down firefox extremely

My newly installed Firefox web browser (versions 2 and 3, does not matter) was deadly slow. I don’t mean the display of web sites, no, I am talking about pulldown-menus or opening tabs. (For example, bookmarks folder opens within 6 long seconds.) Several hours I was not able to tell why it acts that way. […]

read more

Grid Control startup fails, installUser=%s_userName%

Oracle seems to have an uncommon sense of humor. Executing gcstartup after patching the grid control server to 10.2.0.4 (Linux x86) fails with: /bin/su: user %s_userName% does not exist I am not surprised, since this is windows’ environment variable notation, and unknown to my Linux shells. Solution: In the head of /opt/oracle/grid/oms10g/install/unix/scripts/omsstup replace installUser=%s_userName% with  the username […]

read more

Discovered openstreetmap for me

Hi, http://www.openstreetmap.org is a very cool project. Just discovered it for me, and spent the weekend with tracking and editing my hometown by car. Have a look here to see. I am using SportsTracker for my Nokia E90 and JOSM for the editing at home. Also checked for TrekBuddy on the phone to use a […]

read more