Podcast appearances and mentions of David Wright

Sal is facing a classic New York sports fan dilemma: attend Lionel Messi's highly anticipated Red Bulls match or witness Mets legend David Wright's number retirement ceremony, both on the same July 19th. With family wanting to see Messi and personal loyalty to Wright, they must weigh the excitement of a global soccer superstar against honoring a beloved Mets captain, creating a tough choice.

BT and Sal are grappling with a baseball crisis in New York, as both the Yankees and Mets are deep in a "losing streak" that has left fans reeling. They're particularly frustrated by the Yankees' anemic offense, which relies too heavily on solo home runs, and the Mets' struggling pitching, which has led to tough losses against division rivals like the Braves. The hosts are lamenting fundamental errors from both teams, from poor base-running to bullpen meltdowns, leaving them to wonder when things will finally turn around. On top of that, BT and Sal are facing a classic New York sports dilemma: choosing between attending Lionel Messi's highly anticipated Red Bulls match or David Wright's Mets number retirement ceremony, both happening on July 19th, torn between family wishes and personal loyalty to a Mets legend.

BT and Sal opened their show with a passionate, if despairing, breakdown of the concurrent losing streaks afflicting both the Yankees and Mets, lambasting the "circus" of errors, baserunning gaffes, and anemic clutch hitting that has plagued both New York baseball teams. Sal zeroed in on the Mets' perennial struggles against the Braves, while BT meticulously dissected the Yankees' inexplicable offensive slump without Aaron Judge and their abysmal .077 batting average in extra innings, even with the ghost runner. Beyond the current woes, the hosts expressed deep concern over the Yankees' player development, particularly Anthony Volpe's struggles, questioning the organization's strategy of playing prospects out of position and stunting homegrown talent. Amidst the on-field sloppiness and management accountability questions, BT and Sal also grappled with a quintessential New York dilemma, debating whether to attend Lionel Messi's Red Bulls match or David Wright's Mets number retirement ceremony, both slated for July 19th. Despite the grim state of New York baseball, BT and Sal maintained their characteristic high energy and good vibes, promising listeners an uplifting show even in the toughest of times.

In this episode, Lois Houston and Nikita Abraham, along with Nick Wagner, Senior Director of Product Management, dive into the Replicat process in Oracle GoldenGate 23ai.   They discuss how Replicat applies changes to the target database, highlighting the different types: Classic, Coordinated, and Parallel Replicat.   Oracle GoldenGate 23ai: Fundamentals: https://mylearn.oracle.com/ou/course/oracle-goldengate-23ai-fundamentals/145884/237273 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode. ---------------------------------------------------------------- Episode Transcript: 00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started! 00:25 Lois: Hello and welcome to another episode of the Oracle University Podcast. I'm Lois Houston, Director of Innovation Programs with Oracle University, and with me is Nikita Abraham, Team Lead: Editorial Services.  Nikita: Hi everyone! If you've been listening to us these last few weeks, you'll know we've been discussing the fundamentals of GoldenGate 23ai. Today is going to be all about the Replicat process. Again, this is something we've discussed briefly in earlier episodes, but just to recap, the Replicat process applies changes from the source database to the target database. It's responsible for reading trail files and applying the changes to the target system. 01:04 Lois: That's right, Niki. And we'll be chatting with Nick Wagner, Senior Director of Product Management for Oracle GoldenGate. Hi Nick! Thanks for joining us again today. Let's get straight into it. Can you give us an overview of the Replicat process? Nick: One thing that's very important is the Replicat is extremely chatty with that target database. So it's going to be going in and trying to make lots of little transactions on that system. The Replicat process only issues single row DML. So if you can imagine a source database that's generating hundreds of thousands of changes per second, we're going to have to have a Replicat process that can do 100,000 changes per second on that target site. That means that it's going to have to send a lot of little one record commands. And so we've got a lot of ways to optimize that. But in all situations you're really going to want very, very low ping time between that Replicat process and that target database. This often means that if you're going to be running GoldenGate in a cloud, you're going to want the Cloud GoldenGate environment to be running in that target data center, wherever that target database is. 02:06 Lois: What are the key characteristics of the process, Nick? Nick: Replicat process is going to read the changes from the trail file and then apply them to the target system, just like any database user would. It's not doing anything special where it's going under the covers and trying to apply directly to the database blocks. It's just applying regular standard insert, update, delete, and DDL statements to that target database. A single trail file does support high volume of data replication activity depending on the type of Replicat. Replicats do preserve the boundary of their transactions. So in the situations, by default, a transaction that's on the source, let's say five inserts followed by a commit will remain five inserts followed by a commit on the target site. There are some operations and changes that do affect this, but they're not turned on by default. There are things like group transactions that allows you to group multiple transactions into a single commit. This one could actually improve performance in some cases. We also have batch SQL that can change the boundaries of a transaction as well. And then in a Parallel Replicat, you actually have the ability to split a large transaction into multiple chunks and apply those chunks in Parallel. So again, by default, it's going to preserve the boundaries, but there are ways to change that. And then the Replicats use a checkpoint table to help with recovery and to know where they're applying data and what they've done. The other thing in here is, like an Extract process can write to multiple trails and write subsets of data to each one, a Replicat can only process a single set of trail files at once. So it's going to be attached to a specific trail file like trail file AB, and will only be able to read changes from trail file AB. If I have multiple trails that need to be applied into a target system, then I have to set up multiple Replicats to handle that. 03:54 Nikita: So, what are the different Replicat types, Nick? Nick: We have three types in the product today. We have Classic Replicat, which should really only be used for testing purposes or in environments that don't support any of the other specialized Replicats. We have Coordinated Replicat, which is a high speed apply mechanism to apply data into a target system. It does have some parallelism in it, but it's user defined parallelism. And then we have our flagship and that's Parallel Replicat. And this is the most performant lowest latency Replicat that we have. 04:25 Lois: Ok. Let's dive a little deeper into each of them, starting with the Classic Replicat. How does it work? Nick: It's pretty straightforward. You're going to have a process that reads the trail files, and then in a single threaded fashion it's going to take the trail file logical change record, convert it to an insert, update, or delete, and then apply it into that target database. Each transaction that it does is preceded by a change to the checkpoint table. So when the transaction that the Replicat is currently doing is committed, that checkpoint table update also gets committed. That way when the Replicat restarts, it knows exactly what transaction it left off and how it last applied the record. And all the Replicats work the same way with regards to checkpoint tables. They each have their own little method of ensuring that the transaction they're applying is also reflected within the checkpoint table so that when it restarts, it knows exactly where it happened. That way, if a Replicat dies in the middle of a transaction, it can be restarted without any duplicate data or without missing data. 05:29 Did you know that Oracle University offers free courses on Oracle Cloud Infrastructure? You'll find training on everything from multicloud, database, networking, and security to artificial intelligence and machine learning, all free for our subscribers. So, what are you waiting for? Pick a topic, head over to mylearn.oracle.com, and get started. 05:53 Nikita: Welcome back! Moving on, what about Coordinated Replicat? Nick: The Coordinated Replicat is going to read from a set of trail files. It's going to have multiple threads that do this. So you have your base thread, your coordinated thread that's going to be thread 1. It's going to process the data and apply it into that target database. You then have thread 2, 4, 5, 6, and so on. When you set up your Replicat parameter file for a Coordinated Replicat, the map commands that maps from one table on the source to a table on the target has an additional option. So you'll have an option called a range or thread range. With the range and thread range option, you can actually tell which table to go into which thread. 06:38 Lois: Can you give us an example of this? Nick: So I could say map Scott.M into thread 1 and I want Scott.Dept into thread 2. Well, this is fantastic until you realize that Scott.M and Scott.Dept have a foreign key between them or a child dependencies, parent-child relationships. What that means is that now I'm going to have to disable that foreign key on the target site, because there's no way for GoldenGate to coordinate the changes in one thread to another thread. And so you really have to be careful on how you pair your tables together. If you don't have any referential integrity on that target database, then you can use parallel coordinated Replicat to really high degrees of parallelism, and you get some very good performance out of it. Let's say that you have a table that's really got too much data for even a single thread to process, that's where the thread range comes in. And thread range command will use something like the table's primary key to split transactions on that table across multiple threads. So I can say, hey, take my table Scott.M and I want to spread transactions across threads 10, 11, 12, 13, and 14 and then spread them evenly based on the primary key. And Coordinated Replicat will do that. So you can get some very high performance numbers out of it and you can really fine tune the tables, especially if you know the amount of data coming into each one. While this does work great, we observed that a lot of customers really don't know their applications to that level of detail, and so we needed a different method to push data into that target database, where we could define the parallelism based on the database expectations. So instead of the customer having to try and figure out what are the parent-child relationships, why can't GoldenGate do it for me? And that led to Parallel Replicat.  08:26 Nikita: And what are the benefits and features of the Parallel Replicat process?  Nick: So Parallel Replicat has been around for quite a few years now. It supports most targets, it was Oracle initially, but now it's been expanded out to a lot of the non-Oracle targets and even some of the nonrelational database targets. It has absolutely the best performance of any Replicat process out there. You can use it to split large transactions as well. So if all of a sudden you have a batch job that does a million inserts followed by a single commit, I can split that across 10 threads, each thread doing 100,000 inserts. And it's aware of your transaction dependencies, that's the cool thing. So in Coordinated Replicat, you had to worry about how to split your tables up, in Parallel Replicat, we do it for you. 09:11 Lois: And how does Parallel Replicat work? Nick: So there's three main processes to the Parallel Replicat. You have your first is the mapper process. This is going to be responsible for taking the data out of the trail files and putting them into kind of our collator and scheduler box. As transactions go from the trail file, they get put into this box in memory where they're processed. There's a collator process that will look at these processes and go, OK, as they're coming in, let me read some of the data in them to determine how they can be applied in Parallel or not. And so the collator process understands the foreign key dependencies on that target database. And it's able to say, hey, I know that my two tables are these two tables, have a parent-child relationship, I need to make sure that changes on those tables go in the correct order. And so if all of a sudden you see an insert using the parent record and then another insert into the child record and they're mapped together, GoldenGate will ensure that those two transactions go serially and not parallel where they could get applied out of order. There's then a scheduler process that's going to look at this and say, OK, now that I'm taking transactions from the collator process, who's already identified whether or not transactions can be applied in parallel or serial, and I'm going to feed them off to applier processes that are ready and waiting for me to apply those changes into the database. And then the applier process is waiting for the scheduler process to send its transactions and say, OK, what's my next one? Where's the next transaction I should be working on and applying? And then the applier process is the one actually applying the changes into that target database, again, just using standard DML operations. So there's a lot of benefits to this one. You don't need to worry about your foreign key dependencies, you can leave all your foreign keys enabled. The collator process will actually use information within the trail file to determine which transactions can be applied in parallel, and which one needs to be applied serially. 11:13 Lois: Thank you, Nick, for this insightful conversation. There's loads more to discover about the Replicat process, and you can do that by heading over to mylearn.oracle.com and searching for the Oracle GoldenGate 23ai: Fundamentals course. Nikita: In our next episode, Nick will take us through managing Extract Trails and Files. Until then, this is Nikita Abraham… Lois: And Lois Houston, signing off! 11:37 That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

