Feed aggregator

100,000 more?

Robert Vollman - Tue, 2006-11-14 10:48
18 months.107 posts.110,000 reads.Not too long ago I reacted with humble incredulity that 10,000 people had read what I had to say about Oracle.Here I am, exactly one year later, and there have been 100,000 more visits. I'm almost afraid to continue, will I be talking about 1,000,000 in November 2007?I wonder why people are reading my blog because, despite how numerous we are, it seems like Robert Vollmanhttp://www.blogger.com/profile/08275044623767553681noreply@blogger.com3

Some books might make you think wrong

Mihajlo Tekic - Sat, 2006-11-11 10:59
It is amazing how confusable some of the books could be.
You better check any information you think is different than you know.
Currently I am reading a book that is suppose to prepare me for OCP exam.
There are some questions and answers after each Chapter. I found few answers that I think are not correct.
Don’t get me wrong I still think that the book I read is a good one.

One Example: (I changed usernames and sequence name used in the original question):
Question:

The following SQL statement will allow user test_usr which operations on sequence scott.test_sq?
GRANT ALL ON scott.test_sq to test_usr;


A) Select the next value from scott.test_sq
B) Alter sequence scott.test_sq to change the next value
C) Change the number of sequence numbers that will be cached in memory
D) Both A and C
E) All of the above

The answer provided in the book is D.

But, I think it is E. Why?


