Today I had the classical phone call :
“Hi, what did ,you do yesterday? Because tere are no datas in my report”
- Hu…nothing I swear, you know I do nothing at work.But I’m on it.

Indeed, one job is still pending in the ETL.

A quick look at the monitoring tool show that a query is still running.

ecart
Looks like it shouldn’t. That explains why there is nothing in this table.

A query that was reasonable is suddenly lasting forever. So next step is :
Look for a change of plan. Luckilly I have a tool that stores past plans ans I can compare with the new one.

Yes, AWR is licensed and as long as you don’t want (or can’t afford) to buy the enterprise edition, you need to find another way.
My choice was Ignite8 by Confio. Pretty goos tool.

Then I chose to compare the two explain plans and you can notice that the CBO is now using 2 indexes it was not using before.

 

avec_index

sans_index

They are not new, created a long time ago. So for now I can’t figure out why it suddenly chose to pick it up but it did.

So let’s try to prevent it to use the one with the most operation cost.

I did that by making the index unusable and that did the trick. Back to normal execution time.

So far I don’t know if the index is used by other query so I rebuilt it and took the hint approach to forbi the CBO to use it :

SELECT /*+ NO_INDEX(D IDX_F0911_COPIE_0) */  A.”CD_TIERS”,…

Tere are still things to investigate but the important thing is : users can access their report which was the top priority.

Share

Nicolas Feuillatte - IBM

Ther are numerous documentations on the web on How to enable SSO for COGNOS. Once it is done some of us still want to be able to access the login page for test purposes or for a certain kind of users (executive secretary for example who need to log on as ‘my favorite boss’).

There is a great simple and easy way to do this but with one side effect, at least in my configuration, COGNOS 10.2+W2008+IIS7.5+SSO+ActiveDirectory, which was very annoying in my case : The pages takes 10 seconds to display.

http://www.inergex.com/blogs/business-intelligence/2011/12/16/getting-around-single-sign-cognos

The trick is to remove the UserId and Password in the example below.
My thinking is that COGNOS tries to use it and throw ‘authentication failures’ for a while until it finally stops and serves the Login page. When there are no login nor password filled in, the redirect toward the login page is almost immediate.

http-equiv=”refresh” content=”0; uRL=http://servername/ibmcognos/cgi-bin/cognosisapi.dll?

b_action=xts.run&CAMUsername=UserID&CAMPassword=Password&h_CAM_action=

logonAs&CAMNamespace=YourNamespace&m=portal/cc.xts&m_tab=w”>

To cloud or not to cloud!

http://www.forbes.com/sites/oracle/2012/10/09/larry-ellison-doesnt-get-the-cloud-the-dumbest-idea-of-2013/

OH MY GOD…

20120927-223127.jpg

I didn’t know about Fairsearch, now I do :



Very usefull and interesting.

Should be forwarded to every system administrator before he falls in deduplication traps…or eventually after

http://www.oracle.com/webapps/dialogue/ns/dlgwelcome.jsp?p_ext=Y&p_dlg_id=10070854&src=7011670&Act=164

Because they are well known experts,
because they have a rare talent to popularize, to make things understandable,
and because I learned a lot reading them, here is a short list of people you ought to know,you probably already have heared about or you will be soon :

Kyle HAILEY…Tom KYTE…Cary MILLSAP…Randolf GEIST…Jonathan LEWIS

You might also be interested in Ralph KIMBALL’s books, because if you are a DBA, you likely are or will be involved in some BI projects sooner or later…and as he’s considered as almost one of the father of Business Intelligence…

Un beau témoignage de l’activité Informatique décisionnelle chez Nicolas Feuillatte, ça fait toujours plaisir, surtout quand ça vient d’IBM.

http://www.ibm.com/midmarket/fr/fr/att/pdf/27811_IBM_FICHE_Nicolas_Feuillatte_5.pdf

Un document très intéressant sur le filtrage et l’utilisation d’internet au travail.

Lois, jurisprudences, CNIL…

www.olfeo.com/pdf/filtrage.pdf