To TRANDATA or To SCHEMATRANDATA? … That is the #GoldenGate questions of the day!

If you are familiar with using Oracle GoldenGate, you know that on the source side of the equation you have to enable supplemental logging and sometimes force logging on the database. I traditionally do both just to make sure that I capture as much as I can into the redo stream from the transactions on the database. For Oracle GoldenGate purposes, this is not the only thing you need to turn on to ensure all needed information is captured to the trail files.

There are two Oracle GoldenGate GGSCI commands that can be ran to enable supplemental logging at the schema or table level. These commands are ADD TRANDATA and ADD SCHEMATRANDATA. What is the difference between the two, you may ask?

ADD TRANDATA – is used to enable supplemental logging at the table level
ADD SCHEMATRANDATA – is used to enable supplemental logging at the schema level

That is such a high-level view of the concept. What is the difference between the two trandata approaches, really?

ADD TRANDATA:

ADD TRANDATA command is used to enable Oracle GoldenGate to acquire the transaction information that it needs from the transaction records. This version of the command can be used on the following databases:

  • DB2 for i Database
  • DB2 LUW Database
  • DB2 z/OS Database
  • Oracle Database
  • MS SQL Server
  • Sybase Database

For an Oracle Database, ADD TRANDATA enables the unconditional logging of the primary key and conditional supplemental logging of all unique key(s) and foreign key(s) of the specified table. Additionally, you can use ADD TRANDATA with the COLS option to log any non-key columns that can be used with the FILTER statements and KEYCOLS clauses in the TABLE and MAP parameters.

An example of adding trandata to a schema would be:

GGSCI> dblogin useridalias gate
GGSCI> add trandata soe.*

 

 

Once transdata has been added to the schema/tables, you can verify the existence of trandata from GGSCI using the INFO TRANDATA command as demonstrated in the below command set.

GGSCI> dblogin useridalias gate
GGSCI> info trandata soe.addresses
2016-08-12 15:07:23  INFO    OGG-06480  Schema level supplemental logging, excluding non-validated keys, is enabled on schema SOE.
2016-08-12 15:07:23  INFO    OGG-01980  Schema level supplemental logging is enabled on schema SOE for all scheduling columns.
Logging of supplemental redo log data is enabled for table SOE.ADDRESSES.
Columns supplementally logged for table SOE.ADDRESSES: ADDRESS_ID, COUNTRY, COUNTY, CUSTOMER_ID, DATE_CREATED, HOUSE_NO_OR_NAME, POST_CODE, STREET_NAME, TOWN, ZIP_CODE.

 

Now that ADD TRANDATA has been ran, what exactly does ADD TRANDATA do to the database it is ran against? For an Oracle Database, ADD TRANDATA adds a Supplemental Log Group (SLG) on to the table. This can be seen from the DBA_LOG_GROUP view under SYS. The SLGs that are corrected are all labeled with a prefix of “GGS”. The following output shows what this looks like after running it for a whole schema.

select owner, log_group_name, table_name, log_group_type, always, generated
from dba_log_groups
where owner = 'SOE'
and log_group_name like 'GGS%';

 

Now, there are some who will argue that the same effect can be done by just asking a SLG to a table manually. Although this is true, Oracle GoldenGate uses the GGS_ prefix to keep track of the tables that are in the replication process. Also, easier to clean up when you issue DROP TRANDATA, which will remove all the associated SLG items from the tables.

The ADD TRANDATA approach should be used with 11g or older versions of Oracle GoldenGate. As you move towards new version of Oracle GoldenGate, Oracle is pushing that everyone pick up and use the ADD SCHEMATRANDATA method. So let’s take a look at that now.

ADD SCHEMATRANDATA:

The ADD SCHEMATRANDATA is used on all the current and future tables in a given schema to automatically log a superset of available keys that Oracle GoldenGate needs for row identification. Using this version of TRANDATA, it can be used with both the integrated and classic capture processes.

There are four key reasons why you should use ADD SCHEMATRANDATA:

  • Enables supplemental logging for new tables created with a CREATE TABLE DDL command.
  • Updates supplemental logging for tables affected by an ALTER TABLE DDL command that adds or drops columns
  • Updates supplemental logging for tables affected by RENAME TABLE command
  • Updates supplemental logging for tables affected by adding or dropping of unique or primary key constraints

 