Hour 1 This weekend, both the Mets and Yankees were swept, while the Phillies extended their winning streak, and in a significant move, the Red Sox traded Rafael Devers to San Francisco after he homered in his final game with Boston; Aaron Judge notably struggled, going 1-for-12 with 9 strikeouts. In golf, JJ Spaun won the US Open, while Gio noted that something seems to be amiss with Rory, which warrants monitoring as he heads to Bethpage Black; meanwhile, the Knicks are still seeking a head coach, and Tyler Herro of the Miami Heat stated he doesn't believe anything in history prior to 1950. Hour 2 Both the Mets and Yankees were swept this weekend, with the Mets now heading to Atlanta and a caller demanding Aaron Boone's firing due to the Yankees' fundamental errors, including baserunning mistakes by Dominguez and Rice. This came after Rafael Devers, who homered in his final game for Boston, was traded from the Red Sox to San Francisco. Meanwhile, Mike Francesa's prediction of a Mets losing streak came true, and despite Pete Alonso's strong offense, his throwing issues to first base persist. In golf, JJ Spaun won the US Open on Father's Day, and on the Knicks front, they are interviewing Mike Brown and Taylor Jenkins for the head coach position, while Dan Plesac of MLB Network was reportedly scammed by an "unpaid tolls" text message. Hour 3 The Knicks are interviewing Mike Brown and Taylor Jenkins for their head coaching vacancy, with one caller criticizing Leon Rose for the team's current state and another suggesting Jay Wright, though he's not a candidate. Meanwhile, the Yankees were swept in Boston, a series that saw Rafael Devers traded to the Giants after homering. The Mets also suffered a three-game losing streak, fulfilling Mike Francesa's prediction to Frank The Tank, and now head to Atlanta. In other sports news, JJ Spaun won the US Open, and Fanatics selected 50 regular people to compete against professional athletes. A caller also proposed Allan Houston or John Starks as potential Knicks coaches. Hour 4 Boomer reacted to the Chris Kreider trade, calling him one of the Rangers' all-time greats while acknowledging his frustrating moments, which led to a comparison of long-tenured New York athletes like the Mets' David Wright and Giants' Tiki Barber, with Gio expressing surprise at the Mets retiring Wright's #5 jersey so soon. In other sports news, Rafael Devers homered to beat the Yankees before being traded, the Mets were swept at home by the Rays, and JJ Spaun won the US Open. The show also featured a "Moment of the Day" with a caller's heartfelt story to a distracted Joe Benigno, and a reminder that the show would be off the following day for a round of golf at Bethpage Black, the future site of the Ryder Cup. And what's going on with Rory?

Boomer reacted to the Chris Kreider trade, calling him one of the Rangers' all-time greats while acknowledging his frustrating moments, which led to a comparison of long-tenured New York athletes like the Mets' David Wright and Giants' Tiki Barber, with Gio expressing surprise at the Mets retiring Wright's #5 jersey so soon. In other sports news, Rafael Devers homered to beat the Yankees before being traded, the Mets were swept at home by the Rays, and JJ Spaun won the US Open. The show also featured a "Moment of the Day" with a caller's heartfelt story to a distracted Joe Benigno, and a reminder that the show would be off the following day for a round of golf at Bethpage Black, the future site of the Ryder Cup. And what's going on with Rory?

Gio was surprised the Mets are already retiring Wright's #5 jersey.

Zach, Jack, and Andrew discuss Pete overtaking David Wright's home run total, which starting pitchers are fighting for their jobs, who will step up in the lineup behind Soto and Alonso, Jeff McNeil's resurgence, Juan Soto is back, Ronny Mauricio's future, the dilemma of Luisangel Acuña, wrong names, mic'd up errors, and the moment that Blewett blew it.

Living and Working in Spain with David Wright:The Ultimate Expat Guide Special guest today Josh Williams from Ambient wealth And Paul Burt from indalo transport Welcome to Living and Working in Spain with David Wright, your go-to hub for expert advice and practical resources tailored for expats. Whether you're planning your move to Spain or navigating life as a resident,David Wright offers the guidance you need to make your Spanish dream a reality. Visit DavidWrightOnline.com for exclusive insights and resources.  Exclusive Resources for Expats in Spain Unlock the benefits of David Wright's exclusive membership platform, where you'll find tailored advice on essential topics like:   Spanish Residency and Visas: Step-by-step guidance through the legal process. Employment Opportunities: Tips for finding work in Spain. Cultural Integration: How to blend seamlessly into Spanish society. Lifestyle Advice: Insider tips for a stress-free transition. Meet David Wright: Your Trusted Expat Mentor With over 23 years of experience living in Spain, David Wright is a trusted authority on expat life. As the author of six bestselling books on Amazon and Kindle, David's insights have been featured on platforms like BBC News and Channel 4's A Place in the Sun.   Through his expertise and vast network, David provides actionable guidance to both newcomers and long-term residents in Spain.   Listen to The Wright Way Live Radio Show Stay informed with The Wright Way, David Wright's live radio show on Almeria Radio 107.5 FM.  

Bayleigh and Chrystal are back to chat about everything happening in Major League Baseball and the state of their respective Sox. A quick note: Towards the end of the episode, Chrystal brought up Pete Alonso tying David Wright for second place on the franchise home run list. Moments after the recording ended, Alonso nuked another home run, giving him sole possession of second place, and now nine home runs away from Darryl Strawberry's record. Here is what the ladies covered during this episode: Roman Anthony's 497-foot grand slam as he dies in the minor leagues, and the Red Sox being bad Kyle Teel's call-up, Tim Elko's return, and how good Chase Meidroth has been The woman who cursed the Rockies Texas is the bad place, and the Rangers won't be holding a Pride Night yet again The Dodgers are down bad with pitching Craig Kimbrel's DFA Injuries galore featuring Alex Bregman, Ryan Mountcastle and Shane Beiber The Detroit Tigers — who are good Jac Caglianone AL/NL Player of the Month for May Reinstatements after one-year betting ban Kim Ng's new league — professional softball, FINALLY Evan Longoria's retirement Francisco Lindor and the man that he is Marcelo Mayer's first home run Pete Alonso's record-breaking home run State of the Sox Find Bayleigh on Twitter/X and Chrystal on Bluesky. Learn more about your ad choices. Visit megaphone.fm/adchoices

In this episode, Lois Houston and Nikita Abraham dive into key components of Oracle GoldenGate 23ai with expert insights from Nick Wagner, Senior Director of Product Management.   They break down the Distribution Service, explaining how it moves trail files between environments, replaces the classic extract pump, and ensures secure data transfer. Nick also introduces Target Initiated Paths, a method for connecting less secure environments to more secure ones, and discusses how the Receiver Service simplifies monitoring and management. The episode wraps up with a look into Initial Load, covering different methods for syncing source and target databases without downtime.   Oracle GoldenGate 23ai: Fundamentals: https://mylearn.oracle.com/ou/course/oracle-goldengate-23ai-fundamentals/145884/237273 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode. ----------------------------------------------------------------- Episode Transcript: 00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started! 00:25 Nikita: Welcome to the Oracle University Podcast! I'm Nikita Abraham, Team Lead of Editorial Services with Oracle University, and with me is Lois Houston, Director of Innovation Programs.  Lois: Hey there! Last week, we spoke about the Extract process and today we're going to spend time discussing the Distribution Path, Target Initiated Path, Receiver Server, and Initial Load. These are all critical components of the GoldenGate architecture, and understanding how they work together is essential for successful data replication. 00:58 Nikita: To help us navigate these topics, we've got Nick Wagner joining us again. Nick is a Senior Director of Product Management for Oracle GoldenGate. Hi Nick! Thanks for being with us today. To kick things off, can you tell us what the distribution service is and how it works? Nick: A distribution path is used when we need to send trail files between two different GoldenGate environments. The distribution service replaces the extract pump that was used in GoldenGate classic architecture. And so the distribution service will send the trail files as they're being created to that receiver service and it will write the trail files over on the target system. The distribution service works in a kind of a streaming fashion, so it's constantly pulling the trail files that the extract is creating to see if there's any new data. As soon as it sees new data, it'll packet it up and send it across the network to the receiver service. It can use a couple of different methods to do this. The most secure and recommended method is using a WebSocket secure connection or WSS. If you're going between a microservices and a classic architecture, you can actually tell the distribution service to send it using the classic architecture method. In that case, it's the OGG option when you're configuring the distribution service. There's also some unsecured methods that would send the trail files in plain text. The receiver service is then responsible for taking that data and rewriting it into the trail file on the target site. 02:23 Lois: Nick, what are some of the key features and responsibilities of the distribution service? Nick: It's responsible for command deployment. So any time that you're going to actually make a command to the distribution service, it gets handled there directly. It can handle multiple commands concurrently. It's going to dispatch trail files to one or more receiver servers so you can actually have a single distribution path, send trail files to multiple targets. It can provide some lightweight filtering so you can decide which tables get sent to the target system. And it also is integrated in with our data streams, our pub and subscribe model that we've added in GoldenGate 23ai. 03:01 Lois: Interesting. And are there any protocols to remember when using the distribution service? Nick: We always recommend a secure WebSocket. You also have proxy support for use within cloud environments. And then if you're going to a classic architecture GoldenGate, you would use the Oracle GoldenGate protocol. So in order to communicate with the distribution service and send it commands, you can communicate directly from any web browser, client software-- installation is not required-- or you can also do it through the admin client if necessary, but you can do it directly through browsers. 03:33 Nikita: Ok, let's move on to the target initiated path. Nick, what is it and what does it do essentially? Nick: This is used when you're communicating from a less secure environment to a more secure environment. Often, this requires going through some sort of DMZ. In these situations, a connection cannot be established from the less secure environment into the more secure environment. It actually needs to be established from the more secure environment out. And so if we need to replicate data into a more secure environment, we need to actually have the target GoldenGate environment initiate that connection so that it can be established.  And that's what a target-initiated path does. 04:12 Lois: And how do you set it up? Nick: It's pretty straightforward to set up. You actually don't even need to worry about it on the source side. You actually set it up and configure it from the target. The receiver service is responsible for receiving the trail file data and writing it to the local trail file. In this situation, we have a target-initiated path created. And so that receiver service is going to write the trail files locally and the replicat is going to apply that data into that target system. 04:37 Nikita: I also want to ask you about the Receiver service. What is it really? Nick: Receiver service is pretty straightforward. It's a centrally controlled service. It allows you to view the status of your distribution path and replaces target side collectors that were available in the classic architecture of GoldenGate. You can also get statistics about the receiver service directly from the web UI.  You can get detailed information about these paths by going into the receiver service and identifying information like network details, transfer protocols, how many bytes it's received, how many bytes it's sent out. If you need to issue commands from the admin client to the receiver service, you can use the info command to get details about it. Info all will tell you everything that's running. And you can see that your receiver service is up and running. 05:28 Are you working towards an Oracle Certification this year? Join us at one of our certification prep live events in the Oracle University Learning Community. Get insider tips from seasoned experts and learn from others who have already taken their certifications. Go to community.oracle.com/ou to jump-start your journey towards certification today! 05:53 Nikita: Welcome back. In the last section of today's episode, we'll cover what Initial Load is. Nick, can you break down the basics for us? Nick: So, the initial load is really used when you need to synchronize the source and target systems. Because GoldenGate is designed for 24/7 environments, we need to be able to do that initial load without taking downtime on the source. And so all the methods that we talk about do not require any downtime for that source database. 06:18 Lois: How do you do the initial load? Nick: So there's a couple of different ways to do the initial load. And it really depends on what your topology is. If I'm doing like-to-like replication in a homogeneous environment, we'll say Oracle-to-Oracle, the best options are to use something that's integrated with GoldenGate, some sort of precise instantiation method that does not require HandleCollisions. That's something like a database backup and restoring it to a specific SDN or CSN value using a Database Snapshot. Or in some cases, we can use Oracle Data Pump integration with GoldenGate. There are some less precise instantiation options, which do require HandleCollisions. We also have dissimilar initial load methods. And this is typically when you're going between heterogeneous environments. When my source and target databases don't match and there isn't any kind of fast unload or fast load utility that I could use between those two databases. In almost all cases, this does require HandleCollisions to be used. 07:16 Nikita: Got it. So, with so many options available, are there any advantages to using GoldenGate's own initial load method?  Nick: While some databases do have very good fast load and unload utilities, there are some advantages to using GoldenGate's own initial load method. One, it supports heterogeneous replication environments. So if I'm going from Postgres to Oracle, it'll do all the data type transformation, character set transformation for me. It doesn't require any downtime, if certain conditions are met.  It actually performs transformation as the data is loaded, too, as well as filtering. And so any transformation that you would be doing in your normal transaction log replication or CDC replication can also go through the same transformation for the initial load process. GoldenGate's initial load process does read directly from the source tables. And it fetches the data in arrays. It also uses parallel processing to speed up the replication. It does also handle activity on the source tables during the initial load process, so you do not need to worry about quiescing that source database. And a lot of the initial load methods directly built into GoldenGate support distributed application analytics targets, including things like Databricks, Snowflake, BigQuery. 08:28 Lois: And what about its limitations? Or to put it differently, when should users consider using different methods? Nick: So the first thing to consider is system proximity. We want to make sure that the two systems we're working with are close together. Or if not, how are we going to send the data across? One thing to keep in mind, when we do the initial load, the source database is not quiesced. So if it takes an hour to do the initial load or 10 hours, it really doesn't matter to GoldenGate. So that's something to keep in mind. Even though we talk about performance of this, the performance really isn't as critical as one might suspect. So the important thing about data system proximity is the proximity to the extract and replicat processes that are going to be pulling the data out and pushing it across. And then how much data is generated? Are we talking about a database that's just a couple of gigabytes? Or are we talking about a database that's hundreds of terabytes? Do we want to consider outage time? Would it be faster to take a little bit of outage and use some other method to move the data across? What kind of outage or downtime windows do we have for these environments? And then another consideration is disk space. As we're pulling the data out of that source database, we need to have somewhere to store it. And if we don't have enough disk space, we need to run to temporary space or to use multiple external drives to be able to support it. So these are all different considerations. 09:50 Nikita: I think we can wind up our episode with that. Thanks, Nick, for giving us your insights.  Lois: If you'd like to learn more about the topics we covered today, head over to mylearn.oracle.com and check out the Oracle GoldenGate 23ai: Fundamentals course. Nikita: In our next episode, Nick will take us through the Replicat process. Until then, this is Nikita Abraham… Lois: And, Lois Houston signing off! 10:14 That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

