Re: 2 table join taking 3hours - blah blah -roll on ibiza

Maximo interacts with Oracle's Manufacturing Apps, so if I were you I would open a TAR on this view, make sure you get an Oracle Apps support analyst to sign off on its creation/destruction/etc. and be done with it. Just make sure you keep a printed copy of the analyst saying 'ok' in case something dire happens at a later date. It's then a lot simpler to escalate the issue as needed.

Ibiza sounds nice. Enjoy!

Chris Gait

On 27 Jul 2003 at 22:49, rabbit_at_emirates.net.ae wrote:

> I havent got original Subject e-mail as it is on my home PC.
> Firstly let me just say how I like to use this list. As I am completely
> different time zone to you guys i.e. I am Brit living in Middle East,
> also our weekends are thu/fri - by the time I read posted questions
> they are usually well answered. But I do like to follow the list and
> now and again I post a question for a number of reasons. In this
> case I am leaving for a months vacation to Ibiza on Wednesday,
> before that Im doing a database upgrade in test(on 10 schemas-
> each one takes 3-5 hours), a million other jobs and frankly Ive not
> faced a problem such as this for a long time. Now ,is not the time I
> have to investigate fully the problem myself, I have 2 more days and
> Im offsky to party,big style - aint gonna be worrying bout no
> sys.icol$ view.
> Anyhow I also have a work around as I explained by dropping a
> Maximo table (not from SYS schema if you look at original post
> carefully) but I still thought original problem may be interesting to
> some people out there or even another MAXIMO DBA who has had
> a similar experience.(we are a multi schema site- unique in Maximo
> world though). Many posts are unanswered and it was just a chance
> somebody would have a 'heads up' on this. If not no big deal.
> I must remind you that this a MANDATORY installation script
> provided by the vendor as part of the MAXIMO ERP implementation.
> All of a sudden a self proclaimed guru (MUPPET) starts accusing
> me of being a disgrace to DBA's then I get another mail also telling
> me how I should stop implementations of products if they touch SYS
> schema(whats all that IBM about - somebody please come to my
> rescue here). Is the world going mad or do I need this holiday more
> than I thought. (maybe I do)
>
> MAXIMO(MROI) is the leading vendor of MATERIALS
> MANAGEMENT software in the World (Its a USA company mate).
> Sorry BP/SHELL CEO we have to cancel 5 million dollar
> implementation because DBA says you cant create view in SYS
> schema(and its not Data Dictionary just cause its SYS ).Well
> SHELL/BP CEO says tell the DBA TO GO ****** HIMSELF with his
> P45.Grow up please.Have you ever worked on a large ERP
> implementation. Have u ever been on a big job before?
>
> Well I took the abuse and then got accused of being to blase
> talking about SYS objects, and thats why I was rebuked (please-
> was that an apology ?). Well if you dont like the question or its not
> to ure liking the way I structured it well ignore it mate. Your reply
> was totally offensive ,rude,and also ignorant as you fully missed the
> point.
>
> By the way of course I tried wait events , your specialist subject
> must be ' the bleeding obvious'. I was looking for something a little
> more inspirational and imaginative.
> I know some people may find this reply also offensive and Im sorry
> for that, but enough is enough- I didnt realise there was a bizzy on
> the list and the rubuke did it for me.
>
> On a serious note though I am not afraid to ask questions and for
> that matter am not afraid to talk about sex (please feel free off
> line,girls only). Im also not afraid to take criticism, if I missed
> something obvious. Dont we all from time to time. IT people used to
> be fun and have a sense of humour. That includes laughing at
> yourself when you balls up. Next time I will take more care when
> structuring a question.Maybe I did rush it and it wasn't clear and
> was misleading.
>
> Anyhow I want to withdraw the original post, I cant deal with any
> other Numpty telling me woes and pitfalls and evil things that will
> happen to me if I mess with SYS.
>
> Roll on Ibiza -
>
> p.s. It was waiting all the time on TEMP tablespace- probably
> because Hash join. Temp was empty and well sized
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: rabbit_at_emirates.net.ae
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: cjgait_at_earthlink.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).