Feed aggregator

How people find this blog

Stephen Booth - Thu, 2006-11-23 02:38
I was just looking at my stat counter analysis for this blog, it's usually a good way to find out if anyone has linked to me. From the results it looks like the vast majority of people (around 97%) find this blog through a search engine, virtually all (over 99%) through Google. Most common search strings are or include "ORA-07445", "opmnctl failed to start process" and "ORA-01031".Stephen Boothhttps://plus.google.com/107526053475064059763noreply@blogger.com0

10g Release 3 Forms and Report Services?

Vidya Bala - Wed, 2006-11-22 14:11
while helping a colleague of mine install Forms and Reports Services , I realized that 10g Release 3 although available for download , the Forms and Reports Services component is not available for 10g Release 3 yet (only if I missed something). I was wondering if there was any talk on an ETA for Forms and Reports Services on 10g release 3.
Categories: Development

Informatica (PowerCenter) Key Concepts (PartI)

Vidya Bala - Wed, 2006-11-22 13:02
Informatica (PowerCenter) Key Concepts PartI:

This series will review the fundamental of the PowerCenter(7.1.2) Suite.
The key components of Informatica are PowerCenter Client Tools, Repository Server, Power Center Server and the Repository. The Repository Server and the PowerCenter Server constitute the ETL Layer which does the ETL process.

Below is how the client to server communication flow looks like:
The PowerCenter client sends a request to Repository Server.
The Repository Server verifies the connectivity information of the target database
The Repository Server starts a Repository agent Process
The Repository Server uses a Repository agent process to communicate with the Repository.
The PowerCenter Server process communicates with the repository to run scheduled workflows. When a workflow is run manually the Power Center Server uses the instructions configured in the mapping (stored in the Repository) to read , transform and write data.
(details on what a workflow and mapping is discussed below).

Below are the key PowerCenter Client Tools:

a)Repository Manager: To create and manage repository, create and manage users
b)Repository server admin console: To manage the Repository Server
c)Designer Tools:
(i)Source Analyzer: to import source definitions
(ii)Warehouse designer: to import target definitions
(iii)Transformation developer: a repository object that generates/modifies and parses data. This object can be reused .
(iv)Mapping: a mapping is nothing but a set of source and target definitions linked by transformation objects. A mapping is what represents the data flow from source to target.
Mapping Designer is used to create Mappings.
(v)Mapplet designer: A mapplet is a set of objects that you use to build reusable transformation logic.
(vi)Workflow: a workflow is a set of instructions that tells the Power Center Server how to execute a task. Workflow Manager can be used to create and run workflows. Workflow Monitor can used to monitor the running of workflows.(If you are new to the ETL world the above concepts may be overwhelming in the beginning, but as we go through other chapters you will be able to see how the concepts relate to the ETL process)
Categories: Development

Informatica for NewBie Sereis

Vidya Bala - Wed, 2006-11-22 10:59
with all the rush before the holidays for getting things done - I really wanted to start this series before the Holidays. As mentioned in my earlier post , for somebody with ETL experience it gets difficult to evaluate different tools because not many are available out there to download and evaluate. On the same note except for manuals there is not much information on the web for ETL tools in general. I am hoping this series will help a few Niewbie's to Informatica(to jumpstart their work with Informatica) and ETL concepts explained with Informatica (Thanks to Mark Rittman for pointing out a possible site for an evaluation copy - Mark, finding the eval copy and the eval license codes was a treasure hunt on edelivery).

The series will cover the following Topics
Informatica Fundamentals (PartI and Part II)
Informatica Eval Installation
Informatica Admin Tasks
Informatica Designer Tasks
Informatica getting familiar with Workflow Manager and Workflow Monitor
Other Things to remember about Informatica
things to remember in the ETL world(basic concepts)

If you are following this specific series - please drop in comments and let me know if the series helps you get familiar with the fundamentals of Informatica.
Categories: Development

Never volunteer

Stephen Booth - Tue, 2006-11-21 03:29
During his presentation on "Inside RAC" Julian Dyke appeared to suffer laptop difficulties so asked for 4 volunteers to assist in a demonstration. Being the helpful soul (i.e. idiot) that I am, I volunteered. Mr Dyke did seem remarkably wellprepared in terms of props, almost as if he had been expecting his laptop to have problems :-)!Photographic evidence (courtesy of Connor McDonald) can be Stephen Boothhttps://plus.google.com/107526053475064059763noreply@blogger.com1

Histogram problems

Stephen Booth - Sun, 2006-11-19 14:31
A question just appeared on the Oracle-L mailing list about whether there are any issues with using histograms. I've seen a number of presentations over the last couple of years that have warned about issues where you have histograms on highly skewed data and use bind variable (or have cursor_sharing=force, which synthesises bind variable from literals in queries), so I responded:On 19/11/06, A Stephen Boothhttps://plus.google.com/107526053475064059763noreply@blogger.com0

dbms_job, pended and drifting

Dong Jiang - Thu, 2006-11-16 15:26

Suppose we have a job submitted, interval is sysdate + 1 / 24 / 60, but the job is going to take 5 minutes, how will Oracle behave?
Looks like the sequence of events will be the following:
T0, Job #1 starts, the next run time is going to be sysdate(T0) + 1 minute.
T0 + 1 minute, The next job #2 starts, but is blocked by a QS lock, id2 in v$lock will tell the job id.
T0 + 5 minute, Job #1 completes, set sys.job$.next_date=greatest(T0 + 1/24/60, sysdate), effectively changing the this_date for job #2 to be sysdate. Job #2 starts.
Another issue is T0 is loosely guarenteed and could be off by couple of seconds, and even if the job completes within interval, the start time could drift if one uses sysdate only. To avoid drifting, use some calculation based on trunc(sysdate) instead of sysdate.

Null object_id in user_objects

Dong Jiang - Thu, 2006-11-16 13:09

When will Oracle have a null object_id, even if the doc says it’s NOT NULL?

An invalid database link.

An update: Actually, any database link.
It comes from the second branch of the union-all clause of user_objects:
select l.name, NULL, to_number(null), to_number(null),
l.ctime, to_date(null), NULL, ‘VALID’, ‘N’, ‘N’, ‘N’
from sys.link$ l
where l.owner# = userenv(‘SCHEMAID’);


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
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


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


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):

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/*****
scott@ora10g> create sequence test_sq
2 start with 1
3 increment by 1;

Sequence created.

scott@ora10g> select test_sq.nextval from dual;

scott@ora10g> conn sys as sysdba
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
test_usr@ora10g> select scott.test_sq.nextval from dual;


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

Sequence altered.

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


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

Sequence altered.

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



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


Subscribe to Oracle FAQ aggregator