Tag: DBA Lounge

Oracle Exadata V1 Documentation is Published

I was searching oracle.com for some Exadata-related wait events, and noticed some hits popping up from formerly closely-held Exadata documentation. Upon closer look, I found the full Exadata V1 user’s guide. I hope the V2 documentation will be posted soon.

Read More >

Have Your Scheduler Jobs Changed Run Times Since DST ??

Have your scheduler jobs changed run times since the daylight savings time change? The issue hit me this week. On one client the scheduler jobs had changed run time. The strange thing is the scheduled time was 00:05

Read More >

Generating RT bugs out of CPAN Testers’ Reports

A few hours ago, I received a CPAN Testers’s report. The report was a genuine bug (CPANtesters++. Love you guys), and as I made my way to rt.cpan.org to create a ticket to track the issue, I found myself thinking that it’d be nice to have a ‘bug this’ button straight from the smoke report page. You all know where that kind of thinking leads to, right? I didn’t GreaseMonkey’ed a button into the CPAN Testers page (yet), but I did the second-best thing. Namely, a little command-line script that takes a report url and uses it to auto-generate a bug report to the right distribution:

Read More >

System Monitoring on the Cheap with TAP and Smolder

Like any self-respecting geek, I have a small network at home. It’s fairly well-behaved and stable, so I never really felt the burning urge of install a monitoring system. However, as I’ve been bitten by the full partition surprise at 9:30am on a Saturday morning a few times lately, I’ve… come to reconsider that position a little bit. Of course, the right solution would be to install a real monitoring system like, say, Nagios or Zabbix. Trying to reinvent the wheel, and in this case a fairly beefy wheel, would be thoroughly silly. But it’d also be fun and educative. So I decided to do it anyway.

Read More >

Implementing Exadata: The results are in

Following up on my earlier webinar Implementing Oracle Exadata – Strategies for Success, I’ll be giving another webinar to present the results of the Exadata implementation at LinKShare. I’ll be talking about actual performance results, our zero-downtime go-live, compression experiences, and performance tuning in an Exadata environment.

Read More >

Chopt Utility

There is a new tool came with Oracle 11g Rel.2 that helps to modify options in installed oracle home (Enabling and Disabling Database Options) It is very simple and straightforward utility that recompiles database kernel with different flags.

Read More >

Blog-Agnostic Widgets

While there’s a thousand and one different blog engines out there, it’s kinda silly that, for each of them, we re-write almost-identical HTML and Javascript for the different widgets and badges we adorn them with. Wouldn’t be be nice if there was a standard way to write those widgets so that we they could be used and shared across all Perl blog engines? Cue in WWW::Widget, probably the most trivial API ever designed. Written as a Moose Role, it requires from wannabe-widget classes only two things: that they pass all configuration elements at object-creation time, and implement a as_html() method.

Read More >

Oraenv in 11.2.0.2

Oraenv is great utility that helps to control environment and to avoid exact use of ORACLE_… variables in scripts. With invention of ORACLE_BASE it was enhanced to change the variable and to print the value in the output. More interesting that behaviour of oraenv in 11.2.0.2 has been changed
and now it is able to switch oracle base variables but it does not show oracle home path in the output, only oracle base

Read More >

Oracle Net trace in 11G … or build in ITIL

If you ever had tried to switch Oracle net trace than you know that it is quite straight forward to switch it on. You would say that I need to set the following parameters in the sqlnet.ora file…

Read More >

No Silver Bullet – Sharding and MongoDB

ourSquare, the location based social network, suffered from extended outage yesterday. They explained the causes in a blog post, which caused much discussion around the web. Here’s the gist of the analysis: FourSquare are using MongoDB, which is a sharded database. Data is split between nodes based on a shard key, usually the User ID or something similar. One of the shards became overly loaded. After failing to resolve the issue in other ways, FourSquare decided to add another shard to share the load. This caused the entire cluster to fail.

Read More >
Page 26 of 68« First Page...10...2425262728...40...Last Page »