| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 2 table join taking 3hours - blah blah -roll on ibiza
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 schemaseach
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). Received on Mon Jul 28 2003 - 01:49:23 CDT
 |
 |