Feed aggregator

Bitmap Index

Wijaya Kusumo - Thu, 2006-01-19 21:42
I often heard people say create a bitmap index when you need an index and when the cardinality of the data is low. How low is considered low is another thing altogether. But one important aspect that people often forget is it only works well in read-only data. If it is a table with lots of insert, update, and delete operation, you end up having to lock many rows at once for each of the DML

Oracle and NetBeans

Omar Tazi - Thu, 2006-01-19 21:00
Following the Sun-Oracle town hall meeting last week at Oracle headquarters where Larry and Scott made a few exciting announcements, I started getting questions about Oracle's position vis-a-vis NetBeans. The reason is that Scott (and later Jonathan Schwartz on his blog) mentioned some kind Oracle "adoption and endorsement" of NetBeans.

Oracle's IDE strategy is very clear, Thomas Kurian's interview on OTN earlier this week doesn't leave much room for interpretation and at the moment Oracle's tools strategy is limited to JDeveloper and Eclipse. Here is the statement from Thomas, Oracle's Senior Vice President for Oracle Fusion Middleware:

"At Oracle, we have our own development tool, Oracle JDeveloper, which is available for free download. Our new version, JDeveloper 10
g Release 3, has an extensive list of new features and is the single biggest release we have ever done of the product…

...Because we are committed to providing developers with choice, we are also taking a leadership role within the Eclipse community. We are currently leading three different groups within the Eclipse Foundation for Java and BPEL technologies, and we are actively involved in integrating our Fusion Middleware products with Eclipse. Oracle is focused on JDeveloper and Eclipse. We certainly think Sun's NetBeans initiative is important in the marketplace, and we're watching it very closely. But as of right now, Oracle is focused on JDeveloper and Eclipse and we have no plans to adopt either NetBeans or any of its technology. Any statements to the contrary by anyone else in the industry are not true."

Is open source software more vulnerable?

Omar Tazi - Tue, 2006-01-17 19:23

Do you think that more eye balls looking at open source projects make all bugs shallow or quite the contrary that some of these eye balls looking at the code could be malicious and take advantage of the exposed code to attack your open source based systems?

Linus Torvalds, the creator of Linux, stated: "given enough eyeballs, all bugs are shallow". More formally: "Given a large enough beta-tester and co-developer base, almost every problem will be characterized quickly and the fix obvious to someone." by Eric S. Raymond in his essay The Cathedral and the Bazaar.

Apparently The U.S. government's Department of Homeland Security thinks otherwise. It is investing in an ambitious 3 year project aiming at improving reliability and security of widely deployed open source projects. In late 2004 the San Francisco based auditing software company Coverity found that the Linux kernel had far fewer security vulnerabilities than a typical commercial software package. According to this article, this same company was selected for this project along with engineers from Stanford and anti-virus vendor Symantec to pinpoint and fix dangerous vulnerabilities (such as buffer overflows and memory allocation bugs) in widely used open source projects such as Linux, Apache, Mozilla and Sendmail.

Can't wait to see the results of this project will confirm Linus' law or not. In my opinion, there is no general rule in this case. Open source is not safer nor is it more vulnerable than commercial software. It really depends on what we are comparing. An open source project is going to be more or less reliable based on its popularity (nobody was interested in attacking Firefox until it became successful) the governance behind it, the size of the community (the more the better)...

Solaris & Tamil

Siva Doe - Mon, 2006-01-16 15:46

