Re: Force users to use Active DG for reporting
Date: Wed, 2 Apr 2014 12:35:33 -0500
Message-ID: <CAFU3ey55cAjsk1wKRZigFjxBp7gp155sZcF6RdMAsJ7R=_HQKw_at_mail.gmail.com>
Maybe you are referring to resource manager? The two databases are identical, so you can't have different resource plans.
Andy
On Wed, Apr 2, 2014 at 12:00 PM, Dba DBA <oracledbaquestions_at_gmail.com>wrote:
> I have never done this before, but I think you can use 'resource groups'
> (that isn't the exact name) and/or profiles to limit how much CPU, etc...
> sessions can use before they are auto-killed. I have not used this before.
>
> Anyone done this? You may be able to throttle users and this lack of
> support would force them to go to the standby DB or there reports won't
> run.
>
>
> On Mon, Mar 31, 2014 at 11:55 AM, Ricard Martinez <
> ricard.martinez_at_gmail.com> wrote:
>
>> 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
>>
>>
>>
>>
>>
>>
>>
>
-- Andy Wattenhofer Manager, Database Administration University of Minnesota -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 02 2014 - 19:35:33 CEST