MIME-Version: 1.0
References: <CAPTPB10sk0o_AKzdZKMHZLxmx9+czUrWwUJ=jWZzVvaHCk2T_w@mail.gmail.com>
 <a7d474fc-bde3-44de-4ce5-5ac215a14063@gmail.com>
In-Reply-To: <a7d474fc-bde3-44de-4ce5-5ac215a14063@gmail.com>
From: Sayan Malakshinov <xt.and.r@gmail.com>
Date: Fri, 30 Apr 2021 05:33:29 +0300
Message-ID: <CAOVevU7O5UC8RAzVxALnwpeUiE43Cvd=VQZ6uUQS4utexaUGdg@mail.gmail.com>
Subject: Re: Database Link in local server
To: Mladen Gogala <gogala.mladen@gmail.com>
Cc: ORACLE-L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="000000000000a5134105c1277037"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: xt.and.r@gmail.com
--000000000000a5134105c1277037
Content-Type: text/plain; charset="UTF-8"

Hi Cee,

I'm not sure what do you mean by "see statistics". If you mean can CBO on
your "workDB" get required statistics from active standby through a dblink,
then - yes, of course. No difference if that's active standby or not.

Best regards,
Sayan Malakshinov
Oracle performance tuning expert
Oracle Database Developer Choice Award winner
Oracle ACE Associate
http://orasql.org

On Fri, Apr 30, 2021, 05:16 Mladen Gogala <gogala.mladen@gmail.com> wrote:

> No can do. You can do that with Golden Gate or logical standby DB, but
> not active DG.
>
> On 4/29/21 6:30 PM, Cee Pee wrote:
> >
> > We have a standby DB in a DR server open for read only. A user wants
> > to be able to pull the data in the server in some schemas (call them
> > schemaA, schemaB) and want to write data in other schemas (say
> > schemaX, schemaY) after manipulation.
> >
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--000000000000a5134105c1277037
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi Cee,=C2=A0<div dir=3D"auto"><br></div><div dir=3D"auto=
">I&#39;m not sure what do you mean by &quot;see statistics&quot;. If you m=
ean can CBO on your &quot;workDB&quot; get required statistics from active =
standby through a dblink, then - yes, of course. No difference if that&#39;=
s active standby or not.=C2=A0<br><br><div data-smartmail=3D"gmail_signatur=
e" dir=3D"auto">Best regards,<br>Sayan Malakshinov <br>Oracle performance t=
uning expert<br>Oracle Database Developer Choice Award winner <br>Oracle AC=
E Associate <br><a href=3D"http://orasql.org">http://orasql.org</a> </div><=
/div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_a=
ttr">On Fri, Apr 30, 2021, 05:16 Mladen Gogala &lt;<a href=3D"mailto:gogala=
.mladen@gmail.com">gogala.mladen@gmail.com</a>&gt; wrote:<br></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc s=
olid;padding-left:1ex">No can do. You can do that with Golden Gate or logic=
al standby DB, but <br>
not active DG.<br>
<br>
On 4/29/21 6:30 PM, Cee Pee wrote:<br>
&gt;<br>
&gt; We have a standby DB in a DR server open for read only. A user wants <=
br>
&gt; to be able to pull the data in the server in some schemas (call them <=
br>
&gt; schemaA, schemaB) and want to write data in other schemas (say <br>
&gt; schemaX, schemaY) after manipulation.<br>
&gt;<br>
-- <br>
Mladen Gogala<br>
Database Consultant<br>
Tel: (347) 321-1217<br>
<a href=3D"https://dbwhisperer.wordpress.com" rel=3D"noreferrer noreferrer"=
 target=3D"_blank">https://dbwhisperer.wordpress.com</a><br>
<br>
--<br>
<a href=3D"http://www.freelists.org/webpage/oracle-l" rel=3D"noreferrer nor=
eferrer" target=3D"_blank">http://www.freelists.org/webpage/oracle-l</a><br=
>
<br>
<br>
</blockquote></div>

--000000000000a5134105c1277037--
--
http://www.freelists.org/webpage/oracle-l