Provides statistics for all open objects on DML statements replicated using SQL statement replication.
Name |
Datatype |
Attribute |
Description |
|---|---|---|---|
dbid |
int |
Database ID |
|
objectid |
int |
Object ID |
|
dbname |
varchar(30) |
Database name |
|
objectname |
varchar(30) |
Object name |
|
updatestmts |
int |
counter |
Number of update statements replicated with SQL statement replication |
insertselectstmts |
int |
counter |
Number of insert select statements replicated with SQL statement replication |
deletestmts |
int |
counter |
Number of delete statements replicated with SQL statement replication |
selectintostmts |
int |
counter |
Number of select into statements replicated with SQL statement replication |
rowsthreshold |
int |
Lower limit of the range of rows affected by the DML statements replicated using SQL statement replication |
This example shows sample rows of monSQLRepActivity. The table shows the following statements being replicated using SQL statement replication:
900 update statements affecting between 51 and 15000 rows
10 insert select statements affecting between 51 and 15000 rows
10000 delete statements affecting between 51 and 15000 rows
90 update statements affecting more than 15000 rows
1000 insert select statements affecting more than 15000 rows
500 delete statements affecting more than 15000 rows
dbid |
objectid |
dbname |
objectname |
updatestmts |
insertselectstmts |
deletestmts |
select intostmts |
rowsthreshold |
|---|---|---|---|---|---|---|---|---|
4 |
576002052 |
db1 |
t1 |
0 |
0 |
0 |
0 |
0 |
4 |
576002052 |
db1 |
t1 |
900 |
10 |
10000 |
0 |
50 |
4 |
576002052 |
db1 |
t1 |
90 |
1000 |
500 |
0 |
15000 |
| Copyright © 2009. Sybase Inc. All rights reserved. |
|
|