Bad Weather Fans' post about no new "Roommates" podcast sparked Gio's observation that no Knicks players or management have commented on Thibs' firing. This silence, he reasoned, allows for rampant speculation, aligning with the Knicks' history of firing coaches still under contract. Jerry then updated the sports news: Boston hit five homers to beat the Yankees, despite two from Aaron Judge; Pete Alonso's two home runs helped the Mets sweep the Rockies, pushing him past David Wright on the Mets' all-time list; and the Thunder evened their series with the Pacers at 1-1. The hour concluded with more discussion about American hamburger consumption and the theory that James Dolan fired Thibs after sitting in on player interviews.

Boomer's flight to Cincinnati for a Kenny Anderson event was canceled due to a lightning strike, preventing him from attending. Meanwhile, the Knicks' coaching search continues, with Jason Kidd and Michael Malone being considered. The recent developments suggest James Dolan's decision to fire Thibs was impulsive. In sports news, the Red Sox defeated the Yankees with five home runs, despite two from Aaron Judge, and swept the series. The Yankees' X (Twitter) account used a Brandon Tierney song without credit. The Mets swept the Rockies, with two homers each from Pete Alonso and Jeff McNeil; Alonso surpassed David Wright on the Mets' all-time home run list, earning Wright's congratulations. Finally, the Yankees-Red Sox rivalry made headlines when rookie pitcher Hunter Dobbins stated he'd retire rather than play for the Yankees. This prompted Boomer to recall his own refusal to play for the Colts after their move from Baltimore due to its impact on his college community in Maryland.

Hour 1 Boomer's flight to Cincinnati for a Kenny Anderson event was canceled due to a lightning strike, preventing him from attending. Meanwhile, the Knicks' coaching search continues, with Jason Kidd and Michael Malone being considered. The recent developments suggest James Dolan's decision to fire Thibs was impulsive. In sports news, the Red Sox defeated the Yankees with five home runs, despite two from Aaron Judge, and swept the series. The Yankees' X (Twitter) account used a Brandon Tierney song without credit. The Mets swept the Rockies, with two homers each from Pete Alonso and Jeff McNeil; Alonso surpassed David Wright on the Mets' all-time home run list, earning Wright's congratulations. Finally, the Yankees-Red Sox rivalry made headlines when rookie pitcher Hunter Dobbins stated he'd retire rather than play for the Yankees. This prompted Boomer to recall his own refusal to play for the Colts after their move from Baltimore due to its impact on his college community in Maryland. Hour 2 Pete Alonso, now second on the Mets' all-time home run list, is only under contract for the current season. Listeners speculated the Knicks' success might be due to James Dolan's focus on The Sphere, while others called in about the Mets' strong start. Boomer, and several callers, questioned the seemingly endless supply of cows and chickens for food. Jerry then reported on the Yankees' loss to the Red Sox, despite two homers from Aaron Judge, and the Mets' sweep of the Rockies, featuring two home runs each from Pete Alonso and Jeff McNeil. The segment concluded with discussions about Aaron Rodgers seemingly being the Steelers' third-choice and Jaxson Dart's slim chances of playing this year, alongside more calls about American burger consumption. Hour 3 Bad Weather Fans' post about no new "Roommates" podcast sparked Gio's observation that no Knicks players or management have commented on Thibs' firing. This silence, he reasoned, allows for rampant speculation, aligning with the Knicks' history of firing coaches still under contract. Jerry then updated the sports news: Boston hit five homers to beat the Yankees, despite two from Aaron Judge; Pete Alonso's two home runs helped the Mets sweep the Rockies, pushing him past David Wright on the Mets' all-time list; and the Thunder evened their series with the Pacers at 1-1. The hour concluded with more discussion about American hamburger consumption and the theory that James Dolan fired Thibs after sitting in on player interviews. Hour 4 Boomer and Gio's planned boat day was thwarted by bad weather, leading them to consider golf instead. A caller deemed Derek Jeter the most "boring" athlete to interview. Before Jerry's final update, Boomer shared his new green drink from Chris Wragge's wife. Jerry then played audio of Jazz Chisholm's mic'd-up error. In sports, Aaron Judge hit two homers in a Yankees loss, while Jeff McNeil and Pete Alonso each hit two as the Mets swept the Rockies. The Giants' defensive coordinator wants his players to emulate pirates for turnovers, and the Thunder evened their series with the Pacers. The show concluded with a caller's story about a woman with E. coli in her sinuses and a discussion of potential Knicks coaching candidates.

When Pete Alonso re-signed with the Mets, we knew he'd have a chance to become the franchise's all-time homer leader this summer. And with two more Sunday, he passed David Wright for second and sits just nine HRs behind leader Darryl Strawberry. To learn more about listener data and our privacy practices visit: https://www.audacyinc.com/privacy-policy Learn more about your ad choices. Visit https://podcastchoices.com/adchoices

The Official Corporate Podcast of Antioch, The Apostolic Church

The Official Corporate Podcast of Antioch, The Apostolic Church

The Official Corporate Podcast of Antioch, The Apostolic Church

The Official Corporate Podcast of Antioch, The Apostolic Church

The Official Corporate Podcast of Antioch, The Apostolic Church

The Official Corporate Podcast of Antioch, The Apostolic Church

Today's 13-5 Mets win was a team effort, but Alonso made history with his 242nd and 243rd career homers. Hear Pete's reaction to passing David Wright for 2nd place in franchise history.

Campaigners are calling for the ingredients of sourdough to be laid out in law. So are there too many loaves on sale that are more sourfaux than sourdough? Leyla Kazim investigates.This programme features a visit to the Batch event at the Long Table in Stroud to meet baker and author David Wright as well as Chris Young from the Real Bread Campaign. Nutritionist Dr Vanessa Kimbell discusses how sourdough impacts on our gut health and bread historian Professor Steven Kaplan chews over whether more regulation is strictly necessary and questions how it would be enforced.Cereal scientist Stanley Cauvain shines a light on a huge moment in British baking - the invention of the Chorleywood process - and Jules Chambe from the award-winning Wild Frog Bakehouse in Oxfordshire looks to his native France where the government did act to protect the beloved baguette.Produced in Bristol by Robin Markwell for BBC Audio Featuring the "Happy Knocker-Upper" 1960s Mother's Pride television advert featuring Dusty Springfield

On this episode - Terry Collins welcomes former NY Met, from the 2015 NL Championship team, Michael Cuddyer. From Michael's friendship with David Wright which impacted both of their lives, to Michael's leadership as a Met, to presenting the first WWE championship belt to the player of the game, and announcing his retirement in a very non traditional way, Cuddyer shares inside stories from that time. Newest Mets Beat Writer from Newsday Laura Albanese joins us in the lead off and offers great analysis of the Mets Dodgers series, as well as shares stories of Met memories that shaped her early days. And she gives us a review of the Dodger Dog! We share the special on field presentation held on Memorial Day to a special Hero from Tunnel to Towers by the Siller family. And Mike Piazza was in the news this week - for an amazin moment on the Golf Course captured on video. Like and Subscribe to our channel: / @theterrycollinsshow Follow The Terry Collins Show: X: https://x.com/TerryCollins_10 Instagram: / terrycollins_10 Faceebook: https://www.facebook.com/profile.php?... Follow John Arezzi on X: ⁠⁠⁠⁠https://x.com/johnarezzi⁠⁠⁠⁠ Follow John Arezzi on Instagram: ⁠⁠⁠⁠ / ⁠⁠⁠⁠ Donate $11 a month to now help first responders, veterans and our military heroes. Go to Tunnel to Towers and help them do good: ⁠⁠⁠⁠https://t2t.org/⁠⁠⁠⁠ Host: Terry Collins Co-Host: John Arezzi Creative Director: Marsh Researcher - Dominic DiBiase Executive Producer: John Arezzi Learn more about your ad choices. Visit megaphone.fm/adchoices

