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:[EMAIL PROTECTED]]
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" <[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> 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: [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).
>
>
>
___________________________________________________________________________
> 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: [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).
__________________________________________________
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
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).