RE: Force users to use Active DG for reporting

From: Ricard Martinez <ricard.martinez_at_gmail.com>
Date: Mon, 31 Mar 2014 17:52:07 +0100
Message-ID: <CAFGV9um+HzLpBvKyVPFdDipCWMEho1bT28b4KQ3__+-LOwvanw_at_mail.gmail.com>



Hahaha yeah that will work like magic probably

BTW got a mistake on the last part:
***kill any session of the select schema on the RW (using a cron maybe, forcing them to use RO to be able to end their reports)*** On Mar 31, 2014 5:40 PM, "Ric Van Dyke" <ric.van.dyke_at_hotsos.com> wrote:

> Tell just a few users that RO is a secret database built just for them to
> do blazing fast reports on and not to tell anyone else about it.....
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ricard Martinez
> *Sent:* Monday, March 31, 2014 11:55 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* Force users to use Active DG for reporting
>
>
>
> Hi list,
>
>
>
> We got an environment formed by one standalone 11g database (lets call it
> RW) with an active dataguard on another server (lets call it RO)
>
> We have provided to the users 2 tnsnames, one pointing to RW and the other
> to the RO, and we have told them to use the first one for DML, etc and the
> RO only for runing the reporting statments.
>
>
>
> As good users, they just ignore us and run all on the RW database, so we
> want to force them to use the RO for reporting.
>
> Meanwhile they got the 2 tnsnames entries, i see no real options to force
> them to use the RW, unless we separate the schema in two (one with
> insert/update, the other only with select), and we kill any session of the
> select schema on the RO (using a cron maybe, forcing them to use RW to be
> able to end their reports)
>
>
>
> Has any of you found in a similar situation, or can think in other options?
>
>
>
> Thanks
>
>
>
>
>
>
>
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 31 2014 - 18:52:07 CEST

Original text of this message