The Extract process is the heart of Oracle GoldenGate 23ai, capturing data changes with precision. In this episode, Lois Houston and Nikita Abraham sit down with Nick Wagner, Senior Director of Product Management, to break down Extract's role, architecture, and best practices.   Learn how Extract works across different setups, from running on source databases to using a Hub model for greater flexibility. Additionally, understand how trail files, parameter files, and naming conventions impact performance.   Oracle GoldenGate 23ai: Fundamentals: https://mylearn.oracle.com/ou/course/oracle-goldengate-23ai-fundamentals/145884/237273 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode.

The "DAV Podcast: Her Service" dives into the largely untold stories of women's contributions during the American Revolutionary War. Host Jonathan Kaupanger, a self-proclaimed history "nerd," enthusiastically introduces listeners to Meg Bowersox, Manager of Gallery Interpretation at the Museum of the American Revolution. This episode highlights the lives of trailblazing figures like Deborah Sampson and Hannah Snell, who disguised themselves as men to enlist, exploring their motivations, challenges, and the societal context of their actions. Beyond these recognized veterans, the podcast also delves into the "gray areas" of history, discussing the debated realities of other influential women such as the mysterious Agent 355, the formidable Nancy Morgan Hart, the all-female "Mrs. David Wright's Guard," and the intriguing wax sculptor and alleged spy, Patience Lovell Wright, encouraging listeners to seek out and celebrate the diverse contributions of women veterans throughout history.

Michael Cuddyer joins Jay Horwitz to reflect on the career of David Wright ahead of Wright's jersey retirement. From a fateful cafeteria moment in Virginia to their bond as Mets teammates, Cuddyer shares how Wright inspired his journey—and helped bring him to New York in 2015. They dive deep into the Home Run Derby at Citi Field, the 2015 postseason run, mentoring Michael Conforto, Daniel Murphy's October dominance, and the legendary Championship Belt. Plus: why Cuddyer walked away from the game and how he stays involved in baseball today. An emotional, honest, and often hilarious look back at a pivotal friendship in Mets history.

Installing Oracle GoldenGate 23ai is more than just running a setup file—it's about preparing your system for efficient, reliable data replication. In this episode, Lois Houston and Nikita welcome back Nick Wagner to break down system requirements, storage considerations, and best practices for installing GoldenGate.   You'll learn how to optimize disk space, manage trail files, and configure network settings to ensure a smooth installation.   Oracle GoldenGate 23ai: Fundamentals: https://mylearn.oracle.com/ou/course/oracle-goldengate-23ai-fundamentals/145884/237273 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode.   -------------------------------------------------------------   Episode Transcript: 00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started! 00:25 Nikita: Hello and welcome to Oracle University Podcast! I'm Nikita Abraham, Team Lead of Editorial Services with Oracle University, and I'm joined by Lois Houston, Director of Innovation Programs.  Lois: Hi there! Last week, we took a close look at the security strategies of Oracle GoldenGate 23ai. In this episode, we'll discuss all aspects of installing GoldenGate. 00:48 Nikita: That's right, Lois. And back with us today is Nick Wagner, Senior Director of Product Management for GoldenGate at Oracle. Hi Nick! I'm going to get straight into it. What are the system requirements for a typical GoldenGate installation? Nick: As far as system requirements, we're going to split that into two sections. We've got an operating system requirements and a storage requirements. So with memory and disk, and I know that this isn't the answer you want, but the answer is that it varies. With GoldenGate, the amount of CPU usage that is required depends on the number of extracts and replicats. It also depends on the number of threads that you're going to be using for those replicats. Same thing with RAM and disk usage. That's going to vary on the transaction sizes and the number of long running transactions. 01:35 Lois: And how does the recovery process in GoldenGate impact system resources?  Nick: You've got two things that help the extract recovery. You've got the bonded recovery that will store transactions over a certain length of time to disk. It also has a cache manager setting that determines what gets written to disk as part of open transactions. It's not just the simple answer as, oh, it needs this much space. GoldenGate also needs to store trail files for the data that it's moving across. So if there's network latency, or if you expect a certain network outage, or you have certain SLAs for the target database that may not be met, you need to make sure that GoldenGate has enough room to store its trail files as it's writing them. The good news about all this is that you can track it. You can use parameters to set them. And we do have some metrics that we'll provide to you on how to size these environments. So a couple of things on the disk usage. The actual installation of GoldenGate is about 1 to 1.5 gig in size, depending on which version of GoldenGate you're going to be using and what database. The trail files themselves, they default to 500 megabytes apiece. A lot of customers keep them on disk longer than they're necessary, and so there's all sorts of purging options available in GoldenGate. But you can set up purge rules to say, hey, I want to get rid of my trail files as soon as they're not needed anymore. But you can also say, you know what? I want to keep my trail files around for x number of days, even if they're not needed. That way they can be rebuilt. I can restore from any previous point in time. 03:15 Nikita: Let's talk a bit more about trail files. How do these files grow and what settings can users adjust to manage their storage efficiently? Nick: The trail files grow at about 30% to 35% of the generated redo log data. So if I'm generating 100 gigabytes of redo an hour, then you can expect the trail files to be anywhere from 30 to 35 gigabytes an hour of generated data. And this is if you're replicating everything. Again, GoldenGate's got so many different options. There's so many different ways to use it. In some cases, if you're going to a distributed applications and analytics environment, like a Databricks or a Snowflake, you might want to write more information to the trail file than what's necessary. Maybe I want additional information, such as when this change happened, who the user was that made that change. I can add specific token data. You can also tell GoldenGate to log additional records or additional columns to the trail file that may not have been changed. So I can always say, hey, GoldenGate, replicate and store the entire before and after image of every single row change to your trail file, even if those columns didn't change. And so there's a lot of different ways to do it there. But generally speaking, the default settings, you're looking at about 30% to 35% of the generated redo log value. System swap can fill up quickly. You do want this as a dedicated disk as well. System swap is often used for just handling of the changes, as GoldenGate flushes data from memory down to disk. These are controlled by a couple of parameters. So because GoldenGate is only writing committed activity to the trail file, the log reader inside the database is actually giving GoldenGate not only committed activity but uncommitted activity, too. And this is so it can stay very high speed and very low latency. 05:17 Lois: So, what are the parameters? Nick: There's a cache manager overall feature, and there's a cache directory. That directory controls where that data is actually stored, so you can specify the location of the uncommitted transactions. You can also specify the cache size. And there's not only memory settings here, but there's also disk settings. So you can say, hey, once a cache size exceeds a certain memory usage, then start flushing to disk, which is going to be slower. This is for systems that maybe have less memory but more high-speed disk. You can optimize these parameters as necessary. 05:53 Nikita: And how does GoldenGate adjust these parameters? Nick: For most environments, you're just going to leave them alone. They're automatically configured to look at the system memory available on that system and not use it all. And then as soon as necessary, it'll overflow to disk. There's also intelligent settings built within these parameters and within the cache manager itself that if it starts seeing a lull in activity or your traditional OLTP type responses to actually free up the memory that it has allocated. Or if it starts seeing more activity around data warehousing type things where you're doing large transactions, it'll actually hold on to memory a little bit longer. So it kinda learns as it goes through your environment and starts replicating data. 06:37 Lois: Is there anything else you think we should talk about before we move on to installing GoldenGate?  Nick: There's a couple additional things you need to think of with the network as well. So when you're deploying GoldenGate, you definitely want it to use the fastest network.  GoldenGate can also use a reverse proxy, especially important with microservices. Reverse proxy, typically we recommend Nginx. And it allows you to access any of the GoldenGate microservices using a single port.  GoldenGate also needs either host names or IP addresses to do its communication and to ensure the system is available. It does a lot of communication through TCP and IP as well as WSS. And then it also handles firewalls. So you want to make sure that the firewalls are open for ingress and egress for GoldenGate, too. There's a couple of different privileges that GoldenGate needs when you go to install it. You'll want to make sure that GoldenGate has the ability to write to the home where you're installing it. That's kind of obvious, but we need to say it anyways. There's a utility called oggca.sh. That's the GoldenGate Configuration Assistant that allows you to set up your first deployments and manage additional deployments. That needs permissions to write to the directories where you're going to be creating the new deployments. The extract process needs connection and permissions to read the transaction logs or backups. This is not important for Oracle, but for non-Oracle it is. And then we also recommend a dedicated database user for the extract and replicat connections. 08:15 Are you keen to stay ahead in today's fast-paced world? We've got your back! Each quarter, Oracle rolls out game-changing updates to its Fusion Cloud Applications. And to make sure you're always in the know, we offer New Features courses that give you an insider's look at all of the latest advancements. Don't miss out! Head over to mylearn.oracle.com to get started. 08:41 Nikita: Welcome back! So Nick, how do we get started with the installation?  Nick: So when we go to the install, the first thing you're going to do is go ahead and go to Oracle's website and download the software. Because of the way that GoldenGate works, there's only a couple moving parts. You saw the microservices. There's five or six of them. You have your extract, your replicat, your distribution service, trail files. There's not a lot of moving components. So if something does go wrong, usually it affects multiple customers. And so it's very important that when you go to install GoldenGate, you're using the most recent bundle patch. And you can find this within My Oracle Support. It's not always available directly from OTN or from the Oracle e-delivery website. You can still get them there, but we really want people going to My Oracle Support to download the most recent version. There's a couple of environment variables and certificates that you'll set up as well. And then you'll run the Configuration Assistant to create your deployments.  09:44 Lois: Thanks, Nick, for taking us though the installation of GoldenGate. Because these are highly UI-driven topics, we recommend that you take a deep dive into the GoldenGate 23ai Fundamentals course, available on mylearn.oracle.com. Nikita: In our next episode, we'll talk about the Extract process. Until then, this is Nikita Abraham… Lois: And Lois Houston signing off! 10:08 That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

Mike Piazza is in town and he met with Pat McCarthy to discuss what it's like to make an adjustment to a new clubhouse along with welcoming David Wright into Mets immortality with upcoming jersey retirement.