Although ADD SCHEMATRANDATA can be used with both integrated and classic capture processes, it is mostly geared towards the integrated process. There are three primary reasons to use ADD SCHEMATRANDATA with the integrated capture:

Ensures that the correct key is logged by logging all the keys
Options are provided that enable the logging of the primary, unique, and foreign keys to support the computation of dependences among the tables being processed by the integrated replicats (think apply servers)
Ensures the appropriate key values are logged in the redo to allow DML to be mapped to object that have DDL issued against them.

Earlier in this post, I mentioned that I often enable “force logging” on the database when I do the minimal supplemental logging. Force logging is encouraged by Oracle, especially when using ADD SCHEMATRANDATA.

Now to add issue ADD SCHEMATRANDATA against an Oracle database, it is similar the same way as ADD TRANDATA, with the difference that you don’t have to provide any wildcards. In the examples below, I show you how this can be done:

GGSCI> dblogin useridalias ggate
GGSCI> add schematrandata soe
2016-08-12 15:47:40  INFO    OGG-01788  SCHEMATRANDATA has been added on schema soe.
2016-08-12 15:47:40  INFO    OGG-01976  SCHEMATRANDATA for scheduling columns has been added on schema soe.

 

After running ADD SCHEMATRANDATA, you can perform an INFO SCHEMATRANDATA on the schema to see what has been modified.

GGSCI (fred.acme.com as ggate@src12c) 9> info schematrandata soe
2016-08-12 15:51:52  INFO    OGG-06480  Schema level supplemental logging, excluding non-validated keys, is enabled on schema SOE.
2016-08-12 15:51:52  INFO    OGG-01980  Schema level supplemental logging is enabled on schema SOE for all scheduling columns.

 

Digging around in the database, to see if ADD SCHEMATRANDATA does the same as ADD TRANDATA with SLG; well, it doesn’t. ADD SCHEMATRANDATA does not create any SLGs. The only place that I have found that has any record of supplemental logging turned on with ADD SCHEMATRANDATA is in the V_$GOLDENGATE_CAPABILITIES view. Here, you can see that supplemental logging has been enabled, the number of times it has been acted upon and when it was last executed.

