Oracle - Describe how to monitor replication. posted by
Babu Kunwar
Describe how to monitor replication.
We can monitor replication from both the command line and within your programs.
The ttStatus and ttRepAdmin utilities are used for the command line utilities.
To manage replication from the programs we can use built in procedure or create
your own SQL SELECT statements to query the replication tables. We can invoke
these procedures using the ODBC or JDBC procedure call interface.
The procedure takes the position of the SQL statement, as illustrated in the
following examples. The following ODBC call tells the optimizer that it should
not generate temporary hash indexes when preparing commands:
SQLExecDirect (hstmt, (SQLCHAR*)
"{CALL ttOptSetFlag ('TmpHash', 0)}", SQL_NTS);
This is the equivalent JDBC call.
Another way is to use the supplied packages that are coming along with Oracle.
More links
What is a PL/SQL package?
Advantages of PL/SQL Packages
What are the types and layers of Packages? Explain them
PL/SQL Packages features
Guidelines for writing packages.........
|