Living and Working in Spain with David Wright:The Ultimate Expat Guide Special guest today Josh Williams from Ambient wealth And Paul Burt from indalo transport Welcome to Living and Working in Spain with David Wright, your go-to hub for expert advice and practical resources tailored for expats. Whether you're planning your move to Spain or navigating life as a resident,David Wright offers the guidance you need to make your Spanish dream a reality. Visit DavidWrightOnline.com for exclusive insights and resources.   Exclusive Resources for Expats in Spain Unlock the benefits of David Wright's exclusive membership platform, where you'll find tailored advice on essential topics like:   Spanish Residency and Visas: Step-by-step guidance through the legal process. Employment Opportunities: Tips for finding work in Spain. Cultural Integration: How to blend seamlessly into Spanish society. Lifestyle Advice: Insider tips for a stress-free transition.Meet David Wright: Your Trusted Expat Mentor With over 23 years of experience living in Spain, David Wright is a trusted authority on expat life. As the author of six bestselling books on Amazon and Kindle, David's insights have been featured on platforms like BBC News and Channel 4's A Place in the Sun.  Through his expertise and vast network, David provides actionable guidance to both newcomers and long-term residents in Spain.   Listen to The Wright Way Live Radio Show Stay informed with The Wright Way, David Wright's live radio show on Almeria Radio 107.5 FM.   Every Friday at 4 PM (Spanish Time) Visa applications and tax planning Healthcare and cultural adaptation Join the Expats in Spain Community Don't miss David's engaging podcasts and expert interviews. These episodes feature leading professionals discussing:  Legal advice for expats Strategies for adapting to life in Spain Tips for managing finances, healthcare, and more Special Thanks to my sponsors. Ambient wealth.com https://form.jotform.com/250341579296060 USTaxesSpain.com: Your go-to tax service for Americans living in Spain. IndaloTransport.com: Reliable transport services with free quotes available. Special thanks to GeckoGrafix for designing David's motorbike website. Salvador tax and legal Stay Updated on Social Media Follow David Wright for the latest updates and trending tips: #LivingInSpain #ExpatLifeSpain #DavidWright #SpanishResidency #BritishInSpain   Start your journey to living and working in Spain today with David Wright—your trusted guide for expat success.Become a supporter of this podcast: https://www.spreaker.com/podcast/living-in-spain-with-david-wright--4371936/support.

In our final conversation with Dr Margaret Toscano, we'll discuss the chapter in Sara Patterson's book, "The Sept 6 & the Struggle for the Soul of Mormonism." Margaret will discuss her and her husband Paul's reaction to Sara's descriptions of them in the book. Check out our conversation... https://youtu.be/LqxYh6QHY3E Don't miss our other conversations about the Sept Six: https://gospeltangents.com/mormon_history/sept-six/ Copyright © 2024 Gospel Tangents All Rights Reserved Beyond the Sept 6 More than two decades after the events known as the "Sept 6," Margaret Toscano offers a candid look back, reflecting on the pain of excommunication, the evolution of her personal beliefs, and how she and her husband, Paul Toscano, hope to be remembered beyond that defining moment. Margaret highlights what she feels Patterson's book misses about her and others' journeys since 2003. Toscano reveals that her 2003 interview, featured in the book, captured a time of significant pain. Being kicked out of one's church, even for someone who might not be a "Believer," is deeply painful, particularly when it's tied to one's heritage and family, a sentiment she notes is also true for others like David Wright. She is proud of her ability to navigate that pain and notes the documentation of it in the book is important. Contrary to advice she received to simply "walk away" from Mormonism to heal, Toscano felt compelled to stay engaged. She identifies as Mormon, distinguishing this from being LDS (a member of the LDS Church), and views it as her ethnicity and heritage. This identity is crucial to her, and she has continued to write, research, and discuss Mormon issues, currently working on a book about Heavenly Mother.. Over the past twenty years, Toscano's spiritual journey has evolved. While not a "true believing Mormon," she has reached a point where she can openly say she is a Believer on some level, a stance she felt ashamed of years ago. Her ideas of God are complex and not aligned with traditional Mormon views, but she believes in God, an afterlife, and the soul. She describes herself as a "skeptic believer," a person who doubts everything but has also had experiences that affirm her faith. Crucially, she feels able to claim her spirituality openly, something she couldn't do as easily two decades prior. She asserts that being a scholar and an intellectual is compatible with having faith. A major point of reflection for Toscano is the legacy she and Paul desire. They explicitly state they do not want the September Six to be the sole definition of who they were. Margaret doesn't want to be remembered "simply as a dissident," nor does Paul want to be remembered simply as one of the Sept 6. Toscano highlights that Paul's faith journey continued significantly after 2007, when the book reportedly leaves him having lost his faith. Paul has since "found his faith again," seeing himself as a Mormon Christian with a deep testimony of Jesus Christ, which informs his interpretation of the Book of Mormon and his extensive writing. Margaret is immensely proud of Paul's intellectual output, which includes some fifteen books—theology, memoir, novels, essays, and more. She wishes for him to be remembered primarily as a "man of Mormon letters," an important Mormon intellectual, and a brilliant writer. As for herself, Toscano hopes to be remembered as an important Mormon scholar and a beloved teacher at the University of Utah, emphasizing her continued work and care for the Mormon community. She underscores the importance of remembering and being remembered, noting her critique that the book overlooks the continued contributions and experiences of many involved in the 1993 events, including her own work and relationships since 2003. Toscano also touches on the changes she's observed in Mormon studies and at the Sunstone conference, where she was a frequent participant for decades..