SQL> conn scott/*****
Connected.
scott@ora10g> create sequence test_sq
2 start with 1
3 increment by 1;

Sequence created.

scott@ora10g> select test_sq.nextval from dual;

NEXTVAL
----------
1
scott@ora10g> conn sys as sysdba
Connected.
sys@ora10g> create user test_usr identified by test_usr
2 default tablespace users
3 temporary tablespace temp;

User created.

sys@ora10g> grant connect, resource to test_usr;

Grant succeeded.

sys@ora10g> grant all on scott.test_sq to test_usr;

Grant succeeded.

sys@ora10g> conn test_usr/test_usr
Connected.
test_usr@ora10g> select scott.test_sq.nextval from dual;

NEXTVAL
----------
2

test_usr@ora10g> alter sequence scott.test_sq
2 increment by 10;

Sequence altered.

test_usr@ora10g> select scott.test_sq.nextval from dual;

NEXTVAL
----------
12

test_usr@ora10g> alter sequence scott.test_sq
2 increment by 1;

Sequence altered.

test_usr@ora10g> conn scott/*****
Connected.
scott@ora10g> select test_sq.nextval from dual;

NEXTVAL
----------
13

scott@ora10g>

Database Tools Talks at UKOUG next week

Donal Daly - Thu, 2006-11-09 14:03
Next week I'll be in Birmingham at the UK Oracle User Group Conference. I am looking forward to it, as it gives me another opportunity to talk about our new tools. This year, I think the database tools team is well represented.

Mike Hichwa, VP of Database Tools (main architect behind Oracle Application Express & my boss!) will be giving a presentation on Thursday morning @ 9am titled - An Insight into SQL Developer and Application Express

Sue Harper, PM for SQL Developer is giving a presentation on Wednesday on SQL Developer: Using Oracle's Graphical Database Development Tool. As you probably know by now, we have released an evaluation copy of SQL Developer 1.1 on OTN, so I am sure Sue will cover all the new cool features in 1.1 and answer any questions you might have.

Alex Keh, a PM whose focus is on our windows technologies is giving a presentation on Tuesday about .NET and Oracle Best Practices: Performance, Deployment and PL/SQL Tips. So if your preferred development environment is .NET be sure to attend his talk. I think we do a lot to make a .NET developers experience productive with Oracle database technology.

For myself, lucky me has 3 presentations!

On Tuesday I will be talking about: End the Microsoft Access Chaos - Your simplified path to Oracle Application Express. I will be demoing our new Oracle APEX Application Migration Workshop. This should also be making an appearance on OTN real soon...

Then on Thursday, I have two presentations: Oracle Application Express: Features, Futures and Customer Tales In this presentation, I give a brief overview of Application Express, What's in 2.2, what's coming in 3.0 and some demos and finally Oracle Migration Workbench: Taking Database migration to the next level where I will demo the new Oracle Migration Workbench integrated into SQL Developer. This should be making an appearance on OTN in 2007.

I am also looking forward to hearing customer feedback at the Oracle Development Tools Roundtable on Wednesday afternoon.

Having had a look at the agenda there are many talks which I want to attend. Looks like it is going to be a good week. Now to put the finishing touches to my presentations...

Firefox search plug-in for Oracle

Dong Jiang - Wed, 2006-11-08 05:47

Talking about firefox search-plugins for Oracle, you can find some here.
I like the Oracle Docs by Eddie Awad and AskTom by Stefan H.


Oracle SQL Developer v1.1 Evaluation Release goodies

Dong Jiang - Wed, 2006-11-08 05:41

Oracle SQL Developer v1.1 Evaluation Release is out. New Feature List here.
Some goodies I like are

  1. NLS preferences, my pet peeve
  2. View CLOB data
  3. Export data to HTML
  4. Search Engines, for OraDoc, AskTom, etc. Could augment firefox search plug-ins
  5. Autotrace

Now it’s time to upgrade and try out.


Ah, LiveHTTPHeaders

Dong Jiang - Tue, 2006-11-07 10:26

Ok, I did not abandon this blog, just I don’t have much to blog about, especially in Oracle, as I am now deep in Cognos territory.
Just noticed this cool firefox extension.
I knew such an extension must exist, but just didn’t find it. It would have been night and day difference for me when I was writing up the Cognos black-box test mentioned here. Unfortunately, I did it the hard way. Don’t laugh, but I just have the following Javascript snippet to print all the HTML elements in the form.

var elements = document.forms[0].elements;
var counter = 0;
for (counter=0; counter < elements.length; counter++) {
  alert(elements[counter].name + '=' + elements[counter].value + '\n');
}

I won't get much work done this weekend....

Donal Daly - Sat, 2006-11-04 16:22
Not a work related post, but...

I was asked by the Porsche club of Ireland (of which I am a member) would I be willing to write a car review for their newsletter as the Irish Porsche dealership offered them a car for the weekend. I could pick what I wanted, so I went for a 997 C4S manual.



In the picture is my son Daragh, and Alan from the Porsche dealership. In Ireland cars have high taxes , so this car costs €160K/$203K.... The car is on my insurance, so I have to be careful :-)

I had promised Julie I would sort out the garden this weekend and deal with all the leaves, sorry not this weekend!


I think I'm in love with UPK

Jo Davis - Fri, 2006-11-03 13:18
Yeah, I know - I've been lax lately - no posts! So on Thursday of course I spent the day at the Red Rock Leadership Forum and one of my collegues gave a demo of the User Productivity Kit which Peoplesoft had (and has now been ported across to Oracle Apps and JD Edwards too). All I can say is - WOW! Everything I dreamed Tutor would do for my life.... but this actually seems to do it :)

Documentation, training and testing - three of my favourite things in the world. And the UPK makes training material (instructor led and online) and gives you those detail level, field-by-field test scripts that everyone seems to be totally keen on printing and storing somewhere (despite my preference for concentrating your efforts on effective scenario-based testing). And more importantly it does it faster than anything else I've seen!

Needless to say, our Peoplesoft guys at work got a pretty good laugh at the Oracle Apps consultants over this one - we're all madly in awe, they've been using the thing for years of course! So the UPK developer is now on my laptop and my adventures in the land of UPK begin today (well technically last night, which is when I started downloading it as the zip file is a massive 405309KB according to my computer - it's still extracting as I type).

So will my love-at-first-sight affair with this software come crashing into an evil wall of reality? Possibly.... I'll let you know

OpenWorld .NET Slides, Source Code, 64-bit ODP.NET and 64-bit .NET Stored Procedures

Christian Shay - Thu, 2006-11-02 23:47
It's been a very busy news week! As promised, here are all of the .NET and Windows OpenWorld slidedecks and sourcecode including the .NET and Oracle Hands on Lab.

Another big piece of news: we just released the beta of the 64-bit ODAC (for both x64 and Itanium). I know many of you have been waiting for this! This includes the 64-bit Oracle Data Provider for .NET as well as support for .NET Stored Procedures with Oracle Database 10g for 64-bit Windows.

Have a look and tell us what you think!

Join us at Microsoft TechEd Europe and UKOUG

Christian Shay - Tue, 2006-10-31 17:00
Oracle is once again a platinum sponsor of Microsoft Tech·Ed Europe (Barcelona, November 7-10) and we will be demoing our latest features integrating with Microsoft Windows and .NET. If you are attending, be sure to drop by the Oracle booth for a demonstration and attend an Oracle session.

Session
Developing and Optimizing .NET Applications for Oracle 10g
Presenter: Alex Keh
Thursday November 9th from 15:45-17:00

Oracle Booth Demos
Oracle Developer Tools for Visual Studio .NET
ODP.NET
.NET Stored Procedures
Oracle Database on Windows
Grid Control for Microsoft Servers
Application Server For Microsoft Servers

UKOUG
Alex will also be presenting at UKOUG (Birmingham, November 14-17) . His talk is on Tuesday November 14th at 11am:
.NET and Oracle Best Practices: Performance, Deployment and PL/SQL Tips

Other Windows related sessions you should check out:
Oracle 10gR2 RAC on Windows Server 2003 x64: Best Practices, Tuning and Administration
Apples and Oranges - Comparative Performance Studies on Linux and Windows

I also happened to notice some cool SQL Developer and Application Express sessions hosted by Oracle engineering staff:
SQL Developer: Using Oracle's Graphical Database Development Tool (Wed Nov 15th, 16:35)
An Insight into SQL Developer and Application Express (Thur Nov 16th 9am)
Oracle Application Express: Features, Futures and Customer Tales (Thurs 10:20)

My next post will include slides and code from Oracle OpenWorld, so stay tuned!!!

Free Webinar: Competing on Analytics

Marcos Campos - Tue, 2006-10-31 06:37
I blogged some time ago (link) about an article on The Harvard Business Review by Babson College's Tom H. Davenport on how analytics are becoming a key competitive factor for companies. I have just learned that Prof. Davenport is giving a free webinar today. The theme is "Competing on Analytics." What participants will learn:What data-driven marketing is (and isn't)How marketing visionaries like Marcoshttp://www.blogger.com/profile/14756167848125664628noreply@blogger.com0
Categories: BI & Warehousing

The biggest Openworld ever closed its doors - and what a great time it was

Clemens Utschig - Tue, 2006-10-31 03:36
Last week was definetely insane! 40.000 customers, 10! locations around San Francisco, and more than 1600 sessions, all dedicated to the power of information sharing.

As most of my team, I litterally spent the whole week at Oracle World, as we constantly went back and forth from the demo grounds, to Oracle Develop, located at the Hilton, and customer meetings.

The first highlight? The SOA Suite distribution (for all number junkies, it's 10.1.3.1.0) made it also in time, to be released to OTN (here) - yeah!

In a nutshell, what did happen?
.. and the who is who of IT came by to contribute a keynote (john chambers, michael dell, and many others), plently of analysts gathered to ask about this and that - and from customers we got overwhelming feedback.

Also a bunch of whitepapers made it in time for Oracle World, perfectly in line with Thomas' Keynote on standards. They can be found here

My sessions on "Integrating Content DB with Oracle BPEL Process Manager", "Advanced BPEL" and "SOA in the real world" - were very well attended, and especially overwhelming was the crowd interested in the advanced stuff on BPEL, covering themes like transactions, compensation, fault handling and BPEL 2.0.

.. and while blogging here from some 34000 feet - somewhere over England en route to Germany, my laptop battery is going down, mostly because of the non working poweplugs on LH 455, whatever .. I'll blog more on OOW when I get the pics that friends took during the week.

Oracle Data Mining in Argentina

Marcos Campos - Mon, 2006-10-30 19:22
I spent the week of the 18th in Buenos Aires spreading the word on Oracle Data Mining. I was invited by Snoop Consulting as a keynote speaker at their Update' 06 (warning, the site is in Spanish) event. Snoop Consulting has a very capable technical team. They are positioning themselves to become a leading company of added-value services for information technologies in the region, focused mainly Marcoshttp://www.blogger.com/profile/14756167848125664628noreply@blogger.com0
Categories: BI & Warehousing

Time Series Revisited

Marcos Campos - Sat, 2006-10-28 17:55
I have been asked a couple of times for a script that would reproduce the results in the time series forecasting series. I finally managed to do it. In the process I found out that a couple of the queries needed to be tuned:In the airline example described in Part 2, the normalization shift and scale parameters were computed using the whole data. A better methodology would be to use only the Marcoshttp://www.blogger.com/profile/14756167848125664628noreply@blogger.com2
Categories: BI & Warehousing

Domain index not used after migrating from 8.1.7.4 to 10.2.0.2

Mihajlo Tekic - Sat, 2006-10-28 11:16
If you have application running on Oracle 8.1.7.4 and you are massively using CONTEXT indexes, you better analyse the queries where context indexes are involved, before you decide to migrate to 10.2.0.x.
This is because execution paths might be way different in 10.2.0.x that may lead to performance degradation.
Here is one example where you should consider query modification in order to avoid bad performances.
Let assume that you have a query that has OR-condition where OR-predicates use CONTEXT operators.

Example:

select a.owner, a.object_name, b.subobject_name, c.object_id
from all_objects_a a, all_objects_b b, all_objects_c c
where
a.object_id=b.object_id
and b.object_id=c.object_id
and
(
CONTAINS(a.text,:a,0)>0
or
CONTAINS(b.text,:b,1)>0
or
CONTAINS(c.text,:c,2)>0
)

This query in 8.1.7.4 most likely will have execution plan similar to this one:

Plan Table
----------------------------------------------------------------
| Operation | Name | Rows | Bytes| Cost |
----------------------------------------------------------------
| SELECT STATEMENT | | 42 | 8K| 93 |
| CONCATENATION | | | | |
| NESTED LOOPS | | 14 | 1K| |
| NESTED LOOPS | | 14 | 2K| 17 |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 2K| 135K| 1 |
| DOMAIN INDEX |ALL_OBJEC | 2K| | |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 2K| 178K| 1 |
| INDEX UNIQUE SCAN |ALL_OBJ_B | 2K| | |
| TABLE ACCESS BY INDEX R|ALL_OBJEC | 14 | 1K| 2 |
| INDEX UNIQUE SCAN |ALL_OBJ_A | | | 2 |
| NESTED LOOPS | | 14 | 1K| |
| NESTED LOOPS | | 14 | 2K| 31 |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 2K| 178K| 1 |
| DOMAIN INDEX |ALL_OBJEC | 2K| | |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 2K| 135K| 1 |
| INDEX UNIQUE SCAN |ALL_OBJ_C | 2K| | |
| TABLE ACCESS BY INDEX R|ALL_OBJEC | 14 | 1K| 2 |
| INDEX UNIQUE SCAN |ALL_OBJ_A | | | 2 |
| NESTED LOOPS | | 14 | 2K| 31 |
| NESTED LOOPS | | 14 | 2K| 17 |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 14 | 1K| 2 |
| DOMAIN INDEX |ALL_OBJEC | | | 2 |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 2K| 178K| 1 |
| INDEX UNIQUE SCAN |ALL_OBJ_B | 2K| | |
| TABLE ACCESS BY INDEX R|ALL_OBJEC | 2K| 135K| 1 |
| INDEX UNIQUE SCAN |ALL_OBJ_C | 2K| | |
----------------------------------------------------------------

where domain indexes are used to support CONTAINS function.
Well, in 10.2.0.2, you better be prepared to have at least twice slower response time, since for this type of query no domain indexes can be used:
The execution plan for my 10.2.0.2 database looks like:

Plan Table
----------------------------------------------------------------
| Operation | Name | Rows | Bytes| Cost |
----------------------------------------------------------------
| SELECT STATEMENT | | 42 | 8K| 1650 |
| HASH JOIN | | 42 | 8K| 1650 |
| TABLE ACCESS FULL |ALL_OBJEC | 51K| 4M| 234 |
| HASH JOIN | | 51K| 6M| 835 |
| TABLE ACCESS FULL |ALL_OBJEC | 51K| 2M| 234 |
| TABLE ACCESS FULL |ALL_OBJEC | 51K| 3M| 234 |
----------------------------------------------------------------

All tables were identical in both databases.

I have opened a SR with Oracle Support on this one, and the answers that I got were very interesting and make sense.
The key reason for such a behaviuor is how Oracle optimizer handles OR-expansion condition where OR-predicates use CONTEXT operators.
Oracle optimizer usually probes OR-expansion to see if a cheaper index based plan can be produced. But, Or-expansion is not legitimate if OR-predicate has a CONTEXT operator, because some of the new "concatenated" query blocks will loose context of this operator.
So, generally, the plan generated in 8.1.7.4 is not legitimate, even though it is very good one, performance wise.
Anyway, if you want to use plan similar to the one you used to have, then you better transform your queries.
I modified the query shown above, to this one:


select * from
(
select a.owner, a.object_name, b.subobject_name, c.object_id
from all_objects_a a, all_objects_b b, all_objects_c c
where
a.object_id=b.object_id
and b.object_id=c.object_id
and
(
CONTAINS(a.text,:a,0)>0
)
)
UNION ALL
(
select a.owner, a.object_name, b.subobject_name, c.object_id
from all_objects_a a, all_objects_b b, all_objects_c c
where
a.object_id=b.object_id
and b.object_id=c.object_id
and
(
CONTAINS(a.text,:a,0)<=0 and CONTAINS(b.text,:b,1)>0
)
)
UNION ALL
(select a.owner, a.object_name, b.subobject_name, c.object_id
from all_objects_a a, all_objects_b b, all_objects_c c
where
a.object_id=b.object_id
and b.object_id=c.object_id
and
(
CONTAINS(a.text,:a,0)<=0 and CONTAINS(b.text,:b,1)<=0 and CONTAINS(c.text,:c,2)>0
)
)


Execution plan has been changed to this one:

Plan Table
----------------------------------------------------------------
| Operation | Name | Rows | Bytes| Cost |
----------------------------------------------------------------
| SELECT STATEMENT | | 42 | 6K| 31 |
| UNION-ALL | | | | |
| NESTED LOOPS | | 14 | 1K| 19 |
| NESTED LOOPS | | 14 | 1K| 19 |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 14 | 1K| 5 |
| DOMAIN INDEX |ALL_OBJEC | | | 2 |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 1 | 21 | 1 |
| INDEX UNIQUE SCAN |ALL_OBJ_B | 1 | | 0 |
| INDEX UNIQUE SCAN |ALL_OBJ_C | 1 | 4 | 0 |
| NESTED LOOPS | | 14 | 2K| 5 |
| HASH JOIN | | 14 | 2K| 5 |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 14 | 1K| 2 |
| DOMAIN INDEX |ALL_OBJEC | | | 2 |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 14 | 994 | 2 |
| DOMAIN INDEX |ALL_OBJEC | | | 2 |
| INDEX UNIQUE SCAN |ALL_OBJ_C | 1 | 4 | 0 |
| HASH JOIN | | 14 | 2K| 7 |
| HASH JOIN | | 14 | 2K| 5 |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 14 | 1K| 2 |
| DOMAIN INDEX |ALL_OBJEC | | | 2 |
| TABLE ACCESS BY INDEX |ALL_OBJEC | 14 | 994 | 2 |
| DOMAIN INDEX |ALL_OBJEC | | | 2 |
| TABLE ACCESS BY INDEX R|ALL_OBJEC | 14 | 756 | 2 |
| DOMAIN INDEX |ALL_OBJEC | | | 2 |
----------------------------------------------------------------

end the response time was much better compared to both previous plans.

Now, the questions are:
How this can be implemented in the application?
How many queries similar to this one are being used in the application?
Is it worth the effort?
Can your application live with the execution paths based on full table scan?

You better answer to these questions before you decide what your next step would be.

On the road again

Mihajlo Tekic - Fri, 2006-10-27 22:51
It’s been a long time since my last post on this blog.
Ok, one of the reasons for this “absenteeism” was my new job.
Honestly, I didn’t have too much time to write anything except reports, research papers, proof of concepts, etc.
Although I commute more than I used to, I don’t mind since I use every chance to read something interesting while riding on CTA trains.
In three months, only in train cars I’ve read three books, two for the first time and one for the second time (just because it is perfect).

1. Oracle High-performance SQL tuning - Don Burleson believe or not, I found it for $9.99 in Borders Outlet Store.

Oracle Replication: Snapshot, Multi-master & Materialized Views Scripts - John Garmany & Robert Freeman

3. Effective Oracle by Design by Tom Kyte I’ve read this book once, and I read it again, just because it is perfect.

Who said that riding in CTA trains is boring? Actually it is sometimes when train cars are so crowded.

Anyways, I am on the road again, hopefully I’ll be more active in the future writing on this blog.

An FAQ for 'Pro EJB 3: Java Persistence API'

Mike Keith - Fri, 2006-10-20 21:12

I use this blog for two things. The first is as an outlet to vent about things that I feel passionate about and that I want to yell out to the world (or at least to the two or three people that are unlucky enough to accidentally stumble across this blog and can?t find the back button). The second is out of laziness. When I have to repeat something numerous times to numerous people it eventually occurs to me that I could just write it down in a public place and point people to it. This entry falls into the latter group.

A lot of people ask Merrick and I about what our book Pro EJB 3: Java Persistence API covers, and whether it would help them in their particular situation. This is kind of a FAQ about the book and answers the most common questions that we get asked.

I have never used EJB. Is this book okay for beginners?

One of our goals was to make this book suitable for people that had no EJB experience at all. We start from the beginning and bring the reader all the way to the intermediate and advanced concepts that they may encounter when developing JPA applications.

What if I don't know EJB 2.0? Will I be able to understand the book?

In general we think people are probably better off starting with no knowledge of previous versions than if they are holding preconceptions based on EJB 2.x. We intentionally left out EJB 2.x from the book because we thought that including it would actually just add confusion to an API that we think is elegantly simple. We did add a few sidebars that differentiate between the old and the new versions, though, just to help those who are accustomed to the old model.

How much of the book is devoted to EJB 3.0 stuff that is not persistence-related?

It is first and foremost a book about the Java Persistence API, and that is what most of the content is about. We did think it worthwhile, though, to cover some of the Java EE 5 enterprise components that access persistence, since that is most likely where JPA will be used. A healthy chapter on session beans, message-driven beans describes some of the basics of the component API. It does not include any of the advanced topics like interceptors, though.

Where do I get the sample code and what do I need to run the examples?

The examples can be downloaded from the Apress web site. To run them the Glassfish application server (the Java EE 5 Reference Implementation), which includes Toplink Essentials (the JPA Reference Implementation) can be downloaded. The Derby database is also included in the Glassfish distribution.

You work for Oracle. Why did you use Glassfish for the application server and not OC4J?

The Java Persistence API is a new standard that provides an abstraction across all persistence vendors. While it is true that we both work for Oracle, we wrote the book to apply to all vendors of the specification. The best way to show this was to use the reference implementations of the standard, i.e. the Glassfish container with the TopLink Essentials persistence provider. In addition, they were also the only fully spec-compliant implementations available at the time, and were very available and the most accessible. Having said that we still believe that OC4J is the best EJB 3.0 container on the market, and fully encourage people to download and use OC4J (which also ships with TopLink Essentials) to try out the examples as well. In fact, the examples were actually initially developed using OC4J because it was available to us internally. If you would like to use OC4J to run the examples it can be downloaded from OTN.

How come you didn't cover topic X or topic Y in the book?

When we were planning the book out we were really trying to come in between 300 and 350 pages. We wanted it to be small enough to be comfortably carried around, fit nicely and easily in a carry-on for reading on a plane, or a bus, and not appear to be a daunting read. As it turned out, despite our best efforts, we ended up going a little over 400 pages (plus some extra appendix stuff). If we didn't cover topic X it wasn't because we were ignoring it or didn't think of it (although I can't disprove the possibility that we didn't think of it) we really just couldn't cram it in.

Why didn't you put more TopLink examples in the book?

The book is about the JPA standard, so we didn't want to include all of the weird and wonderful things that you could do with the TopLink implementation as it might just confuse people with proprietary APIs. We did include a couple of proprietary sections, but it was either covering the topic of spec extensions, or discussing features that we got asked a lot about and the specification did not cover. We also clearly point out where the spec ends and when something we discuss is non-compliant.

Oracle Open World 2006 - and the last preparations - this time JDev team

Clemens Utschig - Fri, 2006-10-20 15:41
Susan, member of our JDeveloper PM team, created a cool viewlet (and I think she will demo this in real during her session).

It's about BPEL and ESB development in Oracle's JDeveloper - you can be found here.

Enjoy - and even more if you come to see us live at this year's Oracle Open World.

Oracle releases SOA Suite 10.1.3.1

Clemens Utschig - Fri, 2006-10-20 12:28
Download it from here - and experience our next generation SOA plattform
Oracle SOA SUITE 10.1.3.1

Oracle on Windows vs. Oracle on Linux

Edward Whalen - Wed, 2006-10-18 12:18
There has been much discussion as to whether Oracle on Windows or Oracle on Linux is a better platform. My opinion has always been that if you are choosing between the two, the platform that better fits into your environment is the better choice. If you are a windows shop and have extensive expertise on Windows and no Linux experience it doesn't make much sense to put a foreign Operating System into your data center. On the other hand, if you are a Unix only shop, and have no in-house Windows expertise, Linux might be a better choice.

In addition, I feel that the way Oracle had developed the Oracle Database Server for Windows using the threading model would turn into an asset once 64-bit Windows is adopted. Remember that 32-bit Oracle on Windows suffers from virtual memory issues that are solved with 64-bit Windows. Thus the liability of using the thread model has turned into an asset (see previous blog).

In order to dispel any rumors or conjecture on whether Windows or Linux works better on the same hardware we recently ran a comparison. This comparison was done using the SwingBench tool. The result of this comparison is provided in a white paper which we have just published on our website. In order to get to this whitepaper follow this link.

Choosing the best OS for your environment involves more than just the performance of the database server. The Oracle Database Server on Windows provides compatibility with Active Directory and your entire integrated environment.

Pages

Subscribe to Oracle FAQ aggregator