|
|
|
RAT Replay зависает.
|
|||
|---|---|---|---|
|
#18+
Доброе утро! Пытаюсь потестировать Real Application Testing. Снятая часовая нагрузка с рабочей базы (10.2.0.4), воспроизводится на новом сервере (11.2.0.4) 4,5 часа и цифры не очень красивые (см. логи ниже). Дольше всего ждет чего-то через dblink (SQL*Net message from dblink), но дблинки на новой базе нерабочие. Как обойти эту проблему и получить нормальный Replay? Может нужно создать какие-нибудь фильтры? Replay Information --------------------------------------------------------------------------------------------------- | Information | Replay | Capture | --------------------------------------------------------------------------------------------------- | Name | RAT_REPLAY_1 | test_capture_4 | --------------------------------------------------------------------------------------------------- | Status | COMPLETED | COMPLETED | --------------------------------------------------------------------------------------------------- | Database Name | RAT11D | RAT10D | --------------------------------------------------------------------------------------------------- | Database Version | 11.2.0.4.0 | 10.2.0.4.0 | --------------------------------------------------------------------------------------------------- | Start Time | 26-10-16 16:51:33 | 26-10-16 15:00:55 | --------------------------------------------------------------------------------------------------- | End Time | 26-10-16 21:24:14 | 26-10-16 15:30:55 | --------------------------------------------------------------------------------------------------- | Duration | 4 hours 32 minutes 41 seconds | 30 minutes 0 seconds Replay Statistics ------------------------------------------------------------------- | Statistic | Replay | Capture | ------------------------------------------------------------------- | DB Time | 21247.692 seconds | 18411.308 seconds | ------------------------------------------------------------------- | Average Active Sessions | 1.3 | 10.23 | ------------------------------------------------------------------- | User calls | 1165621 | 1181134 | Workload Profile Top Events ------------------------------------------------------------ | Event | Event Class | % Activity | ------------------------------------------------------------ | SQL*Net message from dblink | Network | 48.69 | ------------------------------------------------------------ | CPU + Wait for CPU | CPU | 41.11 | ------------------------------------------------------------ | db file sequential read | User I/O | 2.58 | ------------------------------------------------------------ | SQL*Net more data from dblink | Network | 2.29 | ------------------------------------------------------------ | db file scattered read | User I/O | 0.62 | ------------------------------------------------------------ ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.11.2016, 08:46 |
|
||
|
RAT Replay зависает.
|
|||
|---|---|---|---|
|
#18+
Database Real Application Testing User's Guide 11.1 Steps for Replaying a Database Workload Setting Up the Replay Directory Restoring the Database Resolving References to External Systems Remapping Connections User Remapping Specifying Replay Options Using Filters with Workload Replay Setting Up Replay Clients ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.11.2016, 10:40 |
|
||
|
RAT Replay зависает.
|
|||
|---|---|---|---|
|
#18+
Павел Веточкин, И еще, внимательно перечитать: 9.3 Workload Capture Restrictions ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.11.2016, 10:42 |
|
||
|
|
start [/forum/topic.php?fid=52&fpage=192&tid=1887110]: |
0ms |
get settings: |
13ms |
get forum list: |
19ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
46ms |
get topic data: |
12ms |
get forum data: |
3ms |
get page messages: |
48ms |
get tp. blocked users: |
3ms |
| others: | 256ms |
| total: | 408ms |
| 0 / 0 |
