View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003586 | SymmetricDS | Improvement | public | 2018-05-31 18:01 | 2018-07-20 16:21 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.9.8 | Fixed in Version | 3.9.8 | ||
| Summary | 0003586: Noorder sequence for performance on Oracle RAC | ||||
| Description | Oracle RAC must coordinate an ordered sequence (for sym_data) across the cluster, which results in wait time overhead for high throughput change capture. A "noorder" sequence reduces the overhead and is 30x faster. Add a oracle.sequence.noorder parameter that can be enabled for better performance on Oracle RAC. It will alter the sym_data sequence to be "noorder", add an index to sym_data for (create_time, data_id), and query sym_data with an order by of create_time and data_id. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.9 6ef72b61 2018-05-31 14:08:07 Details Diff |
0003586: Noorder sequence for performance on Oracle RAC |
Affected Issues 0003586 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapRouteReader.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/AcknowledgeService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/AcknowledgeServiceSqlMap.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterServiceSqlMap.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
|
SymmetricDS: 3.9 5bf209e0 2018-06-05 14:14:53 Details Diff |
0003586: Noorder sequence for performance on Oracle RAC |
Affected Issues 0003586 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapRouteReader.java | Diff File | ||
|
SymmetricDS: 3.8 007f51cf 2018-06-06 14:09:28 Details Diff |
0003586: Noorder sequence for performance on Oracle RAC |
Affected Issues 0003586 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/AcknowledgeServiceSqlMap.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-05-31 18:01 | elong | New Issue | |
| 2018-05-31 18:01 | elong | Status | new => assigned |
| 2018-05-31 18:01 | elong | Assigned To | => elong |
| 2018-05-31 18:10 | elong | Relationship added | related to 0003587 |
| 2018-05-31 19:00 | admin | Changeset attached | => SymmetricDS 3.9 6ef72b61 |
| 2018-06-05 18:23 | elong | Status | assigned => resolved |
| 2018-06-05 18:23 | elong | Resolution | open => fixed |
| 2018-06-05 18:23 | elong | Fixed in Version | => 3.9.8 |
| 2018-06-05 19:00 | admin | Changeset attached | => SymmetricDS 3.9 5bf209e0 |
| 2018-06-05 20:55 | mmichalek | Status | resolved => closed |
| 2018-06-06 19:00 | admin | Changeset attached | => SymmetricDS 3.8 007f51cf |
| 2018-07-20 16:15 | elong | Relationship added | related to 0003640 |
| 2018-07-20 16:21 | elong | Relationship added | related to 0003641 |