From Yuval.Arnon@wwfent.com Wed, 30 Jan 2002 11:56:26 -0800 From: Yuval Arnon Date: Wed, 30 Jan 2002 11:56:26 -0800 Subject: RE: Oracle standby strange behavior Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: Oracle standby strange behavior Vadim, Thanks for the input but I already made sure all arc files have been transferred and applied and that an 'alter system switch logfile' was executed prior to that.   Yuval. -----Original Message-----From: Vadim Gorbounov [mailto:vgorbounov@simplyengineering.com]Sent: Wednesday, January 30, 2002 2:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle standby strange behavior Hi, Yuval. Did you make sure, you've got latest data transferred and applied? I bet, these two tables have largest OBJECT_ID in the original DB.   Before you activate standby, do 1. On production   SQL> alter system switch logfile;   2. Transfer all archived logs to standby and make sure they are applied.   Hopefully, no more problem.   Vadim   -----Original Message-----From: Yuval Arnon [mailto:Yuval.Arnon@wwfent.com]Sent: Wednesday, January 30, 2002 1:41 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle standby strange behavior Hi, I ran into a strange behavior of a standby database. On the primary db I have an application schema and a query schema. All tables from the appl schema have public synonyms and a grant select to public. User query is created with connect and resource roles. Once I switch over to the standby db , and put it in read only mode, and then connect to the query user, I can not perform a select against 2 of the 35 tables. I get object OBJECT_NAME does not exist. I can connect to the system user on the standby database and I have no problem selecting from all the tables. Any idea what am I missing?? Yuval. -----Original Message----- From: Orr, Steve [mailto:sorr@rightnow.com] Sent: Wednesday, January 30, 2002 12:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Performance Tuning Rachel IS kind but her words are also true and I think this was her main focus in this case.  ;-) My Alomari book was for v7 and was good but is now dated... Is it up to date for 8i/9i? -----Original Message----- Sent: Wednesday, January 30, 2002 10:11 AM To: Multiple recipients of list ORACLE-L Rachel, Thank you so much for you kind words and the very interesting comparison.. :) - Kirti -----Original Message----- Sent: Wednesday, January 30, 2002 9:50 AM To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- "SARKAR, Samir" wrote: > Practically, u should get two books to have a full grasp on Oracle > Performance > Tuning : > > 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec > 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari > > If u r in an exceptionally high development environment where u have > lots of > SQL tuning to do, > consider buying the SQL High Performance Tuning by Don Burleson. > Otherwise, > the > above two books should suffice for both production and development > databases. > > Samir > > Samir Sarkar > Oracle DBA - Lennon Team > SchlumbergerSema > Email :  samir.sarkar@nottingham.sema.slb.com >             samir.sarkar@sema.co.uk > Phone : +44 (0) 115 - 957 6217 > EPABX : +44 (0) 115 - 957 6418 Ext. 76217 > Fax : +44 (0) 115 - 957 6018            > > > -----Original Message----- > Sent: 30 January 2002 10:25 > To: Multiple recipients of list ORACLE-L > > > Hi Everyone > >       I am interested in purchasing some exceptionally good book on Oracle > Performance Tuning. Can anyone suggest me some very good book on > Oracle > Tunning worth purchasing > > > Binay Kumar > Oracle Cerified DBA > > London > > > > *********************************** > Binay Kumar > Focus 3 -Technical Support > P & O Nedllyod > London > 0044 207 441 1648 > *********************************** > > > > ------------------------------------------------------------------- > > The contents of this e-mail are confidential to the ordinary user > of the e-mail address to which it was addressed and may also be > privileged. If you are not the addressee of this e-mail you should > not copy, forward, disclose or otherwise use it or any part of it > in any form whatsoever. If you have received this e-mail in error > please notify us by telephone or e-mail the sender by replying to > this message, and then delete this e-mail and other copies of it > from your computer system. Thank you. > > We reserve the right to monitor all e-mail communications through > our network. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: >   INET: BINAY.KUMAR@ponl.com > > 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: ListGuru@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). > > > ___________________________________________________________________________ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented > are > solely those of the author and do not necessarily represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised that you have > received this > email in error and that any use, dissemination, forwarding, printing, > or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the > SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. > ___________________________________________________________________________ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: SARKAR, Samir >   INET: Samir.SARKAR@nottingham.sema.slb.com > > 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: ListGuru@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). __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael   INET: wisernet100@yahoo.com 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: ListGuru@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.com -- Author: Deshpande, Kirti   INET: kirti.deshpande@verizon.com 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: ListGuru@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.com -- Author: Orr, Steve   INET: sorr@rightnow.com 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: ListGuru@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).