GoldenGate 23ai takes security seriously, and this episode unpacks everything you need to know. GoldenGate expert Nick Wagner breaks down how authentication, access roles, and encryption protect your data.   Learn how GoldenGate integrates with identity providers, secures communication, and keeps passwords out of storage. Understand how trail files work, why they only store committed data, and how recovery processes prevent data loss.   Whether you manage replication or just want to tighten security, this episode gives you the details to lock things down without slowing operations.   Oracle GoldenGate 23ai: Fundamentals: https://mylearn.oracle.com/ou/course/oracle-goldengate-23ai-fundamentals/145884/237273 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode.   --------------------------------------------------------------   Episode Transcript: 00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started! 00:25 Lois: Hello and welcome to the Oracle University Podcast! I'm Lois Houston, Director of Innovation Programs with Oracle University, and with me is Nikita Abraham, Team Lead: Editorial Services.  Nikita: Welcome, everyone! This is our fourth episode on Oracle GoldenGate 23ai. Last week, we discussed the terminology, different processes and what they do, and the architecture of the product at a high level. Today, we have Nick Wagner back with us to talk about the security strategies of GoldenGate. 00:56 Lois: As you know by now, Nick is a Senior Director of Product Management for GoldenGate at Oracle. He's played a key role as one of the product designers behind the latest version of GoldenGate. Hi Nick! Thank you for joining us again. Can you tell us how GoldenGate takes care of data security? Nick: So GoldenGate authentication and authorization is done in a couple of different ways. First, we have user credentials for GoldenGate for not only the source and target databases, but also for GoldenGate itself. We have integration with third-party identity management products, and everything that GoldenGate does can be secured. 01:32 Nikita: And we must have some access roles, right? Nick: There's four roles built into the GoldenGate product. You have your security role, administrator, operator, and user. They're all hierarchical. The most important one is the security user. This user is going to be the one that provides the administrative tasks. This user is able to actually create additional users and assign roles within the product. So do not lose this password and this user is extremely important. You probably don't want to use this security user as your everyday user. That would be your administrator. The administrator role is able to perform all administrative tasks within GoldenGate. So not only can they go in and create new extracts, create new replicats, create new distribution services, but they can also start and stop them. And that's where the operator role is and the user role. So the operator role allows you to go in and start/stop processes, but you can't create any new ones, which is kind of important. So this user would be the one that could go in and suspend activity. They could restart activity. But they can't actually add objects to replication. The user role is really a read-only role. They can come in. They can see what's going on. They can look at the log files. They can look at the alerts. They can look at all the watches and see exactly what GoldenGate is doing. But they're unable to make any changes to the product itself. 02:54 Lois: You mentioned the roles are hierarchical in nature. What does that mean? Nick: So anything that the user role does can be done by the operator. Anything that the operator and user roles can do can be done by the administrator. And anything that the user, operator, and administrator roles do can be done by the security role. 03:11 Lois: Ok. So, is there a single sign-on available for GoldenGate? Nick: We also have a password plugin for GoldenGate Connections. A lot of customers have asked for integration with whatever their single sign-on utility is, and so GoldenGate now has that with GoldenGate 23ai. So these are customer-created entities. So, we have some examples that you can use in our documentation on how to set up an identity provider or a third-party identity provider with GoldenGate. And this allows you to ensure that your corporate standards are met. As we started looking into this, as we started designing it, every single customer wanted something different. And so instead of trying to meet the needs for every customer and every possible combination of security credentials, we want you to be able to design it the way you need it. The passwords are never stored. They're only retrieved from the identity provider by the plugin itself. 04:05 Nikita: That's a pretty important security aspect…that when it's time to authenticate a user, we go to the identity provider. Nick: We're going to connect in and see if that password is matching. And only then do we use it. And as soon as we detect that it's matched, that password is removed. And then for the extract and replicats themselves, you can also use it for the database, data source, and data target connections, as well as for the GoldenGate users. So, it is a full-featured plugin. So, our identity provider plugin works with IAM as well as OAM. These are your standard identity manager authentication methods. The standard one is OAuth 2, as well as OIDC. And any Identity Manager that uses that is able to integrate with GoldenGate. 04:52 Lois: And how does this work? Nick: The way that it works is pretty straightforward. Once the user logs into the database, we're going to hand off authentication to the identity provider. Once the identity provider has validated that user's identity and their credentials, then it comes back to GoldenGate and says that user is able to log in to either GoldenGate or the application or the database. Once the user is logged in, we get that confirmation that's been sent out and they can continue working through GoldenGate. So, it's very straightforward on how it works. There's also a nice little UI that will help set up each additional user within those systems. All the communication is also secured as well. So any communication done through any of the GoldenGate services is encrypted using HTTPS. All the REST calls themselves are all done using HTTPS as well. All the data protection calls and all the communication across the network when we send data across a distribution service is encrypted using a secure WebSocket. And there's also trail file encryption at the operating system level for data at REST. So, this really gives you the full level of encryption for customers that need that high-end security. GoldenGate does have an option for FIPS 140-2 compliance as well. So that's even a further step for most of those customers. 06:12 Nikita: That's impressive! Because we want to maintain the highest security standards, right? Especially when dealing with sensitive information. I now want to move on to trail files. In our last episode, we briefly spoke about how they serve as logs that record and track changes made to data. But what more can you tell us about them, Nick? Nick: There's two different processes that write to the trail files. The extract process will write to the trail file and the receiver service will write to the trail file. The extract process is going to write to the trail file as it's pulling data out of that source database. Now, the extract process is controlled by a parameter file, that says, hey, here's the exact changes that I'm going to be pulling out. Here's the tables. Here's the rows that I want. As it's pulling that data out and writing it to the trail files, it's ensuring that those trail files have enough information so that the replicat process can actually construct a SQL statement and apply that change to that target platform. And so there's a lot of ways to change what's actually stored in those trail files and how it's handled. The trail files can also be used for initial loads. So when we do the initial load through GoldenGate, we can grab and write out the data for those tables, and that excludes the change data. So initial loads is pulling the data directly from the tables themselves, whereas ongoing replication is pulling it from the transaction logs. 07:38 Lois: But do we need to worry about rollbacks? Nick: Our trail files contain committed data only and all data is sequential. So this is two important things. Because it contains committed data only, we don't need to worry about rollbacks. We also don't need to worry about position within that trail file because we know all data is sequential. And so as we're reading through the trail file, we know that anything that's written in a prior location in that trial file was committed prior to something else. And as we get into the recovery aspects of GoldenGate, this will all make a lot more sense. 08:13 Lois: Before we do that, can you tell us about the naming of trail files? Nick: The trail files as far as naming, because these do reside on the operating system, you start with a two-letter trail file abbreviation and then a nine-digit sequential value. So, you almost look at it as like an archive log from Oracle, where we have a prefix and then an affix, which is numeric. Same kind of thing. So, we have our two-letter, in this case, an ab, and then we have a nine-digit number. 08:47 Transform the way you work with Oracle Database 23ai! This cutting-edge technology brings the power of AI directly to your data, making it easier to build powerful applications and manage critical workloads. Want to learn more about Database 23ai? Visit mylearn.oracle.com to pick from our range of courses and enroll today! 09:12 Nikita: Welcome back! Ok, Nick. Let's get into the GoldenGate recovery process. Nick: When we start looking at the GoldenGate recovery process, it essentially makes GoldenGate kind of point-in-time like. So on that source database, you have your extract process that's going to be capturing data from the transaction logs. In the case of Oracle, the Oracle Database is actually going to be reading those transaction logs from us and passing the change records directly to GoldenGate. We call them an LCR, Logical Change Record. And so the integrated extract and GoldenGate, the extract portion tells the database, hey, I'm now going to be interested in the following list of tables. And it gives a list of tables to that internal component, the log mining engine within the database. And it says, OK, I'm now pulling data for those tables and I'm going to send you those table changes. And so as the extract process gets sent those changes, it's going to have checkpoint information. So not only does it know where it was pulling data from out of that source database, but what it's also writing to the trail file. The trail files themselves are all sequential and they have only committed data, as we talked about earlier. The distribution service has checkpoint information that says, hey, I know where I'm reading from in the previous trail file, and I know what I've sent across the network. The receiver service is the same thing. It knows what it's receiving, as well as what it's written to the trail file and the target system. The replicat also has a checkpoint. It knows where it's reading from in the trail file, and then it knows what it's been applying into that target database.  This is where things start to become a little complicated. Our replicat process in most cases are parallel, so it'll have multiple threads applying data into that target database. Each of those threads is applying different transactions. And because of the way that the parallelism works in the replicat process, you can actually get situations where one replicat thread might be applying a transaction higher than another thread. And so you can eliminate that sequential or serial aspect of it, and we can get very high throughput speeds to the replicat. But it means that the checkpoint needs to be kind of smart enough to know how to rebuild itself if something fails. 11:32 Lois: Ok, sorry Nick, but can you go through that again? Maybe we can work backwards this time?  Nick: If the replicat process fails, when it comes back up, it's going to look to its checkpoint tables inside that target database. These checkpoint tables keep track of where each thread was at when it crashed. And so when the replicat process restarts, it goes, oh, I was applying these threads at this location in these SCNs. It'll then go and read from the trail file and say, hey, let me rebuild that data and it only applies transactions that it hasn't applied yet to that target system. There is a synchronized replicat command as well that will tell a crashed replicat to say, hey, bring all your threads up to the same high watermark. It does that process automatically as it restarts and continues normal replication. But there is an option to do it just by itself too. So that's how the replicat kind of repairs and recovers itself. It'll simply look at the trail files. Now, let's say that the replicat crashed, and it goes to read from the trail files when it restarts and that trail profile is missing. It'll actually communicate to the distribution, or excuse me, to the receiver service and say, hey, receiver service, I don't have this trail file. Can you bring it back for me? And the receiver service will communicate downstream and say, hey, distribution service, I need you to resend me trail find number 6. And so the distribution service will resend that trail file so that the replicat can reprocess it. So it's often nice to have redundant environments with GoldenGate so we can have those trail files kind of around for availability. 13:13 Nikita: What if one of these files gets corrupted? Nick: If one of those trail files is corrupt, let's say that a trail file on the target site became corrupt and the replicat can't read from it for one reason or another. Simply stop the replicat process, delete the corrupt trail file, restart the replicat process, and now it's going to rebuild that trail file from scratch based on the information from the source GoldenGate environment. And so it's very recoverable. Handles it all very well. 13:40 Nikita: And can the extract process bounce back in the same way? Nick: The extract process can also recover in a similar way. So if the extract process crashes, when it restarts itself, there's a number of things that it does. The first thing is it has to rebuild any open transactions. So it keeps all sorts of checkpoint information about the oldest transaction that it's keeping track of, any open transactions that haven't been committed, and any other transactions that have been committed that it's already written to the trail file. So as it's reprocessing that data, it knows exactly what it's committed to trail and what hasn't been committed. And there's a number of ways that it does this.  There's two main components here. One of them is called bounded recovery. Bounded recovery will allow you to set a time limit on transactions that span a certain length of time that they'll actually get flushed out to disk on that GoldenGate Hub. And that way it'll reduce the amount of time it takes GoldenGate to restart the extract process. And the other component is cache manager. Cache manager stores uncommitted transactions. And so it's a very elegant way of rebuilding itself from any kind of failure. You can also set up restart profiles so that if any process does crash, the GoldenGate service manager can automatically restart that service an x number of times across y time span. So if I say, hey, if my extract crashes, then attempt to restart it 100 times every 5 seconds. So there's a lot of things that you can do there to make it really nice and automatic repair itself and automatically resilient.  15:18 Lois: Well, that brings us to the end of this episode. Thank you, Nick, for going through the security strategies and recovery processes in such detail. Next week, we'll look at the installation of GoldenGate. Nikita: And if you want to learn more about the topics we discussed today, head over to mylearn.oracle.com and take a look at the Oracle GoldenGate 23ai Fundamentals course. Until next time, this is Nikita Abraham… Lois: And Lois Houston signing off! 15:44 That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

Tune in to a selection of originals, throwbacks, and remixes from the 90s on, featuring uptempo Hip-Hop, Latin, R&B, Dancehall, and everything in between. ---------- Follow David Wright ◊ https://soundcloud.com/david-jamaal-wright ◊ https://www.instagram.com/davidjwright_/ ---------- Follow MSYH.FM » http://MSYH.FM » http://x.com/MSYHFM » http://instagram.com/MSYH.FM » http://facebook.com/MSYH.FM » http://patreon.com/MSYHFM ---------- Follow Make Sure You Have Fun™ ∞ http://MakeSureYouHaveFun.com ∞ http://x.com/MakeSureYouHave ∞ http://instagram.com/MakeSureYouHaveFun ∞ http://facebook.com/MakeSureYouHaveFun ∞ http://youtube.com/@MakeSureYouHaveFun ∞ http://twitch.tv/@MakeSureYouHaveFun

This week, we're at the Balmoral Show with a panel of guests talking about what's happening in the different sections. Also, we chat about the big issues in Northern Ireland with David Wright, Aidan Brennan and Colin Kelly CEO of Lakeland Dairies Hosted on Acast. See acast.com/privacy for more information.

David Wright spoke at press conference earlier today.

