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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: 2 small tables - Query takes 3 hours
This view is part of the upgrade script provided by the Vendor (duh): I've been DBA'ing for 7 years in DB2 and Oracle and messing around with a SYS view is obviously not done- . I was looking for some proper advise as Ive never seen anything like it before. Sam - Original Message - Date: Sunday, July 27, 2003 11:39 am > People should not play with the SYS schema, period. No ifs, no buts, > it just isn't done. You are on your own, pal. If I were your employer, > you would have hit the road by now. Whatever application that Maximo > thing is, creating objects owned by SYS is simply not acceptable. > It's guys like you that give database administrators a bad name. > > > On 2003.07.27 01:29, [EMAIL PROTECTED] wrote: > > Unix Solaris 8 and Oracle 8.1.7.4 > > > > As part of an upgrade to the Maximo application I run a join on 2 > > tables: > > > > select count(*) from sys.syskeys s, maxsysindexes m where > > s.ixname=m.name; > > sys.syskeys is 705 rows and maxsysindexes is 443 rows. > > when I trace the statement I find it doing a hash join and it > estimates> 434 blocks and it does each block in 30 secs. > > > > Prior to running the query I create the sys.syskeys view as detailed > > below: > > The only way I get round the problem is to recreate the > > maxsysindexes table: And of course query then takes 1 second. I > > have disabled hash join and the query just goes down another path > > taking just as long. > > > > Any thoughts as this only happened once the first upgrade in 10 > > schemas, now its happening all the time. > > > > --schema owner > > > > DROP VIEW SYS.SYSKEYS; > > > > CREATE VIEW SYS.SYSKEYS > > (IXCREATOR, IXNAME, COLNAME, COLNO, COLSEQ, > > ORDERING, FUNCTION) > > AS > > SELECT IO.NAME, IDX.NAME, C.NAME, C.COL#, IC.POS#, 'A', '' > > FROM SYS.COL$ C, SYS.OBJ$ IDX, > > SYS.OBJ$ BASE, SYS.ICOL$ IC, > > SYS.USER$ IO, SYS.USER$ BO > > WHERE IO.NAME = 'ADWEA' AND BASE.OBJ# = C.OBJ# > > AND IC.COL# = C.COL# > > AND IC.BO# = BASE.OBJ# > > AND IO.USER# = IDX.OWNER# > > AND BO.USER# = BASE.OWNER# > > AND IC.OBJ# = IDX.OBJ# > > AND (IDX.OWNER# = UID OR > >BASE.OWNER# = UID > >OR > >BASE.OBJ# IN ( SELECT OBJ# > > from sys.objauth$ > > where grantee# in ( select kzsrorol > > from x$kzsro > >) > >) > >) > > ; > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
2 small tables - Query takes 3 hours
Unix Solaris 8 and Oracle 8.1.7.4 As part of an upgrade to the Maximo application I run a join on 2 tables: select count(*) from sys.syskeys s, maxsysindexes m where s.ixname=m.name; sys.syskeys is 705 rows and maxsysindexes is 443 rows. when I trace the statement I find it doing a hash join and it estimates 434 blocks and it does each block in 30 secs. Prior to running the query I create the sys.syskeys view as detailed below: The only way I get round the problem is to recreate the maxsysindexes table: And of course query then takes 1 second. I have disabled hash join and the query just goes down another path taking just as long. Any thoughts as this only happened once the first upgrade in 10 schemas, now its happening all the time. --schema owner DROP VIEW SYS.SYSKEYS; CREATE VIEW SYS.SYSKEYS (IXCREATOR, IXNAME, COLNAME, COLNO, COLSEQ, ORDERING, FUNCTION) AS SELECT IO.NAME, IDX.NAME, C.NAME, C.COL#, IC.POS#, 'A', '' FROM SYS.COL$ C, SYS.OBJ$ IDX, SYS.OBJ$ BASE, SYS.ICOL$ IC, SYS.USER$ IO, SYS.USER$ BO WHERE IO.NAME = 'ADWEA' AND BASE.OBJ# = C.OBJ# AND IC.COL# = C.COL# AND IC.BO# = BASE.OBJ# AND IO.USER# = IDX.OWNER# AND BO.USER# = BASE.OWNER# AND IC.OBJ# = IDX.OBJ# AND (IDX.OWNER# = UID OR BASE.OWNER# = UID OR BASE.OBJ# IN ( SELECT OBJ# from sys.objauth$ where grantee# in ( select kzsrorol from x$kzsro ) ) ) ; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
FEEDBACK: SMON taking 50% of CPU and certain queries hanging
It seems that the new version of Workflow that we implemented had a massive query running in the background, compound that with we run 9 companies (multi schema) in one database, that was 9 massive queries running in the background. The thing that I didnt notice it at first was that because SMON had all the CPU these processes showed very little CPU usage.Yet the following morning they had increased their CPU usage to about 5% each and SMON was normal. I easily identified the problem then , killed the queries, bollocked the vendor, and all is normal again. Anyhow thanks to the guys who contributed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: RE: SMON taking 50% of CPU and certain queries hanging
By the way it was an Application upgrade not O/S or database - I should have been more clear. - Original Message - Date: Monday, June 23, 2003 10:29 pm > Sam, > > Can you check if PQ is enabled (via PARALLEL_* ) and you have > PDML/PQ in use > because of DB objects or queries? If so, the you might be > overwhelming the > number of CPUs in the system via too many PQs/PQ servers. If the > key word is > 'upgraded a test server' as in an OS upgrade on AIX, then you > should check > if you have lost previous values of AIO (configured via SMIT AIO). > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > Grace - Getting something we don't deserve; Mercy - NOT getting > something we > deserve > Click on 'http://www.needhim.org' for Grace and Mercy that is freely > available! > > ** The opinions and statements above are entirely my own and not > those of my > employer or clients ** > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Monday, June 23, 2003 4:49 AM > > To: Multiple recipients of list ORACLE-L > > Subject: SMON taking 50% of CPU and certain queries hanging > > > > > > I recently upgraded a test server and found out today that it > was > > hanging. SQLPLUS etc... > > I checked alert log and found following errors > > WARNING: aiowait timed out 1 times > > WARNING: aiowait timed out 2 times > > > > I shutdown and restarted and since then Ive noticed that only > > certain queries hang and the SMON process is running at 50% CPU. > > > > This Test service has been running for ages, allthough I did do > an > > upgrade to the Application a week ago. > > > > Its the end of day so I will leave it running and see if SMON > > finishes. > > Ive checked space etc..checked metalink briefly but if any of > you > > can give me some suggestions I will try them. > > > > thanks > > > > Sam > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: John Kanagaraj > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: RE: SMON taking 50% of CPU and certain queries hanging
Sorry guys I was rushing as I was leaving. The OS is Solaris 8 and Database Oracle 8.1.7.4 I came in this morning and everything is okay now: But I will now try and find what happened and if it starts again I will inform - thanks for replies and any more ideas please dont hesitate thanks Sam - Original Message - Date: Monday, June 23, 2003 10:29 pm > Sam, > > Can you check if PQ is enabled (via PARALLEL_* ) and you have > PDML/PQ in use > because of DB objects or queries? If so, the you might be > overwhelming the > number of CPUs in the system via too many PQs/PQ servers. If the > key word is > 'upgraded a test server' as in an OS upgrade on AIX, then you > should check > if you have lost previous values of AIO (configured via SMIT AIO). > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > Grace - Getting something we don't deserve; Mercy - NOT getting > something we > deserve > Click on 'http://www.needhim.org' for Grace and Mercy that is freely > available! > > ** The opinions and statements above are entirely my own and not > those of my > employer or clients ** > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Monday, June 23, 2003 4:49 AM > > To: Multiple recipients of list ORACLE-L > > Subject: SMON taking 50% of CPU and certain queries hanging > > > > > > I recently upgraded a test server and found out today that it > was > > hanging. SQLPLUS etc... > > I checked alert log and found following errors > > WARNING: aiowait timed out 1 times > > WARNING: aiowait timed out 2 times > > > > I shutdown and restarted and since then Ive noticed that only > > certain queries hang and the SMON process is running at 50% CPU. > > > > This Test service has been running for ages, allthough I did do > an > > upgrade to the Application a week ago. > > > > Its the end of day so I will leave it running and see if SMON > > finishes. > > Ive checked space etc..checked metalink briefly but if any of > you > > can give me some suggestions I will try them. > > > > thanks > > > > Sam > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: John Kanagaraj > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
SMON taking 50% of CPU and certain queries hanging
I recently upgraded a test server and found out today that it was hanging. SQLPLUS etc... I checked alert log and found following errors WARNING: aiowait timed out 1 times WARNING: aiowait timed out 2 times I shutdown and restarted and since then Ive noticed that only certain queries hang and the SMON process is running at 50% CPU. This Test service has been running for ages, allthough I did do an upgrade to the Application a week ago. Its the end of day so I will leave it running and see if SMON finishes. Ive checked space etc..checked metalink briefly but if any of you can give me some suggestions I will try them. thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
TERM LICENSES - ANY Experience
We are concerned on licensing especially as we are setting up a Disaster Recovery Site. During our Investigation it seems that TERM licensing can come out cheaper. Anyone have any idea on this or any disadvantages of leasing the software as opposed to owning it, thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
V$SESSION Details Changed after upgrade Database to 8.1.7.4
I have just upgraded my database at the Weekend and I have noticed that PROGRAM field in V$SESSION no longer displays the program all the time i.e. SQLPLUS and Microsoft Access in particular. I use this fields in capturing illegal log ons etc.. Anybody have an idea before I try Support. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Upgrading Database to 8.1.74 - RMAN still 8.1.6
As I suspected, now I have to break the news , without breaking the person thanks jared - Original Message - Date: Tuesday, February 18, 2003 8:43 am > You can't register and 8.1.7 database in an 8.1.6 catalog. > > Jared > > > > > > > [EMAIL PROTECTED] > Sent by: [EMAIL PROTECTED] > 02/17/2003 08:13 PM > Please respond to ORACLE-L > > >To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]>cc: >Subject:Re: Upgrading Database to 8.1.74 - RMAN > still 8.1.6 > > > We are upgrading to 8.1.7.4. There are many databases and my > DBA college who is in charge of the RMAN Database that is > currently 8.1.6. tells me that it is no problem that RMAN > (Seperate > database by the way) is in 8.1.6 and the Target is in 8.1.7.4. > As RMAN is hot topic right now and before I go RTFM can anybody > verify this or advise > > thanks > > Sam > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Upgrading Database to 8.1.74 - RMAN still 8.1.6
We are upgrading to 8.1.7.4. There are many databases and my DBA college who is in charge of the RMAN Database that is currently 8.1.6. tells me that it is no problem that RMAN (Seperate database by the way) is in 8.1.6 and the Target is in 8.1.7.4. As RMAN is hot topic right now and before I go RTFM can anybody verify this or advise thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: access/oracle
We had same problems at 2 sites here. I dont allow access in Production, I can usually scare management enough to keep them out and I apply a LOGON trigger to stop any connection from access (and SQLPLUS etc for that matter, unless its a user that I allow). I do create a copy of PROD every day to TEST and they can do what they like on this database. - Original Message - Date: Monday, February 3, 2003 4:38 > Bill, > I have to live with people who want to usc Access too. I agree > wfth you it is a > pain in the a--. Our solution, with damagement's agreement, is to > only do what > is possible. I think that in your situation you'll have to do > likewise. The > problem being Access's local tables. What may help is if they > link the tables & > apply the appropriate limits on each. > > Dick Goulet > [EMAIL PROTECTED] wrote on 1/31/03 2:24 pm: > > > Hello, > > We are stuck with a group of users who insist on using MS access > 2K 9.0 on a > Win2K workstation as an adhoc query front end to an Oracle 8.1.7.4 > db on Sun. > > The problem is that their queries run OK when executed from > sqlplus directly > against Oracle, but are terrible when executed from access. This > is because > access has tables linked to the oracle tables, and access insists > on downloading > all the data, performing the joins and where clause filters on the > localworkstation. > > I don't know much about access, and don't want to; however, this > has been dumped > on us, so I am hoping that someone has experienced the same > problem and found a > solution. No, we can't dump access, and use something different; > for reasons > beyond our control (management), we have to make this work. > > I think the solution is to somehow force the query to be processed > on the Oracle > machine, and return only the result set. We have tried the access > "passthrough"option, but I believe that fails due to the newer > ansi syntax used by access. > (OUTER JOIN, INNER JOIN, etc.) The users insist on using access's > gui query > generator. > > Has anyone found a solution to this? Is there a good whitepaper > somewhere like, > "Using Access as a Front-End Query Tool to Oracle?" (I will search > google) > Thanks to all who have read this far, > More thanks to any responders, > Most thanks for any helpful advice > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > 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: > [EMAIL PROTECTED](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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Upgrade 8.1.6 - 8.1.7 Patch 4
Im doing an upgrade from 8.1.6. to 8.1.7.4. Is there any benfit of doing the upgrade from 8.1.6 to 8.1.7, using ODMA then patching to 8.1.7.4 or installing 8.1.7, patch it to 8.1.7.4, then ODMA the database from 8.1.6. any other comments on this upgrade path are welcomed thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Hints being ignored
I'm on 8.1.6 and the other day I was trying to use a hint on the GL_INTERFACE table from Oracle Financials (i know OF is rule based)that I had copied to another database instance and I couldnt get a hint to work. And i know that Hint is not SQL supported and therefore the syntax has to be 100% correct. I was busy so I jut deleted records I didnt need but I will go back and try again later. On the whole though using 8.1.6 Ive remember situations where hints have not taken. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: RMAN Guru Needed - RMAN/Netbackup
Thanks for reply: I tried to restore the archivelogs on their own and it still asks for a backup piece thats on a tape that has been scratched. I looked at rc_backup_redolog and see lots of entries for the particular archive log.The last entry (in date order) points to a backup_set that is on the scratched tape. The second last entry points to a backup set that is on the tape that we have in the library. Im guessing that RMAN looks at the last entry and figures that this job backed it up and deleted it and therefore it is this tape. What I want to know is how I can get the archivelogs to be restored from the previous tape. Im probably going to raise a tar now. I can see in the logs that our bi weekly backup and delete all archivelogs ran on the 11/jan/2001 - yet these particular archive logs were backed up again the day after. Very strange behaviour yet could explain why RMAN is pointing to wrong tape. I always suspected RMAN was to easy to not be problematic Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: RMAN Guru Needed - RMAN/Netbackup
I am trying to alternate host to a point in time of 01-01-2002. I restore current controlfile then run run { set until time "to_date('01-JAN-2002 03:00:01','DD-MON- HH24:MI:SS')"; allocate channel ch1 type 'sbt_tape';restore database; recover database; } The netbackup log asks for a cold backup tape from 29-dec-01, restores that data (if i resetlogs its is fine), then proceeds to ask for a group of archivelogs and fails with failed to retrieve handle "al_6548_1_450965598' Backup file not found. When I look in the logs it is not asking for a tape like it did with the first part(cold backup) and when i look at rc_backup_piece this handle is pointing to a media that has been reused. But we did a 2 weekly redo log backup on the 12-jab-02 and clear which went to another tape that is still available. When i crosscheck rc_backup_redolog I see that there are various tapes for that sequence#(which i presume is the log file number), but how do we get rman to look at the other tape ? and why does it not ask for any tape in the logs when it wants the archivelogs ? This whole process is very confusing and piss*** me off no end. There's a pint for anyome who can help me here. I'd be interested to know also how internally rman manages which tapes to use for restore. In theory the same arcgive logs are on many different tapes, so how does it decide which one to use ? Im RTFM'ing as well thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RMAN -Alternate Host next problem
Recall our Netbackup server holds only 2 months tapes and Im trying to recover on an alternate host to the beginning of the year. I issue following : run { allocate channel ch1 type 'sbt_tape'; restore controlfile; alter database mount; } then once the current control files are back I issue run { set until time "to_date('01-JAN-2002 03:00:01','DD-MON- HH24:MI:SS')"; allocate channel ch1 type 'sbt_tape';restore database; recover database; } The logs (thanks for location guys) ask for tape DC3787 which was has a date last written 12/29/2001 22:29 netbackupsrv which I presume is the last cold backup taken by rman, it then restores okay to that point. RMAN-08023: channel ch1: restored backup piece 1 RMAN-08511: piece handle=bk_5942_1_449790981 tag=COLD_DB_BK_LEVEL0 params=NULL RMAN-08024: channel ch1: restore complete rman then seems to ask for correct archivelogs RMAN-03022: compiling command: recover RMAN-03022: compiling command: recover(1) RMAN-03023: executing command: partial resync RMAN-03022: compiling command: recover(2) RMAN-03022: compiling command: recover(3) RMAN-03023: executing command: recover(3) RMAN-08054: starting media recovery RMAN-03022: compiling command: recover(4) RMAN-03023: executing command: recover(4) RMAN-08017: channel ch1: starting archivelog restore to default destination RMAN-08022: channel ch1: restoring archivelog RMAN-08510: archivelog thread=1 sequence=17138 RMAN-08022: channel ch1: restoring archivelog then i get errors 0ra-19511 backup up file not found. So I can see RMAN seems to know the archivelog files it needs, yet they are not on that tape,and the Netbackup log doesnt ask for the next tape. Can I manually recover these archivelogs or am I doing something wrong? I will be researching myself but if any of you guys can help it will be great. Plus my weekend starts today. thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RMAN NETBACKUP recovering from say 6 MONTHS ago
I want to alternate host my database to 6 months ago: The media manager only keeps 2 months of data online and when i recover until etc.. the job hangs and then finally gives up, obviously as the tape is not inside: My question is how does Netbackup know which tape to load, or how do I know which tape to put in the media manager or which range of tapes: Anybody an help with this Thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Any Equivalent of SAR command in NT/2000
I run sar 10 3600 >> /var/sun/cpuusage.log to monitor the performance between peak hours ,,, I have 16 Windows 2000 APPLICATION servers running citrix and some seem to be giving poorer performance than others: If I can monitor CPU and Memory and pipe it to a batch file, as I do in UNIX, it will be a great help: Can this be done ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Do you use RMAN? DB clone problem
I use this technique only as a failover routine, if the production machine were to crash: Cloning I would use standards methods as it is much faster: But once u restored the database you can rename it. But the steps that I take are 1.Install executables on other machine as same owner and group id as original database(this is very important)(RESTORE using Netbackup rather than re-install) 2.Update bp.conf in oracle home and /usr/openv/netbackup/ 3. set nb_ora_client=Original client 4.startup taget database nomount 5.connect rman catalog 6.Run scripts Sam p.s. scripts I use are run { allocate channel ch1 type 'sbt_tape'; restore controlfile; alter database mount; } --select min(scn) from (select max(next_change#)scn from v$archived_log group by thread#); -- get the last scn in svrmgrl run { set until scn=100075926; allocate channel ch1 type 'sbt_tape';restore database;recover database; } --back in svrmgrl alter database open resetlogs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). <>
Re: Do you use RMAN? DB clone problem
I use this technique only as a failover routine, if the production machine were to crash: Cloning I would use standards methods as it is much faster: But once u restored the database you can rename it. But the steps that I take are 1.Install executables on other machine as same owner and group id as original database(this is very important)(RESTORE using Netbackup rather than re-install) 2.Update bp.conf in oracle home and /usr/openv/netbackup/ 3. set nb_ora_client=Original client 4.startup taget database nomount 5.connect rman catalog 6.Run scripts Sam p.s. scripts I use are run { allocate channel ch1 type 'sbt_tape'; restore controlfile; alter database mount; } --select min(scn) from (select max(next_change#)scn from v$archived_log group by thread#); -- get the last scn in svrmgrl run { set until scn=100075926; allocate channel ch1 type 'sbt_tape';restore database;recover database; } --back in svrmgrl alter database open resetlogs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: # of datafiles per tablespace
Fair Point, but isn't Async I/O limited to Raw Devices only: If not using raw, many companies don't, you can still face contention issues. Also enabling more dbwr processes gives the overhead of more background processes: I feel that multiple files per tablespace is a workable compromise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: # of datafiles per tablespace
In a UNIX system it is better to have more small size datafiles than a few or one large datafile: The reason is that UNIX aquires an exclusive file write lock and therefore if you use multiple files you will avoid a situation where multiple simultaneous writes to data files become serialized and consequently reduce I/O performance: For example instead of one 2GB Data file , split it into 8 250mb: By the way I am addressing OLTP type systems with this e-mail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Re: OUTLN
we are all touchy after the RTFM episode: I was actually refering to the fact that I received the same question 5 times - it was a joke !: Regarding the RTFM, I publicly apologize for jumping in when I did not know the facts. I had not been reading all posts: Incidentally I sent out 'off line' PL/SQL code to e-mail from a stored procedure to various listers: Most people who received it spent the time to e-mail back and say thanks for giving it to them: A certain person who I am not naming didn't bother - I wish I hadnt: So sorry kev et al, lets stay on the technical stuff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: slightly OT: Debugging package
Compile it in SQLPLUS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: PL/SQL
Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Overhead of over sized datafiles
A fellow DBA working with me resized the System tablespace to double its size i.e. from 500MB to 1GB: I dont like the practise of just arbitrarily doubling a datafile size and it sitting empty for years, but apart from extra backup time , would this large oversized datafile upset the database engine in any way, or be inefficient at a database or o/s level: I suspect certain areas but to busy right now RTFM. p.s. 8.1.6 / solaris 2.8 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How to stop access to prod instance ...
Hi Tom Raise an error : Here is an example CREATE OR REPLACE TRIGGER SAMLOG after LOGON ON DATABASE DECLARE v_error EXCEPTION; PRAGMA EXCEPTION_INIT( v_error, -1031 ); T_SESSIONID VARCHAR2(30); T_USERNAME VARCHAR2(20); T_OSUSERVARCHAR2(20); T_PROGRAM VARCHAR2(48); BEGIN SELECT user into t_username from dual; If t_username!='SYS' THEN SELECT USERENV('SESSIONID') INTO T_SESSIONID FROM DUAL; SELECT PROGRAM,USERNAME,OSUSER INTO T_PROGRAM,T_USERNAME,T_OSUSER FROM V$SESSION WHERE AUDSID=T_SESSIONID; IF T_PROGRAM IN ('MSACCESS.EXE','sqlnav3.exe','SQLNAV3.EXE','SQLTALK.EXE') THEN INSERT INTO maximo.DBATRACK(LOGINPROG,LOGINUSERname,loginosuser,LOGINDATE) VALUES (T_PROGRAM ,T_USERNAME,T_OSUSER,sysdate); COMMIT; END IF; IF T_PROGRAM in ('MSACCESS.EXE','sqlnav3.exe','SQLNAV3.EXE','SQLTALK.EXE') AND T_USERNAME NOT IN ('ASANDERS','MAHA','AMMAR','ADNAN','JAFAR','FAYEZ','VELJKO','HSSAMERI', 'MAXIMO','DJSLITER' ) THEN RAISE v_error; END IF; END IF; This can be broken,and I can reveal later, but it will get rid off most of your problems -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How to stop access to prod instance ...
You can create a LOGON Trigger to stop users using anything i.e. SQLPLUS ,MSACCESS etc... I have applied one at our site and works good. I even log people who try to log in and get them to explain to management their motives. That is a good deterrent. The trigger can be written so that only selective users can have access if need be. Sam P.Roberts (M.Sc) Senior DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Backup strategy using RMAN
Thanks to respondee's: The problem was a host name in etc/system on the netbackup server: I'm sure the funs not over yet. Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RMAN/NETBACKUP/ORACLE 8.1.6 Configuration Problems
We have SUN engineers configure and setup Netbackup and RMAN: since then we get repeated errors on all our databases: including the following: ORA-196506 failed to create sequential file returned error and rman-20242: specification does not match any archivelog in the recovery catalog (this we solve and it keeps repeating after the archivelogs have been deleted). Some instances just hang when it needs the tape. Does anyone have any advise/comments. Should we rip it all out and install from fresh ? I also feel that there were some patches added and the relinking of netbackup and oracle was not done. Thanks for any advise Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).