Feed aggregator

Accent

Denis Goddard - Thu, 2006-11-16 00:22
Well, well, well.... apparently I have a "Boston or New Hampshire" accent.
I am QUITE sure it's a "New Hampshire" accent, thank you very much!

The strange thing is... my 2-year old son already has an almost ridiculous New England accent. He says "heyah" for "here", "cah" for "car", and so forth. The weird thing is, we can't figure out how he picked it up. We almost never watch TV, and when we do it's not local news, so the accent didn't come from there. He has had this accent ever since he started talking, just 1-2 months after we moved to Nashua.

Anyways, I'm from Wisconsin but my dad is from England (with a long spell in Canada) and he has a sort of vaguely British accent, which I assume I inherited slightly.

What American accent do you have?
Your Result: Boston

You definitely have a Boston accent, even if you think you don't. Of course, that doesn't mean you are from the Boston area, you may also be from New Hampshire or Maine.

The West
The Midland
North Central
The Northeast
The Inland North
Philadelphia
The South
What American accent do you have?
Take More Quizzes

UKOUG 2006 - Day 1

Stephen Booth - Tue, 2006-11-14 18:35
Today was the first day of the United Kingdom Oracle User Group 2006 conference. The day itself was pretty good, lots of good talks (more on that later), but I ran into a couple of issues in the evening. The first issue was when I went into the Handmake Hamburger just accross the canal from the ICC, I was alone and the waitress/Maitre d' said they didn't have any free tables suitable for one Stephen Boothhttps://plus.google.com/107526053475064059763noreply@blogger.com0

Which source control system are you using?

Christian Shay - Tue, 2006-11-14 16:38
As part of our planning for our next release of the Oracle Developer Tools for Visual Studio .NET, we'd like to know which source control system(s) your company currently uses.

I'm running an informal poll over at the ODT OTN Forum... please click through that link and let me know which source control system you are using! Thanks!

Sun releases three new open source modules to the Grid Engine project

Siva Doe - Tue, 2006-11-14 14:30

This announcement came from SuperComputing 2006

http://gridengine.sunsource.net/news/SuperComputing2006.html

It will be interesting to see how the Windows as execution node is received.

-Siva

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.

Pages

Subscribe to Oracle FAQ aggregator