In this episode, Lois Houston and Nikita Abraham, along with Nick Wagner, focus on GoldenGate's terminology and architectural evolution.   Nick defines source and target systems, which are crucial for data replication, and then moves on to explain the data extraction and replication processes.   He also talks about the new microservices architecture, which replaces the classic architecture, offering benefits like simplified management, enhanced security, and a user-friendly interface. Nick highlights how this architecture facilitates easy upgrades and provides a streamlined experience for administrators.   Oracle GoldenGate 23ai: Fundamentals: https://mylearn.oracle.com/ou/course/oracle-goldengate-23ai-fundamentals/145884/237273 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode.   ---------------------------------------------------------------   Episode Transcript:   00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started! 00:25 Nikita: Welcome to the Oracle University Podcast! I'm Nikita Abraham, Team Lead of Editorial Services with Oracle University, and with me is Lois Houston: Director of Innovation Programs. Lois: Hi there! Thanks for joining us again as we make our way through Oracle GoldenGate 23ai. Last week, we discussed all the new features introduced in 23ai and today, we'll move on to the terminology, the different processes and what they do, and the architecture of the product at a high level. 00:56 Nikita: Back with us is Nick Wagner, Senior Director of Product Management for Oracle GoldenGate. Hi Nick! Let's get into some of the terminology. What do we actually call stuff in GoldenGate? Nick: Within GoldenGate, we have our source systems and our target systems. The source is where we're going to be capturing data from, the targets, where we're going to be applying data into. And when we start talking about things like active-active or setting up GoldenGate for high availability, where your source can also be your target, it does become a little bit more complex. And so in some of those cases, we might refer to things as East and West, or America and Europe, or different versions of that. We also have a couple of different things within the product itself. We have what we call our Extract and our Replicat. The Extract is going to be the process that pulls the data out of the database, our capture technology. Our Replicat's going to be the one that applies the data into the target system, or you can also look at it as a push technology. We have what we call our Distribution Path. Our Distribution Path is going to be how we're sending the data across the network. A lot of times when customers run GoldenGate, they don't have the luxury of just having a single server of GoldenGate that can pull data from one database and push data into another one. They need to set up multiple hops of that data. And so in that case, we would use what we call a Distribution Path to send that data from one system to the next. We also have what we call a Target Initiated Path. It's kind of a subset of your Distribution Path, but it allows you to communicate from a less secure environment into a more secure environment.  02:33 Lois: Nick, what about parameter names. I've seen them in uppercase…title case…does that matter?  Nick: GoldenGate has a lot of parameters. This is something you'll see all over the place within GoldenGate itself.  These parameters are in your Extract and Replicat parameter files during your distribution path parameter files. Parameters for GoldenGate are case insensitive.  Within your own environments, you can set it up to have lowercase, mixed case, whatever you want, but just be aware that they are case insensitive. GoldenGate doesn't care, it's just for readability. And then we also have something called trail files. Trail files is where GoldenGate stores all the data before we're able to apply it into that target system. Think about it as our queuing mechanism, and we're queuing everything outside the database so that we're not overloading those database environments. And that's some of the terminology for the product itself. We also have microservices within GoldenGate. 03:31 Nikita: And at the heart of everything is the Service Manager, right? Talk to us about what it is and what it does. Nick: The service manager is responsible for making sure that everything else is up and running. If you are familiar with GoldenGate classic architecture, this is kind of similar to a GoldenGate manager where that process was there to make sure that processes were running the trail files, or excuse me, that certain error logs were getting written out. If a process went down, the manager would restart that process. The service manager is performing a lot of those same functions. Now attached to the service manager, we have our configuration service. This is new in GoldenGate 23ai. This configuration service is going to allow you to set up GoldenGate for highly available environments. So you can build HA into GoldenGate itself using the configuration service. 04:22 Lois: And what does this configuration service do? Nick: This configuration service essentially moves the checkpoint files that used to be on disk into a database so that everything can be stored inside of a database.  Also attached to the service manager, we have the performance metric service. This is a service that is going to be gathering all the performance metrics of GoldenGate. So it's going to tell you how fast things are going, what the latencies are, how many bytes per second we're reading from, the transaction logs or writing to our trail files. How quickly a distribution path is sending data across a network. If you want to know any of your lag information, you'll get it from the performance metrics server. We also have the receiver service and the distribution service. These two work hand in hand to establish network communication between two GoldenGate environments. So on what we call our source system, we have a distribution service that's going to send the data to our target system. On the target system, a receiver service is going to receive that data and then rewrite the trail files. We also have the administration service that's responsible for authentication and authorization of the users, as well as making sure that people have access to the right information. 05:33 Nikita: Ok. Moving on the deployment, how is GoldenGate actually deployed, Nick? Nick: GoldenGate is kinda nice. So the way that the product is installed is you install the GoldenGate environment and that's what we call our service manager deployment under a specific GoldenGate home. So the software binaries themselves get installed under a home, we'll say U01/OGG23AI. Now once I've installed GoldenGate once, that's my OGG home. I can now have any number of service managers and deployments tied to that same home.  06:11 Lois: Ok, let's work with an example to make this simpler. Let's say I've got a service manager that's going be responsible for three different deployments: Accounting, Finance, and Sales. Nick: Each of these deployments is going to reside in its own directory. Each of these deployments is going to have its own set of microservices. And so this also means that each of these deployments can have their own set of users. So the people that access the GoldenGate accounting deployment can be different than the ones that access the sales deployment. This means with this distribution of roles that I can have somebody come in and administer the sales database, but they wouldn't have any information or any access to accounting or finance. And this is very important, it allows you to really pull that information apart and separate it. Each of these environments also has their own set of parameter files, Extract process, Replicat process, distribution services, and everything. So it's a very nice way of splitting things up, but all having them tied to the same GoldenGate home system. And this home is very important. So I can take a deployment, let's say my finance deployment, and if I want to move it to a new GoldenGate home and that GoldenGate home is a different version, like let's say that my original home is 23.4, my new GoldenGate home is 23.7, I simply stop that GoldenGate deployment. I stopped at a finance deployment. I changed its OGG home from 23.4 to 23.7. I restart the deployment, that deployment is automatically upgraded to the new environment and attached to the new system. So it makes upgrading very, very simple, very easy, very elegant. 07:53 Nikita: Ok. So, we've spoken about the services…some of the terminology. Let's get into the architecture next. Nick: So when we talk about the architecture for GoldenGate, we used to have two different architectures. We had a classic architecture and a microservices architecture. Classic architecture was something that's been around since the very beginning of GoldenGate in the late '90s. We announced that, that architecture was deprecated in 19c. And Oracle deprecated means that feature is no longer going to be enhanced and it'll be patched selectively. And at some point in the future, it'll be entirely desupported. Well, GoldenGate 23ai is that future. And so in 23ai, the classic architecture is desupported, that means that it's no longer in the build at all. And so it's just microservices architecture. 08:41 Lois: Is there a tool to assist with this migration?  Nick: We do have a migration utility that will convert an old classic architecture into the new microservices architecture. But there is quite a bit of learning curve to the new microservices architecture. So it's important that we go through how it works in the changes. 09:04 Are you looking to optimize your implementation strategies and improve efficiency? We have a solution for you! Our new Oracle Fusion Cloud Applications Foundations training and certification program. You'll learn to leverage Oracle Modern Best Practice (OMBP) to re-imagine business processes using advanced technologies in Oracle Fusion Cloud Applications such as AI, mobile, analytics, and more. Visit mylearn.oracle.com to get started today.  09:37 Nikita: Welcome back! Nick, what are the benefits of this microservices architecture?  Nick: It's got that simplified lifecycle for patching and upgrading. A lot of the GoldenGate patches that you get, especially these bundle patches, are complete installs as well. So you can go into My Oracle Support and download a complete install of a patch and that way, you don't have to use old patch to apply them. The only time you'll be using old patch is for one-off patches or smaller patches that need to be applied to your GoldenGate system. The microservices product has the same trusted Capture and Apply process that Classic did. There's almost no changes between the two except on how they communicate with their parent processes. And so the same logic that you use to pull data from Oracle or to apply data into Oracle is all the same. 10:25 Lois: And has the interface been upgraded as well? Nick: We've added a really nice, easy to use web interface for the microservices version of GoldenGate. Not only is this web interface work with all your standard browsers, but it's also mobile friendly too. So I can actually control and administer GoldenGate right through my mobile device. It also has new secure remote administration. This is something that the classic architecture was really missing. And so in the classic architecture, to use the command line interface, you had to log into the database server where GoldenGate was installed. Now, the command line interface, as well as the web interface and the REST API, all use remote administration and authentication. So that means that I can install the new command line interface or what we call admin client on my laptop locally and I can connect to any GoldenGate deployment as long as I have the username and password for that deployment. It's also more secure. GoldenGate microservices can also be deployed on premise or in OCI as a service and now also on these third-party clouds like Azure and Google Cloud. And it's also easier for developers to integrate in with the APIs themselves. Everything that GoldenGate does through the admin client as well as the web UI can all be traced. The REST API calls for GoldenGate are all fully published so you can get them right directly from the documentation, you can build your own web interface if you want to. So it makes it very easy. The REST APIs are also streamlined. With a single REST API call, I can do something like add an Extract process, create it, set up my parameter file, and set up the trail files all with a single API command. Whereas in the past, it would require multiple command line interface commands to do that same thing. So it's extremely elegant, very advanced. 12:16 Nikita: What does the microservices architecture look like? I know it's a bit complicated when we're not actually looking at a diagram of it, but just a high level, can you explain the different parts of it? Nick: It's pretty straightforward. But essentially what you've got on each system is a service manager. That service manager is then going to have a number of processes or services beneath it. It'll have the configuration service that stores the checkpoint information for GoldenGate. It'll have the administrative service for the authentication and users, the distribution service to send the data across a network, a receiver service to receive that information, performance metrics to get the performance statistics out of GoldenGate. And then of course, you also have your Extracts and Replicats that capture and apply technology. Each of those Extracts and Replicats will then connect to a database on the Extract side of things. That Extract is going to write to trail files. Those trail files are then going to be sent across the network where they're rebuilt on the target system and the Replicat's going to consume them and apply them into the target database. So the Replicat behaves almost like an end user. So it's taking that trail file data and simply converting it to DML operations, insert, update, delete, or a DDL operation in the case of Oracle, alter table, create table, et cetera, to go into that target database.   13:39 Lois: To look at a diagram of this architecture and learn about it in more detail, check out the Oracle GoldenGate 23ai Fundamentals course on mylearn.oracle.com. So, Nick, if I'm looking to deploy GoldenGate, what should I primarily keep in mind? Nick: So as you go to install GoldenGate and you look at a deployment, there's a couple of important environment variables that you want to make sure you're aware of. So one of the first ones is your OGG_Home. This environment variable is extremely important. This is the location of the GoldenGate software itself. And I want to stress how important it is to always use version numbers when you're setting up your GoldenGate home. When you go to install the software, if you're installing GoldenGate 23.5, use 23.5 within the home directory structure. If you're installing GoldenGate 23.7, use 23.7 inside that directory structure. 14:33 Nikita: Right… that way I'll always know which versions are which, and it'll make it really easy to upgrade and move from one version to the next. Ok, got it. What else, Nick? Nick: There's a couple other important directories. You have your OGG_ETC_HOME. This is where things like the configuration files are going to reside, parameter files, all your certificates for security, including the wallets where we store the credentials for not only the database accounts, but also for the GoldenGate user accounts as well. We have our GoldenGate variable home directory or VAR home. This is where all the GoldenGate log files are residing. And these are the log files that allow you to see what's going on in GoldenGate for auditing purposes. Anytime anybody makes a change to GoldenGate, you're going to see information go into the log files on what was happening and how it was working and what they did, what time they did, what command they issued. Another big important feature about these log files is it also gives you error information and troubleshooting details. So if you ever need to find out what happened in GoldenGate, what went wrong, you would look at these log files to find out that information. And then you also have your OGG_DATA_HOME. This is where those trail files are going to go. Essentially, this is kind of the queuing or overflow for GoldenGate. There's a couple of other additional components. We've got the admin client. This is our command line utility. If you don't want to use a web browser or prefer a command line utility, you can use the admin client. The admin client is also fully scriptable. So if you wanted to write scripts that would go off and automate things in GoldenGate, you can do that. A lot of customers did that with GGSCI in the classic architecture. You can do the same thing now with the admin client. The other component is the microservices security authentication and authorization services. These handle communication security, especially making sure that any passwords or usernames and everything like that is all encrypted. And instead of using an actual username and password, everything through the product is going to be done through an alias. And then it also handles all the authorization authentication, permissions, user accountability, and roles within GoldenGate. 16:39 Lois: Anything else you'd like to talk about before we wrap up for today, Nick? Nick: I also wanted to take a minute to talk about the REST API. All the microservices provide REST APIs to administer them and all of these are fully documented. They can be used by any client that can make REST API calls. So if you wanted to use Python, cURL, a web browser, you can do that as well. They're all just HTTP or HTTPS calls, get, put, patch, the standard REST API standards. And then GoldenGate does provide our admin client as well as a WebUI that use these REST APIs under the covers if you ever wanted to get a more advanced look at how it works. 17:18 Nikita: Well, that's all the time we have for today. Thanks for joining us, Nick.  Lois: Yes, thanks Nick. We look forward to having you back next week to talk with us about security strategies and data recovery. Nikita: And if you want to learn more about the topics we discussed today, head over to mylearn.oracle.com and take a look at the Oracle GoldenGate 23ai Fundamentals course. Until next time, this is Nikita Abraham… Lois: And Lois Houston, signing off!  17:43 That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