NAME                        COUNT TO_CHAR(LAST_USED     CON_ID
---------------------- ---------- ----------------- ----------
DBENCRYPTION                    0 12-JUN-2016 21:20          0
DBLOGREADER                     0 12-JUN-2016 21:20          0
TRIGGERSUPPRESSION              0 12-JUN-2016 21:20          0
TRANSIENTDUPLICATE              0 12-JUN-2016 21:20          0
DDLTRIGGEROPTIMIZATION          0 12-JUN-2016 21:20          0
GGSESSION                       0 12-JUN-2016 21:20          0
DELETECASCADEHINT               0 12-JUN-2016 21:20          0
SUPPLEMENTALLOG                 5 12-AUG-2016 16:02          0

 

Now, being that the integrated items of Oracle GoldenGate are closely related to Oracle Streams, there may be a table or view related to Streams that has this information. Once I find it, I’ll provide an update to this post.

In the mean time, I hope this post has provided some insight into the differences between ADD TRANDATA and ADD SCHEMATRANDATA.

If you are moving to or using the integrated products of Oracle GoldenGate, then ADD SCHEMATRANDATA is the method that you should be using.

Enjoy!!!

@dbasolved
http://about.me/dbasolved

 

 

Please follow and like:
Comments
  • Efficient Steroids Cutting Cycle Guide For Lean Muscle

    Efficient Steroids Cutting Cycle Guide For Lean Muscle

    ### Key Takeaways
    Anabolic steroids have long been a staple in the world of bodybuilding,
    offering individuals the ability to enhance
    muscle growth and definition. However, their use must be approached with caution and a
    thorough understanding of how they work and impact the body.

    ### Understanding Steroids and Their Role in Bodybuilding
    Anabolic steroids are synthetic substances that mimic the effects of testosterone, a
    hormone naturally produced by the body. Testosterone is responsible for muscle growth,
    fat metabolism, and various other physiological processes.
    While natural testosterone levels decline with age, anabolic steroids can provide
    a boost, enabling users to achieve leaner muscles and a more defined physique.

    ### What are Anabolic Steroids?
    Anabolic steroids are man-made variants of testosterone
    that have been altered to mimic the hormone’s muscle-building effects more efficiently.

    They are often used in cutting cycles, where their primary purpose is to strip excess fat while maintaining or even increasing
    muscle mass.

    ### How Do Steroids Work for Muscle Growth?

    Steroids work by binding to androgen receptors in cells,
    signaling the body to synthesize proteins and promote muscle growth.
    This process is amplified when steroids are used in conjunction with intense resistance training,
    which creates a hypertrophic response in the muscles.

    ### Factors to Consider for an Effective Cutting Cycle
    A successful cutting cycle hinges on several factors, including
    individual goals, experience level, and adherence to proper protocols.
    Women often prefer different compounds than men due to
    differences in muscle physiology and hormone levels.

    ### Gender Differences in Steroid Use
    While anabolic steroids can be used by both genders, the effects are typically more pronounced
    in men. Women may find milder or gender-specific
    formulations more suitable for their needs, as higher doses
    of traditional anabolic steroids can lead to unwanted side effects like deepening of voice or increased facial hair.

    ### Experience Level and Its Impact on Cycle
    Selection
    Newcomers should start with shorter cycles and lower dosages to assess their tolerance and response before moving to longer or more
    potent regimens. Experienced users may opt for extended cycles to achieve peak conditioning, but this requires careful monitoring and planning.

    ### Aligning Steroid Use with Fitness Goals
    The choice of steroid compounds and cycle duration should align with the user’s fitness objectives.

    For example, a competitive bodybuilder might require a different approach
    compared to someone looking to enhance personal fitness.

    ### Choosing the Right Steroids for Cutting
    When it comes to selecting steroids for cutting, users often prioritize compounds
    with strong fat-burning effects while maintaining muscle mass.
    Testosterone enantate and boldenone are popular choices for
    their ability to promote lean muscle growth while stripping excess body fat.

    ### Popular Steroid Compounds for Cutting Cycles
    – **Testosterone Enantate**: A long-acting steroid that provides a steady supply of testosterone, supporting muscle maintenance and fat
    loss.
    – **Boldenone**: Known for its ability to enhance muscle definition and promote fat oxidation.

    ### Comparison of Oral vs. Injectable Steroids
    Injectable steroids are generally preferred by serious users due to
    their consistent release and reduced side effects compared to oral forms.
    However, both have their place in a cutting cycle, depending on individual preferences and tolerance.

    ### Steroids Cutting Cycle: Planning Your Cycle
    A well-planned cutting cycle begins with determining
    the appropriate length and dosage. While cycles can vary, a common approach is to use injectable steroids
    for 8-12 weeks, accompanied by a structured workout
    plan and diet.

    ### Length and Dosage Recommendations for Cutting Cycles
    Dosage should be calculated based on individual response,
    starting with lower doses to assess tolerance before
    increasing. The cycle length may range from 4 to 16 weeks, depending on goals and experience level.

    ### Beginning a Cutting Cycle: What to Expect
    Users can expect significant muscle definition within the first few weeks,
    along with increased energy levels. However, this is often accompanied by temporary side effects like acne or hair loss, which typically subside
    as the body adjusts.

    ### Monitoring and Adjusting Your Cycle
    Regular monitoring of progress and health indicators is crucial.

    Blood work to check hormone levels can provide valuable insights, allowing adjustments to be made
    as needed.

    ### Buy 2, Get 1 Free + Extra 20% Off Limited Time Offer
    Take advantage of exclusive offers available from trusted suppliers to enhance your cutting
    cycle experience at a better value.

    ### Minimizing Risks During a Cutting Cycle
    While steroids are effective, they do carry risks.
    Users should prioritize obtaining their compounds from reputable sources to reduce the likelihood of
    counterfeit or contaminated products.

    ### Proper Nutrition and Training During the Cycle
    A cutting cycle is not just about steroid use; it requires a disciplined approach to diet and training.

    Consistent protein intake, calorie control, and intensity in workouts are essential for maximizing
    results.

    ### Understanding Potential Side Effects
    As with any exogenous hormone, steroids carry potential side effects,
    including hormonal imbalances, liver stress, and changes in cholesterol levels.

    Users must be prepared to manage these risks through appropriate supplementation and monitoring.

    ### Post-Cycle Therapy (PCT) Considerations
    After completing a cutting cycle, a post-cycle therapy plan is often employed to restore natural hormone production and avoid a hormonal imbalance.
    This typically involves using compounds like Clomid or
    Nolvadex to stimulate testosterone levels.

    ### Conclusion
    An efficient steroid cutting cycle is the result of meticulous planning,
    proper adherence, and an understanding of how these hormones interact
    with the body. By aligning their use with fitness goals and maintaining a
    healthy lifestyle, users can achieve lean muscle while
    minimizing risks.

    ### FAQ

    **What are the main benefits of using anabolic steroids in a cutting cycle?**
    Anabolic steroids enhance fat loss while preserving or increasing muscle
    mass, making them a powerful tool for achieving a lean physique.

    **How do I choose the right steroid for my cutting cycle?**
    Choosing the right steroid depends on individual goals and
    experience. Popular options include testosterone
    enantate and boldenone, which are effective for cutting while maintaining muscle.

    **Are there any risks associated with anabolic
    steroid use?**
    Yes, steroids can cause side effects such as hormonal imbalances, liver damage, and changes in cholesterol levels.
    Proper usage and sourcing are essential to mitigate these risks.

    **How long should a typical cutting cycle last?**
    Cycle lengths vary from 4 to 16 weeks, depending on the compound
    and user goals. Longer cycles may be used by experienced users aiming for peak conditioning.

    **What kind of nutrition is recommended during a cutting cycle?**
    A diet rich in protein, moderate in calories, and low in fat is ideal during a cutting cycle.

    Users should also stay hydrated and consider supplementing with BCAAs to
    aid muscle retention.

    **Do women need to use different steroids than men for cutting cycles?**

    While men and women both benefit from anabolic steroids, the choice
    of compounds may differ due to gender-specific needs and hormonal responses.

    **What is post-cycle therapy (PCT) and why is it important?**
    PCT is a regimen used after steroid usage to restore natural hormone production and balance.
    It helps prevent hormonal imbalances that can occur during and after a cycle,
    aiding in recovery and future use of steroids.

    ### Source Links
    – Reputable Supplier Link(#)
    – Educational Resource on Steroid Use(#)

    ### Leave a Comment
    Cancel Reply

  • Once the cycle has finished, post-cycle remedy (PCT) shall
    be required, especially if testosterone has been used as a half of the
    stack. In weeks 16 and 17, use 40 mg of Nolvadex per day, decreased
    to 20 mg in weeks 18 and 19. As the androgenic energy is fairly weak,
    Anavar could be very engaging for ladies. Female users of this steroid
    are unlikely to develop masculine characteristics, corresponding to body hair growth, lack
    of breasts, or clitoris swelling—typical unwanted effects of stronger synthetics.
    As mentioned, Anavar is not a serious bulking steroid—which has led to many guys considering it as a weak and ineffective drug.
    But, whereas not perfect for large mass—with its muscle
    retaining and fats shedding results it makes it an ideal cutting steroid.

    Thus, we don’t have our sufferers take anastrozole when their
    blood pressure is already high. With this in mind, shorter esters require common injections (daily or each different day), whereas longer esters, corresponding to enanthate, typically only require
    injections a few times per week. Tren is a steroid utilized by various powerlifters due to its efficiency
    and androgenicity. Anavar can also be effective for
    rising muscular strength, although to not the identical diploma as tren. Anavar is not viewed as a bulking steroid, because
    it solely builds reasonable quantities of muscle. 2) All
    The Time monitor your blood strain and coronary
    heart rate while biking with Anavar; if either of this start to rise significantly, cut back the dosage or cease taking the steroid altogether.

    Whereas there are fairly a couple of legal alternatives to Anavar in the
    marketplace today, a few of them are extremely questionable.

    PCT or post-cycle therapy is probably certainly one of the most essential ideas to assume about when dosing with
    Anavar. You need to avoid jumping in too fast or you could harm yourself with
    excessive doses. Sadly, these complete cycles can be tough to comply with without a little financial funding.
    I’ve broken down a number of of the commonest sequences to provide
    you an concept of how you can dose with Anavar.

    These won’t trigger as many issues however should still complicate a teen’s growth.
    Anvarol is produced utilizing natural elements which might be designed to simulate the effects of Anavar without
    so many opposed reactions. It is a a lot safer way to shed pounds
    and add definition to your muscle mass than Anavar.

    Anavar will dramatically spike testosterone ranges, while rising protein synthesis and nitrogen retention. This shifts the physique into an anabolic
    environment where the body’s muscle-building potential increases.
    Anavar is probably considered one of the hottest oral anabolic
    steroids which have ever been released. Anavar usage
    will decrease the natural pituitary axis necessary to maintain testosterone manufacturing.

    At its most basic, Anavar is kind of all the time stacked with Testosterone for hormone replacement functions.
    This might be at a low dose, where the testosterone won’t contribute much to
    your performance. But to take it a step further, raising your Testosterone dose can result in powerful
    anabolic effects with muscle and energy positive aspects.

    Anavar and all anabolic steroids are primarily forms of exogenous testosterone; thus,
    Anavar will increase muscle mass. Even if the real Anavar can pose certain well being dangers,
    fake Anavar potentially amplifies these risks as a end result of questionable nature of their elements.
    From minor signs to major well being issues, the listing may be extensive.

    More severe health points can be hormone imbalances and damages to the liver or heart.
    On the contrary, authorized Anavar alternate options are
    substances created to mirror the effects of Anavar, without carrying the same authorized and well being dangers.
    They are designed to be safer, selling muscle growth and
    improved efficiency whereas guaranteeing that users don’t violate anti-doping laws or cope with antagonistic health effects.

    This was as a end result of the FDA (Food and Drug Administration) was underneath pressure to tighten its grip on the anabolic steroid
    market. Consequently anavar grew to become very difficult to get
    hold of during and as with all scarce merchandise it
    pushed the value up excessive (resulting in less folks consuming the drug).

    Like with different anabolic steroids, Anavar is unlawful in most nations, unless you have a
    prescription out of your doctor. The changes in cholesterol
    levels brought on by Anavar can lead to an increased risk of heart illness,
    coronary heart attacks, and strokes. Males who have already got cardiovascular issues
    or are at risk for them should be notably cautious when contemplating
    Anavar use. An Example of an Anavar or Oxandrolone solely cycle could be 60-80mg daily for 5-6 weeks in males and 10-20mg daily for 4-5 weeks in females.
    A well-balanced food plan can also be key, excessive in protein, common cardio,
    blood checks, balanced training program, and
    intake of plenty of water to restrict organ stress.
    Some people could additionally be tempted to enterprise beyond the really helpful thresholds within the pursuit of
    extra impressive gains. This emphasizes the significance
    of sticking to responsible dosage parameters. As for the duration of the cycle, a shorter period of 6
    to eight weeks is often suggested for novices.

    This timespan, combined with a low dosage, may help you observe how your physique responds to Oxandrolone, and still produce
    optimistic changes in muscle tone and energy.
    Use it over the past 4 weeks of your cycle at a dosage of one hundred mg
    per day. Nonetheless, it can be used as a secondary compound when stacked with stronger muscle mass builders like Dianabol or Testosterone.
    This is as a result of of Winstrol increasing free testosterone, with it
    strongly binding to SHBG (sex hormone-binding globulin).
    When free testosterone ranges turn into excessively
    elevated in girls, masculinization follows.
    Winstrol, like many different oral steroids, is hepatotoxic and thus causes stress to the liver (1).
    Winstrol is another steroid used by these seeking to shed pounds or minimize for
    the summer season.

    References:

    best steroid Supplements (git.smartenergi.org)

Leave a Reply

Your email address will not be published. Required fields are marked *

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.