Ever since I saw the multi language capabilities of KDE (back in 1997/1998), I wanted to have my desktop at work to be in Tamil, my mother tongue. I then become the Tamil language coordinator and worked to get an Indic language officially release part of KDE 2.0.1. Even though it was easy(ier) in Linux, seeing Tamil on Solaris/sparc had been a challenge always and my passion.
Now with Sun behind GNOME, in my spare time, I try to make Tamil work on Solaris (sparc, in particular). Like, compiling the GTK2-IM modules for Tamil in my workstation or compiling my own version of Firefox with --enable-pango. Without this option, Tamil Unicode websites (like http://ta.wikipedia.org) does not render correctly. My request to enable this by default in Solaris contrib builds has been shot down though.
I can now read and write (With setting GTK_IM_MODULE=tamilvp_uni) in Tamil, in the GNOME desktop as well as in Firefox (like this blog, even though there are some bugs)

தமிழ் படிக்க தெரிந்த அனைவருக்கும் எனது வணக்கங்கள்!!
அனைவருக்கும எனது இனிய பொங்கல் வாழ்த்துக்கள்!!


Blogging at last...

Adam Winer - Fri, 2006-01-06 15:21
It seems about time that I throw my hat into the ring and give blogging a whirl. There should be plenty to say, what with ADF Faces joining MyFaces (though the name's not going to be Cherokee), and anyone who's met me knows I'm never at a loss for opinions.

First post - Daily Links

Siva Doe - Mon, 2006-01-02 16:04

Hello world! (What else)

This is my first post. For filling up this text, I am listing some of the sites that I visit almost daily (after checking Sun mails, of course).

http://www.gnome-look.org (latest fav theme is VistaBut)
http://antwrp.gsfc.nasa.gov/apod (astronomy pic of the day)

Thats all for now, folks.


Torrent available for download... [non-Oracle]

Denis Goddard - Fri, 2005-12-30 16:54
Over the past few months, I've put together a DVD image of video clips relating to the Free State Project:
TV news shows, footage of goings-on in New Hampshire, and so forth.

The DVD image is freely available via BitTorrent.

First, you need a BitTorrent client. I've found Azureus to be the best one by a long mile:

Once you've downloaded and installed Azureus (or if you already have a BitTorrent client), just click on:
If the link above doesn't work or the site is down, you can try:

Included in the download is a README.TXT file with info on how to burn DVDs if you've never done this sort of thing before.

This being BitTorrent, the more people that download, the faster it goes for everyone!

If you run into any trouble, or have any feedback, please post a comment here.
I'll answer questions as best I can, and am always looking for suggestions for the next cut of the DVD.

Share and Enjoy!

... so the Maples formed a union, and demanded equal rights
These Oaks are just too greedy, we will make them give us light!
Now there's no more Oak oppression, for they passed a noble Law
and the Trees are all kept equal
by hatchet,
and saw

Another Oracle Donation to Open Source

Omar Tazi - Wed, 2005-12-21 19:38

This is exciting news web developers who believe in J2EE, so buckle up!

I am pleased to announce that Oracle is contributing a rich set of UI components based on the JavaServer Faces specification to the Apache Software Foundation under the Apache 2.0 license. The donation was originally part of Oracle ADF. What it will be called in the future is yet to be determined by the Apache MyFaces community.

What's in it for Oracle?

We like to get behind technologies we believe in. We think JSF holds great promise and Apache MyFaces is a great JSR-127 implementation. By supporting JSF and MyFaces we are hoping that more vendors are going to join us and strengthen the Faces community.

Why should I care?

I would say wait till you try it. This is going to give a big boost to the JavaServer Faces technology as well as the MyFaces project. The donated code comes with great functionality out of the box. How would you like to have high quality capabilities such as: file upload support, client-side validation, partial rendering of a page (AJAX-style), data tables, hierarchical tables, color/date pickers, progress indicators, menu tabs/buttons, internationalization and accessibility? This donation starts with more than 100 components which have already been thoroughly tested and come with high quality documentation.

How about tools?

Oracle developers are also leading the Eclipse JSF tooling project, we are going to make sure that this plug-in works well with MyFaces and its components to help J2EE developers develop and deploy great looking web applications using open source technology donated by Oracle.

After several months of effort, I'm very excited to see this donation go forward. We know that our donation is being placed in very good hands, and we look forward to seeing more components "blossom" as part of the Apache MyFaces project.

I'm Back!

Omar Tazi - Wed, 2005-12-21 19:29

I would like to apologize to my readers for being so quiet for the last couple of months. I've been too busy and on the road quite a bit. I had a chance to speak at the Gartner Open Source Summit in Florida as well as ApacheCon in San Diego. I hope you like the news in my next blog entry!

Comparing SDO and EJB 3

Mike Keith - Tue, 2005-12-20 23:35

There was a recent announcement made by a consortium of companies about SCA and SDO that can be found here. I have since been getting a few questions about what this means to EJB 3.0 and what the differences between SDO and EJB 3.0 are. There are also some misunderstandings and misinterpretings about what this implies with respect to continued support of the Java EE platform by these companies.

First off, to ensure the message is crystal clear, this does not mean that any of these companies are abandoning or reducing their support for the Java platform. SCA and SDO are complimentary technologies to Java EE, not competitors to them. They are geared towards SOA architectures in general as opposed to Java-specific web services, so in many ways they are generalizations of the model but with concrete API's. EJB components fit well into the SCA component model, and EJB persistence would do well to sit underneath the binding layer of SDO at the Data Access Service (DAS) layer. The companies that are involved in these specifications have all shown their strong support for Java EE and to the best of my knowledge (I can't speak for all of the companies, of course) have no plans to change that level of support.

Here are a few of the notable differences between the specs:

· SDO is the basis for an overall architecture while the EJB 3 Persistence API is simply what its name implies -- a persistence technology. SDO is the basis for an architecture because it does not cover all of the components that would be required for a complete platform. It seems to have been designed more for the upper application architecture layers, like SOA, but leaves all of the specific underlying technologies (except for XML!) unspecified. Services such as Data Access Services are mentioned, but are abstract. Other things such as transactions are not even mentioned. EJB 3, although not at the lowest level as something like JDBC, is definitely lower down on the technology stack.

· SDO is driven by a meta-model and has a very reflection-oriented look and feel. Its API's on DataObjects and DataGraphs offer reflective access of type and property metadata as well as concrete instance data. EJB has no meta-level API's. Entities are concrete and used by applications as simple unadorned Java objects, offering whatever they natively support as part of their domain level API.

· A great deal of effort, and most of the specification, deals with mapping between XML and the data objects. This is in keeping with its SOA focus and its attempts to be interoperable. Mappings to and from the XML may be generated in both directions. EJB does not have make any special considerations for interoperability, except as defined by underlying protocols such as IIOP and CORBA protocols that may be used by the application for communicating the objects.

· Objects in SDO are self-managing because they are always wrapping the actual domain data, even when they are detached. A DataObject or DataGraph is the surface object so wherever the object or object graph goes the operations are getting invoked on those wrapper objects. EJB entities are managed only when they are attached to an EntityManager. Only when operating on managed entities are the objects potentially wrapped. When objects become reattached is when the processing comes back into play to calculate changes and so forth. The difference is that SDO retains the heavier but more controlled objects throughout their entire life cycles, whereas EJB 3 entities are POJO's of the simplest kind if they become unmanaged.

· Object traversal in SDO is done using Xpath queries. This provides the abstraction to navigate through the various wrappers without having to issue all of the unwrapping calls at each level. EJB 3 objects are POJO's and are thus directly traversed using the domain API. The SDO model actually feels a little like the OODB's of old. There is no querying of objects except by traversal, as part of an XPath query or directly from one object to the next. It is unclear what the specified way of causing objects to be loaded on demand during traversal is (whether the DataGraph is supposed to go back to the DAS to get DataObjects that are not loaded).

Disabling CPUs on Linux- Part Two

Stefan Roesch - Sat, 2005-12-17 16:10
If the server is supporting Hyperthreading, Linux implements the following mechanism: First all the physical CPU's are enabled and then then the logical CPU's are enabledThis means that all the possible combinations can be enabled by specifying the maxcpu parameter in the boot command mentioned in the earlier post. For instance if the server has more than one physical CPU it is not possible to stefan roeschhttp://www.blogger.com/profile/15182787826739074738noreply@blogger.com2

Granularity of CPU statistics in V$SERVICE_STATS

Stefan Roesch - Tue, 2005-12-13 23:04
After making several tests it turns out that the "DB CPU" statistics in the view V$SERVICE_STATS only has a granularity of centiseconds despite what the documentation says.stefan roeschhttp://www.blogger.com/profile/15182787826739074738noreply@blogger.com1

Myself, Product of a State-Run School System

Denis Goddard - Tue, 2005-12-13 02:14
Ahhh yes. This is where I was Educated.

On a whim, I googled for my middle school. The school I attended from 1983-1985.
A decade before the Web happened. Of course, they now have a web page with
a "virtual tour." So of course, I poked in to take a look around.

The gem below is a recent creation from that Center of Learning I attended, Aldrich Middle School:

Our assistant Principal [...] is Bilingual. The languages he speaks are English, Spanish, and French.

I just HAD to share that.

Edited Dec 26, 2005 to fix an Element of Style oversight.

Disabling CPUs on Linux - Part One

Stefan Roesch - Fri, 2005-11-18 01:12
For running performance tests and to determine the potential benefit of additional CPUs it can be very helpful to be able to disable CPUs. CPU's can be disabled by adding the following clause to the kernel configuration line in the grub.conf configuration line:maxcpus=The placeholder NUM_CPUS has to be replaced with the number of CPUs that will be enabled. After re-booting with the stefan roeschhttp://www.blogger.com/profile/15182787826739074738noreply@blogger.com1

Disabling Hyper-Threading

Stefan Roesch - Fri, 2005-11-18 00:51
The use of Hyper-Threading for server applications is questionable, especially if the number of I/O requests is high. To determine the cost or the potential performance improvements it makes sense to disable the Hyper-threading (from known on abbreviated with HT) support. The are two ways to disable HT:Disable Hyper-Threading in the kernelDisable Hyper-threading by the BIOSIntel recommends to stefan roeschhttp://www.blogger.com/profile/15182787826739074738noreply@blogger.com0

Upgrade to RedHat AS 4.0

Stefan Roesch - Thu, 2005-11-17 23:39
Upgrading to RedHat 4.0 introduces some new challenges. With the switch to the 2.6 linux kernel the udev device filesystem was introduced. By default the udev device tree does not support raw devices anymore. Luckily it is still supported with the Redhat distribution. It can be configured in the old way with the rawdevices service configuration.To check if it is currently enabled run the stefan roeschhttp://www.blogger.com/profile/15182787826739074738noreply@blogger.com0

A few random recent notes

Denis Goddard - Mon, 2005-11-14 17:39
ADE Stuff
Well, the ADE 3.2.0 rollout happened, and was quite smooth indeed.
Sure, we have made 5 patches since then, and have some serious fixes that need to go in to make a Patch#6,
but by and large most people were not severely impacted.
Given that this was the largest ADE release ever, and indeed is the largest Bing-Bang single change we ever anticipate making, I'll go ahead and call it a smashing success! :)
Jiri did an awesome job sweating the details; Kevin's QA team did an awesome job testing it; Rahul made some awesome tools to manage the rollout; the Support team did an awesome job handling the issues.

Now the IDC folks seem to have a solid grip on the 3.2 branch, and finally, at long last, the HQ team is slogging through PL/SQL APIs for SCM10/ADE4.0
I'll be at HQ for a few seeks starting Nov 29th. I'm looking forward to getting my hands all over the whiteboard, and doing some good detailed design work.

NH/FSP Stuff
So much is happening! My friend Seth ran for School Board, and a bunch of us campaigned for him. He lost, but not by much, and some other FSP folks won their races, so cool.
I'm looking forward to hooking up with the SF Porcs while I'm in California, and hearing their tales of higher taxes and reduced freedoms just in the few months I've been gone.
Sandy (aka "Friday") is also a recent escapee from the People's Republic of California, she has been keeping a blog: http://fridaysblog.blogspot.com/

This weekend I'll be doing some Bill Triage -- enumarating which bills currently before the New Hampshire legislators are pro-liberty, and which are anti-liberty. With that list, we'll be lobbying both the legislature and the voters accordingly.

Now that I live in Concord, I'm looking forward to attending some of the legislative committee meetings. I also hope to testify before some of the committes, as a landowner and taxpayer :)

Gardner Goldsmith is one amazing guy. I absolutely love his radio show Against The Grain, it's quickly becoming an even bigger favorite than Free Talk Live!
Check it out: http://www.libertyconspiracy.com/
Oooh, and check out the Free Talk Live map, it's pretty cool: http://map.freetalklive.com

OK, back to work!

iExpenses wishlist

Jo Davis - Wed, 2005-11-09 18:50
Okay, here is my wishlist for today:
- When the CCID generated by the expense claim line is invalid it should do something useful at the time of entry, not wait for the expense claim to be submitted then notify the system administrator;
- The wording of the notifications should be easier to modify :) I hate workflow some days.

and the big one....

- Employees need to be able to pick the travel advance (prepayment) to apply against their expense claim!!!

And yep, I'm implementing iExpenses again. Off to sunny Melbourne next week to talk to someone about... you guessed it.... iExpenses. Plus off down the road to help another client with yet more iExpenses. The best part - all on different patch levels ;)

A Simple Chapter from the "Cost-Based Oracle Fundamentals" is available for download

Radoslav Rusinov - Wed, 2005-11-02 04:57
A simple chapter from the Jonathan Lewis's book is available for download at this address: Chapter 05: The Clustering FactorThe book will be available for shipping in 5th of November at Amazon online bookstore: Cost-Based Oracle FundamentalsRadoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com2

Happy Halloween

Denis Goddard - Mon, 2005-10-31 05:00
ADE 3.2.0 went live, I closed the purchase of a duplex in Concord New Hampshire, and the Motley Fool says Oracle is a good buy.


A Happy Halloween so far. I may even wear my Star Trek uniform to work.

We'll see how spooky it looks in a few hours, when thousands of HQ developers start pounding on ADE 3.2.0!


Subscribe to Oracle FAQ aggregator