Living and Working in Spain with David Wright:The Ultimate Expat Guide Special guest today Josh Williams from Ambient wealth And Paul Burt from indalo transportWelcome to Living and Working in Spain with David Wright,your go-to hub for expert advice and practical resources tailored for expats. Whether you're planning your move to Spain or navigating life as a resident,David Wright offers the guidance you need to make your Spanish dream a reality. Visit DavidWrightOnline.com for exclusive insights and resources.  Exclusive Resources for Expats in Spain Unlock the benefits of David Wright's exclusive membership platform, where you'll find tailored advice on essential topics like:  Spanish Residency and Visas: Step-by-step guidance through the legal process. Employment Opportunities: Tips for finding work in Spain. Cultural Integration: How to blend seamlessly into Spanish society. Lifestyle Advice: Insider tips for a stress-free transition. Meet David Wright: Your Trusted Expat Mentor With over 23 years of experience living in Spain, David Wright is a trusted authority on expat life. As the author of six bestselling books on Amazon and Kindle,David's insights have been featured on platforms like BBC News and Channel 4's A Place in the Sun.   Through his expertise and vast network, David provides actionable guidance to both newcomers and long-term residents in Spain.  Listen to The Wright Way Live Radio Show Stay informed with The Wright Way, David Wright's live radio show on Almeria Radio 107.5 FM.    Every Friday at 4 PM (Spanish Time) Visa applications and tax planning Healthcare and cultural adaptation Join the Expats in Spain Community Don't miss David's engaging podcasts and expert interviews.These episodes feature leading professionals discussing:   Legal advice for expats Strategies for adapting to life in Spain Tips for managing finances, healthcare, and moreSpecial Thanks to my sponsors. Ambient wealth.com https://form.jotform.com/250341579296060 USTaxesSpain.com: Your go-to tax service for Americans living in Spain. IndaloTransport.com: Reliable transport services with free quotes available. Special thanks to GeckoGrafix for designing David's motorbike website. Salvador tax and legal Stay Updated on Social Media Follow David Wright for the latest updates and trending tips: #LivingInSpain #ExpatLifeSpain #DavidWright #SpanishResidency #BritishInSpain   Start your journey to living and working in Spain today with David Wright—your trusted guide for expat success.Become a supporter of this podcast: https://www.spreaker.com/podcast/living-in-spain-with-david-wright--4371936/support.

Matty Dalrymple talks with Johnny B. Truant about THE NEW NORMAL OF AN AUTHOR CAREER, including the evolving landscape of self-publishing, the dilemma of comparisonitis, the need to accept slow growth in one's author career as the new norm, the value of patience, and the warning signs when patience turns into a rut.    Interview video at https://bit.ly/TIAPYTPlaylist  Show notes at https://www.theindyauthor.com/podcast.html    If you find the information in this video useful, please consider supporting The Indy Author! https://www.patreon.com/theindyauthor https://www.buymeacoffee.com/mattydalrymple   Johnny B. Truant is the bestselling author of FAT VAMPIRE, adapted by The SyFy Network as REGINALD THE VAMPIRE. His other books include PRETTY KILLER, GORE POINT, INVASION, THE BEAM, DEAD CITY, UNICORN WESTERN, and over 100 other titles across many genres. Johnny is one of indie publishing's early authorities, having created and co-hosted the original Self-Publishing Podcast with Sean Platt and David Wright. He is also the author of the indie cornerstone guide WRITE. PUBLISH. REPEAT., and hosted the Smarter Artist Summit author conference in Austin, Texas from 2015-2018 with the same two partners.   Matty Dalrymple is the author of the Lizzy Ballard Thrillers, beginning with ROCK PAPER SCISSORS; the Ann Kinnear Suspense Novels, beginning with THE SENSE OF DEATH; and the Ann Kinnear Suspense Shorts. She is a member of International Thriller Writers and Sisters in Crime. Matty also writes, speaks, and consults on the writing craft and the publishing voyage, and shares what she's learned on THE INDY AUTHOR PODCAST. She has written books on the business of short fiction and podcasting for authors; her articles have appeared in "Writer's Digest" magazine. She serves as the Campaigns Manager for the Alliance of Independent Authors.  

Stratford Point Light Station in 2015, photo by Jeremy D'Entremont David Wright Stratford, Connecticut, was an active port in coastal trade, shipbuilding and oystering in the eighteenth and nineteenth centuries. To mark the entrance to the harbor, the first Stratford Point Lighthouse was built on the west side of the dangerous mouth of the Housatonic River in 1822. The present tower, 35 feet tall, was built along with a new keeper's house in 1881. Theodore of "Theed" Judson was keeper from 1880 to 1921. In his more than 40 years at Stratford Point, Judson frequently made the local newspapers with sightings of sea monsters and mermaids. The light station is still owned by the Coast Guard, but the town of Stratford holds occasional open houses for the public. Our guest in this episode, David Wright, is the Stratford town historian. He gives walking tours and writes articles about local history. When the lighthouse is open, David takes on the identity of Keeper Theodore Judson while his wife portrays the keeper's wife, Kate.

Johnny B. Truant shares his journey from aspiring writer to artisan author. Through his story, he reveals how creative discovery, authentic connections, and his definition of success shape his life. You'll take away his insights on compromise, true fans, and building a fulfilling creative career.Making It! explores the lives and stories of entrepreneurs as they share their unique perspectives on their success and the path to making it.“Evenings and weekends are for family now. Maybe I've seen too many movies about people missing opportunities with their kids until it's too late.”— Johnny B. TruantGuest Bio:Johnny B. Truant is one of indie publishing's early authorities, having created and co-hosted the original Self-Publishing Podcast with Sean Platt and David Wright. He is also the author of the indie cornerstone guide Write. Publish. Repeat, and hosted the Smarter Artist Summit author conference in Austin, Texas from 2015-2018 with the same two partners.On the fiction side, Johnny is the bestselling author of Fat Vampire, adapted by The SyFy Network as Reginald the Vampire. His other books include Pretty Killer, Gore Point, Invasion, The Beam, Dead City, Unicorn Western, and more than 100 other titles across many genres.Originally from Ohio, Johnny and his family now live in Austin where he's finally surrounded by creative types as weird as he is.Resources or websites mentioned in this episode:MiraseeJohnny's website: JohnnyBTruant.comCredits:Producer: Michi LantzEditor: Michi LantzAudio Editor: Marvin del RosarioExecutive Producer: Danny InyMusic Soundscape: Chad Michael SnavelyMaking our hosts sound great: Home Brew AudioMusic credits:Track Title: The Sunniest KidsArtist Name: Rhythm ScottWriter Name: Scott RoushPublisher Name: A SOUNDSTRIPE PRODUCTIONTrack Title: Sweet Loving WaltzArtist Name: Sounds Like SanderWriter Name: S.L.J. KalmeijerPublisher Name: A SOUNDSTRIPE PRODUCTIONTrack Title: Elven ForestArtist Name: HartzmannLicense code: MLYEF5IN9BJ4AE9FPublisher Name: UppbeatTrack Title: Brave New WorldArtist Name: Simon FolwarLicense code: UWKSFWJ6ZJZUXWITPublisher Name: UppbeatTrack Title: Wild DaisyArtist Name: AVBELicense code: YT3FYWBTSD4YH7D2Publisher Name: UppbeatSpecial effects credits:24990513_birds-chirping_by_promission used with permission of the author and under license by AudioJungle/Envato Market.To catch the great episodes coming up on Making It, please follow us on Mirasee FM's YouTube channelor your favorite podcast player. And if you enjoyed the show, please leave us a comment or a starred review. It's the best way to help us get these ideas to more people.Episode transcript: How This Solopreneur Found Success by Ditching the Rules (Johnny B. Truant)  coming soon.

This week Andrew talks with former MLB manager Terry Collins. Over the course of his career, Terry managed the Houston Astros, Anaheim Angels, & eventually Andrew's beloved New York Mets. Andrew is a lifelong Mets fan — and Terry is Andrew's favorite Mets manager of all-time. During Terry's tenure as Mets manager, he led with passion, showed an unbreakable loyalty to his players, & presided over some of the most memorable moments in team history. In addition, every night at his post-game press conference — win or lose — Terry was honest, authentic, & showed everyone how much he cared. In this conversation, Andrew asks Terry all about his career & many of his most iconic moments as a leader. This episode is filled with timeless wisdom on leadership, teamwork, & success that applies far beyond baseball. ** Follow Andrew **Instagram: @AndrewMoses123Twitter/X: @andrewhmosesSign up for e-mails to keep up with the podcast at everybodypullsthetarp.com/newsletterDISCLAIMER: This podcast is solely for educational & entertainment purposes. It is not intended to be a substitute for the advice of a physician, psychotherapist, or other qualified professional.  

Taking the Artist's Edition Index from print to the spoken word. This month I discuss Industry Q&A (Dark Horse, April 2024, Graphitti Designs, April 2025, Rebellion, July 2024, David Roach, December 2022), Slingsby Bros, Ink! April 2025 Solicitations, New Release April 13, 2025, AE Index Poll April 2025, DC July 2025 Catalogue, IDW May 2025 Catalogue, AE Format Out of Print Sales March 2025, and reviews of David Wright's Carol Day Showcase, Blacksad: Les Crayonnés, Le Schtroumpfissime Artiste Édition, and Bat-Man: First Knight Artist's Edition.

In this emotional and wide-ranging conversation, Mets legend Darryl Strawberry sits down with Jay Horwitz to talk about Pete Alonso breaking Mets home run records, his new book "Another Life", visiting death row inmates in Louisiana, and what it really means to find purpose after baseball. Darryl also shares inside stories from the 1986 World Series, Mike Tyson visiting the Mets, and why David Wright's jersey retirement is so meaningful. Plus: advice for Juan Soto adjusting to New York and why the 1986 Mets are one of the most beloved teams in baseball history. Learn more about your ad choices. Visit megaphone.fm/adchoices

Cousin Sal is joined by David Wright to discuss his number being retired by the New York Mets before the D3 join to give out their best bets for Friday's NBA and NHL slate. Lastly, they discuss the best NFL draft moments of all time. Host: Cousin Sal Guests: David Wright, Darren Szokoli, Brian Szokoli, and Harry Gagnon Producers: Michael Szokoli, Joel Solomon, Jack Wilson, Chris Wohlers, Sirushi Witte, Jonathan Frias, Drew Van Steenbergen, Felipe Guilhermino, and Oscar De La Luz The Ringer is committed to responsible gaming, please visit theringer.com/RG to learn more about the resources and helplines available, and listen to the end of the episode for additional details. Learn more about your ad choices. Visit podcastchoices.com/adchoices

The Official Corporate Podcast of Antioch, The Apostolic Church

The Official Corporate Podcast of Antioch, The Apostolic Church

Andy Martino joins Jay Horwitz for a special episode of Amazin' Conversations to talk about what it really takes to break news in Major League Baseball. From cultivating authentic human relationships with players like Juan Soto and executives across front offices, to his journey from the Daily News to SNY insider coverage of the Mets and Yankees, Andy shares candid stories, media insights, and reflections on the evolution of baseball journalism. They dive into behind-the-scenes moments, including his connection to Shannon Forde's legacy, covering David Wright's career, and how Carlos Beltrán is helping shape today's Mets. If you've ever wondered how the biggest Mets scoops get reported — this one's for you.

The Official Corporate Podcast of Antioch, The Apostolic Church

The Official Corporate Podcast of Antioch, The Apostolic Church

David Wright Faladé joins Deborah Treisman to read and discuss “Lu, Reshaping,” by Madeleine Thien, which was published in The New Yorker in 2021. Falade is the author of the novels “Black Cloud Rising” and “The New Internationals,” and the nonfiction work “Fire on the Beach: Recovering the Lost Story of Richard Etheridge and the Pea Island Lifesavers.” He's been publishing fiction and nonfiction in The New Yorker since 2020. Learn about your ad choices: dovetail.prx.org/ad-choices