Tag: Oracle

A Question from OTN Forum

Here is the question that was posted on OTN Forum Grid Control Extensibility. My first reaction was — how stupid one should be to post such absolutely irrelevant question in that forum? I was even more surprised that someone actually tried to provide a sensible response…

Read More >

The Butterfly Effect

If you check out the “Butterfly Effect” on Wikipedia, you’ll find a rather interesting reference to, “sensitive dependence on initial conditions in chaos theory.” Fascinating use of phrase that probably doesn’t mean much to normal people until it happens to you. I could give you lots of theoretical examples, but perhaps a real-life one will make more sense.

Read More >

Identifying SQL Execution Bottlenecks Scientifically

A few days ago, a developer and I had an interesting conversation. The developer was trying to tune an expensive SQL statement, using a trial-and-error method. After looking at his method in amusement, I showed him how to identify and tune SQL statements scientifically, and decided to blog about it. Let’s look at a simple case and then proceed to slightly more complex versions.

Read More >

DBD::Oracle and Instant Client 11.1.0.6.0

I have just managed to get DBD::Oracle to successfully compile, install, and test with the 11.1.0.6.0 Instant Client (IC) on a Linux (32bit) OS. It seems Oracle, in its wisdom, has changed the folder structure yet again, so to get it to compile, try this….

Read More >

11i Forms Load-Balancing Using JServ

I ran into an 11i E-Business Suite instance which is using Apache/JServ to do forms load-balancing. Here is quick sketch of the instance architecture, a brief overview on how forms load-balancing happens in above architecture, and me more technical details — basically, the XML tags in the Context XML file in APPL_TOP that need to be edited.

Read More >

Alex Gorbachev at COLLABORATE 08

I guess I have only one and a half posts about COLLABORATE 08 this year. It’s a bit unfortunate that I couldn’t make the whole conference, but only last day-and-a-half. In addition, I’ve been speaking at the two lasts slots of the conference so it’s been quite busy for me. I hope this one long blog post will be accepted in place of several smaller ones.

Read More >

DBD::Oracle 1.21 Released

The latest release of DBD::Oracle is now ready and can be found at: CPAN DBD::Oracle. It is a Perl module that works with the DBI module to provide access to Oracle databases. The release has been fully tested with the latest version of DBI (1.601). I also included a list of the changes and/or fixes in this release.

Read More >

Log Buffer #93: A Carnival of the Vanities for DBAs

Welcome to the 93th edition of Log Buffer, the weekly review of database blogs.

Read More >

Enable JServ Logging Without Bouncing Apache

It is quite common for Oracle Tech support, while troubleshooting any 11i E-Business Suite Self Service Applications (SSWA) related error messages, to ask to enable debug logging in JServ configuration files. The procedure we followed here saved us a complete bounce of Apache, but unfortunately, for changes in jserv.conf to take effect, we still need a complete Apache bounce. This trick will only work for files jserv.properties, forms.properties, viewer4i.properties, and xmlsvcs.properties.

Read More >

Arrived at COLLABORATE 08

I’m at Collaborate 08 in Denver right now.My presentation, Oracle 11g New Features Out of the Box, was originally scheduled on Thursday at 9:45 AM but due to participation in the speaker panel ,”To RAC or Not To RAC: What’s Best for HA?”, it was rescheduled to today, Wednesday, at 4:30 PM. I’m off to the Carol Dacko’s presentation about DBMS_XPLAN now and looking forward to show up at the RAC SIG Birds of a Feather later today. Stay tuned – more to come…

Read More >
Page 105 of 141« First Page...10...103104105106107...110...Last Page »