2 Replies Latest reply: Jan 16, 2013 3:04 AM by 698374 RSS

    GoldenGate and Veridata Capacity Planning/sizing

    User13291419-Oracle
      Hello,
      Are there any capacity planning guides available for Veridata and for GoldenGate?
      What are the pertinent metrics to gather to aid in capacity planning?

      Thanks,
      Mac McDermid

      Edited by: user13291419 on Oct 17, 2012 12:55 PM
        • 1. Re: GoldenGate and Veridata Capacity Planning/sizing
          MikeN
          user13291419 wrote:
          Hello,
          Are there any capacity planning guides available for Veridata and for GoldenGate?
          What are the pertinent metrics to gather to aid in capacity planning?

          Thanks,
          Mac McDermid
          In both situations, it is dependent on the database volume. GG replication depends on redo generation rate (i.e., a 10k updates per second on a single row generates a lot of redo, even if there's only one row in the table). GG Veridata depends more on table size (millions of rows in a table with 100's of columns, having only one update per day, still takes a lot of time to compare). GG replication needs to take mostly disk & network into consideration (since data is being moved); Veridata is bound more by CPU (since data is being compared).

          Since GoldenGate replicates data between source & target, the network bandwidth is an important consideration & directly impacts latency & throughput. There are calculations in the documentation for determining requirements and suggested network settings & tcp/ip tuning. The cpu load by GoldenGate is relatively minimal (single digits cpu percent utilitization) compared to other processes (e.g., the database itself), but again it depends on the data volume. In theory GG can require very little disk space, since old data is purged shortly after it's delivered, but you must calculate available disk := estimated target downtime x trail volume generation rate.

          That's about it; everything above is covered in one form or another in the docs, but there may be MOS notes that distill this further (see master doc 1313280.1, or search for goldengate and either "performance" or "volume").
          • 2. Re: GoldenGate and Veridata Capacity Planning/sizing
            698374
            I faced below application error after I insert new connection with correct information of golden gate connection and data source connection and click finish.

            Application Error


            javax.faces.FacesException: Error calling action method of component with id form:next
            at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:74)
            at javax.faces.component.UICommand.broadcast(UICommand.java:106)
            at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90)
            at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164)
            at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:316)
            at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
            at javax.faces.webapp.FacesServlet.service(FacesServlet.java:106)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at com.goldengate.veridata.ui.filter.WelcomeTokenFilter.doFilter(WelcomeTokenFilter.java:61)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:92)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at com.goldengate.veridata.ui.filter.SessionUserFilter.doFilter(SessionUserFilter.java:115)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at com.goldengate.veridata.ui.filter.AjaxFilter.doFilter(AjaxFilter.java:66)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at com.goldengate.veridata.ui.filter.Utf8Filter.doFilter(Utf8Filter.java:28)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
            at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
            at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
            at java.lang.Thread.run(Unknown Source)
            Caused by: javax.faces.el.EvaluationException: Exception while invoking expression #{addConnectionWizardUI.getNextStep}
            at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:153)
            at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
            ... 39 more
            Caused by: java.lang.NullPointerException
            at com.goldengate.veridata.entity.ConnectionComparisonFormat.(ConnectionComparisonFormat.java:13)
            at com.goldengate.veridata.entity.ConnectionDatatypeInfo.(ConnectionDatatypeInfo.java:63)
            at com.goldengate.veridata.entity.Connection.(Connection.java:84)
            at com.goldengate.veridata.dao.ConnectionDAOWebServices.findByName(ConnectionDAOWebServices.java:222)
            at com.goldengate.veridata.dao.ConnectionDAOWebServices.handleVersionControlInfo(ConnectionDAOWebServices.java:185)
            at com.goldengate.veridata.dao.ConnectionDAOWebServices.insert(ConnectionDAOWebServices.java:144)
            at com.goldengate.veridata.bu.ConnectionManagerImpl.insert(ConnectionManagerImpl.java:73)
            at com.goldengate.veridata.ui.AddConnectionWizardUI.createConnection(AddConnectionWizardUI.java:211)
            at com.goldengate.veridata.ui.AddConnectionWizardUI.getNextStep(AddConnectionWizardUI.java:120)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
            at java.lang.reflect.Method.invoke(Unknown Source)
            at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)
            ... 40 more

            Your response is highly appreciated.

            Regards