Re: Database Link in local server

You can do something like that with ADG, assuming you read from standby, and write to primary. There is also a way to get the stats from the standby available to the primary, though I would need to go back and research the exact process for that.

Sent from my iPad

> On Apr 29, 2021, at 17:30, Cee Pee <carlospena999_at_gmail.com> 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.
>
> Without replication ($$), one thought that comes to mind is having another DB, say workDB, in the same server which then can connect via a local DB link to the standby DB. I am assuming performance will not be bad because the data comes from the same server. Of course there will be additional resource usage, esp IO and CPU that need to be considered.
>
> One important thing that comes to my mind is the statistics. Is there a way to make the 'workDB' see the statistics in the remote database (the standbyDB) when the workDB queries come up with execution plans? This may sound silly, but you never know unless you ask.
>
> 19c, multi TB size warehouse.
>
> CP.

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