Re: dblinks to cloud instance
Date: Mon, 19 Jul 2021 18:04:41 +0000
Message-ID: <AM8P194MB1628E39398B8273666B7C23185E19_at_AM8P194MB1628.EURP194.PROD.OUTLOOK.COM>
Seems big, but it’s not really.
1mb x 1,000,000 queries a day (and that’s not a lot) = 1TB.
I mean, the table/result-set being transferred is only 1mb…
10 days later, and you’d better get your cost calculator out.
On premises we rarely consider network as once you have the hardware, it’s “free”. It’s a primary source of revenue in the cloud.
Neil.
sent from my phone
On 19 Jul 2021, at 18:56, Jeff Chirco <backseatdba_at_gmail.com> wrote:
Thanks for the clarification about egress. I do remember now the first 10TB being free. That seems like a big amount but it all depends on how large your remote cloud tables are.
On Mon, Jul 19, 2021 at 10:27 AM Neil Chandler <neil_chandler_at_hotmail.com<mailto:neil_chandler_at_hotmail.com>> wrote: It's an excellent point. However, there are egress charges in OCI (although somewhat lower than AWS/Azure). The first 10TB per tenancy per month are free. It would not take a lot of queries with the driving site being on-prem to gobble that up.
Neil Chandler
Database Guy.
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Jeff Chirco <backseatdba_at_gmail.com<mailto:backseatdba_at_gmail.com>> Sent: 19 July 2021 17:02
To: Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com<mailto:dbakevlar_at_gmail.com>> Cc: mcdonald.connor_at_gmail.com<mailto:mcdonald.connor_at_gmail.com> <mcdonald.connor_at_gmail.com<mailto:mcdonald.connor_at_gmail.com>>; oracle-l-freelist <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: Re: dblinks to cloud instance
That is a good point about egress. This is a MSSQL instance running on Oracle Cloud Infrastructure actually. I don't believe there is any egress charges.
On Sun, Jul 18, 2021 at 9:58 AM Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com<mailto:dbakevlar_at_gmail.com>> wrote: Hate to pile onto this, but has anyone considered the egress charges from the cloud to onprem?
This is why I so often am moving everything to the cloud. And if this is just the beginning, they had better look into that cost!
Hope this helps,
Kellyn
On Sat, Jul 17, 2021 at 7:49 PM Connor McDonald <mcdonald.connor_at_gmail.com<mailto:mcdonald.connor_at_gmail.com>> wrote: Latency is a cloud killer :-)
This is not to say it can/should not be done, but typically you'll want to give some thought to app design to accommodate it.
eg if you're going query a table "n" times over the course of a certain time duration, perhaps drag the table (or subset) down to the local node once into a local table or mview, and then use it.
One risk of cross-database joins is the optimizer making the decision on where to do the join - driving_site can mitigate this risk to some degree.
On Thu, Jul 15, 2021 at 10:46 PM Jeff Chirco <backseatdba_at_gmail.com<mailto:backseatdba_at_gmail.com>> wrote: What is your opinion on joining to a table over a database link that resides in the cloud and your local database is on prem? And what if this cloud instance is MSSQL and your local is Oracle? We have something in the works that I just found out is supposed to go to production next week. They are joining local and remote tables together. So far in testing things are looking ok but the amount of data is limited right now, I am unsure how much it will grow to. Wondering if anyone has any experience with this.
Thanks,
Jeff
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 19 2021 - 20:04:41 CEST