Oracle GoldenGate for Oracle over the last few releases have been moving towards an integrated architecture. This means that there is more views and tables within the Oracle Database that support Oracle GoldenGate. You can quickly find these views and tables by using a where clause with a filter for GoldenGate:
select * from all_views where view_name like ‘%GOLDENGATE%’;
select * from all_tables where table_name like ‘%GOLDENGATE%’;
When looking at the views, you can tell that there are views that allow you to look at container rules, inbound processing, privileges, rules, support_mode, messagetracking, and other interesting items. There are 29 views in all that can be referenced during processing and provide insight into what could be going on within a GoldenGate environment.
VIEW_NAME
-------------------------------------------------------------
ALL_GOLDENGATE_CONTAINER_RULES
ALL_GOLDENGATE_INBOUND
ALL_GOLDENGATE_PRIVILEGES
ALL_GOLDENGATE_RULES
CDB_GOLDENGATE_CONTAINER_RULES
CDB_GOLDENGATE_INBOUND
CDB_GOLDENGATE_NOT_UNIQUE
CDB_GOLDENGATE_PRIVILEGES
CDB_GOLDENGATE_RULES
CDB_GOLDENGATE_SUPPORT_MODE
DBA_GOLDENGATE_CONTAINER_RULES
DBA_GOLDENGATE_INBOUND
DBA_GOLDENGATE_NOT_UNIQUE
DBA_GOLDENGATE_PRIVILEGES
DBA_GOLDENGATE_RULES
DBA_GOLDENGATE_SUPPORT_MODE
GV_$GOLDENGATE_CAPABILITIES
GV_$GOLDENGATE_CAPTURE
GV_$GOLDENGATE_MESSAGETRACKING
GV_$GOLDENGATE_PROCEDURE_STATS
GV_$GOLDENGATE_TABLE_STATS
GV_$GOLDENGATE_TRANSACTION
USER_GOLDENGATE_PRIVILEGES
V_$GOLDENGATE_CAPABILITIES
V_$GOLDENGATE_CAPTURE
V_$GOLDENGATE_MESSAGE_TRACKING
V_$GOLDENGATE_PROCEDURE_STATS
V_$GOLDENGATE_TABLE_STATS
When you take a look at the tables, you will see that there are only two tables. These tables provide details on the rules applied to the container and the privileges assigned to the GoldenGate user.
TABLE_NAME
--------------------------------------------------------
GOLDENGATE$_CONTAINER_RULES
GOLDENGATE$_PRIVILEGES
In all, as of Oracle Database 19c, there are 31 table and views that can be used within the Oracle Database to help you administer Oracle GoldenGate.
I’ll get around to writing something up on individual views and/or tables, but for the moment this should provide a great starting point for you to gain an understanding of what is happening with a GoldenGate environment from within the database.
Enjoy!!!
Please follow and like:
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
Excellent site you have here.. It’s difficult to find high-quality writing like yours these days. I honestly appreciate individuals like you! Take care!!
Thank you for any other great post. Where else could anyone get that kind of info in such an ideal means of writing? I’ve a presentation subsequent week, and I am on the search for such info.
Excellent post! This was really informative for anyone looking to start a business. I came across several practical advice that I can implement in my personal enterprise. Cheers for providing such valuable content. Looking forward to checking out more content from you! Well done! To explore further insights on business growth, check out this informative guide: this link.
Excellent write-up! This is truly helpful for anyone aiming to establish a company. I came across many practical advice that I can apply in my personal startup. Thanks for sharing such great information. Can’t wait to reading more posts from you! Well done! To explore further insights on business growth, check out this great resource: this page.
Starting a business can be overwhelming, but with the right tutorial, you can streamline your launch. This comprehensive guide provides strategies on how to develop a successful company and overcome common obstacles. Check out this link for further details and to discover more about starting.a business.
Great entry. I found the details extremely beneficial. Loved the method you clarified the content.
It is a primary-particular person shooter because the action unfolds in real time, seen by means of the virtual eyes of your alter ego in the game world.
One good factor is that sure bail bonds don’t require the assistance of a bondsman.
Under QE, central banks typically purchase riskier and longer-term securities such as long maturity sovereign bonds and even corporate bonds.
But few folks know the unusual story behind the creation of Berkshire Hathaway, the global funding powerhouse.
The fine print likely suggests that the investor bears all risk associated with such offerings.
We stopped for some crepes at a cute little Creperie right exterior the trendy art museum.
Squadron Chief Francis Eustace Edmund Truscott (49714), Royal Air Drive; at current on loan to the federal government of Pakistan.
For those unfamiliar, WhatsApp is a tool that makes it handy and easy to assist Facebook additional its core mission: the optimization and auctioning of human conduct (colloquially often called “targeted advertising”).
Placed in the most prestigious areas of Crete, these deluxe villas provide the optimal environment for an remarkable vacation. Find your perfect escape.
That’s because the IRS requires administrators to withhold money from rollover distributions to help cover the taxes that may be owed on that money.
Treeck, Johanna (18 March 2014).
Nice article this is going to help my chinese mandarin tutoring service!
Going to use this for my SEO agency!
It’s always a good idea to visit an auto show if one is held in your area, because they present a rare opportunity to compare many makes and models side-by-side.
A number of other site of producing “Judean Glass” had been present in Galilee.
Usually the membranes are black, however manufacturers also make them in white, which is the best coloration for a cool roof.
Among the most common reasons for a company to go out of business is when creditors or clients fail to pay invoices and if the company has little margin to carry on and this happens with a big contract just one unpaid invoice can mean insolvency or even complete closure.
Thsi will help with my Google Entity Stacking service.
We sell a 3rd-party delicate begin module that may be added to just about any heat pump.
Feedback and Popularity Administration Instruments: These instruments acquire visitor feedback from various platforms and assist hotels monitor and respond to evaluations, which is essential for popularity administration.
The government poured some RMB4 trillion into the economy and native governments borrowed closely from banks to comprehend their development targets.
The brand new station contained eight individual telephone booths in the ready room, which gained a tile flooring.
Objects that do not enter your home in the primary place won’t wind up in a landfill as their last place.
People traded recipes and personal letters by fax rather than sending them in the mail.
George Vaux, “Settlers in Merion: The Harrison Household and Harriton Plantation,” The Pennsylvania Journal of History and Biography, vol.
Thsi will help with my Google Entity Stacking service.
The hospital system has greater than 600 pediatric beds at its four hospitals situated in Aurora, Colorado Springs, Highlands Ranch and Broomfield.
A designer can help you set up the initial designs, but in the event that designer is no longer around, you’ll also want to have guidelines about how new materials should be set up in order to blend with the old materials.
George Mason turned an prompt convert to the aero look, championing the enclosed wheels as a boldly modern feature — and a Nash unique.
The output of a French-owned cotton factory in Senegal counts as part of the Home figures for Senegal, however the National figures of France.
Don’t feel pressure to take out a loan, especially if it’s tied to enrollment.
You’ve just been put accountable for planning the corporate’s trade show activities for the yr and you don’t know where to begin.
Thsi will help with my Google Entity Stacking service.
On December 17, 1906, Joseph Spitz, a Councilman for the Fourth Ward of Passaic, introduced two resolutions at a gathering due to issues with the grade crossings of the Erie in town.
We did zero flic work till the very finish of the venture, and though the game appears to be like good, we left it to the tip to return and make a pass at consistency (getting the lighting and texturing excellent, and so on).
Thsi will help with my Google Entity Stacking service.
Thsi will help with my Estrogen Blocker Supplements!
Thsi will help with my Estrogen Blocker Supplements!
Thsi will help with my Estrogen Blocker Supplements!
Thsi will help with my Estrogen Blocker Supplements!
Almost unbelievably, I missed what may have been the riskiest, most critical game system in all of our early prototyping, NPC AI.
Thsi will help with my Estrogen Blocker Supplements!
These are important questions that will have a huge impact on your overall education and life for the next several years, so try visiting universities of different sizes and locations before settling on a school.
thanks for this article!