診断の取得
get
/services/{version}/extracts/{extract}/info/diagnostics/{diagnostic}
必要なロール: ユーザー
Extractプロセスの診断結果を取得します。
リクエスト
パス・パラメータ
- diagnostic(必須): string
最小長:
0最大長:22パターン:^(|[A-Z_$][A-Z0-9_$]{0,7}.diagnostics([.][1-9])?)$診断結果の名前。Extract名と.diagnosticsの後にオプションのリビジョン番号が続きます。
- extract(必須): string
最小長:
1最大長:8パターン:^[A-Z_$][A-Z0-9_$]*$Extractの名前。Extract名は大文字で、先頭が英字、その後に英数字が最大で7文字続きます。
- version(必須): string
Oracle GoldenGateサービスのAPIバージョン。
指定できる値:[ "v2" ]
問合せパラメータ
- started: string
診断の収集が開始された時間。この問合せパラメータは、リビジョン番号のない'{diagnostic}'リソースにのみ適用されます。例:
EXTN.diagnostics?started=2022-08-04T19:40:07Z
レスポンス
サポートされるメディア・タイプ
- application/json
200レスポンス
診断が正常に取得されました。
ルート・スキーマ: Integrated Diagnostics Results
型:
objectタイトル:
ソースの表示
Integrated Diagnostics Results- $schema: string
指定できる値:
[ "ogg:diagnostics" ] - collectionDuration(必須): integer
最小値:
1最大値:60データ・コレクション期間(秒) - collectionFrequency(必須): integer
最小値:
5最大値:60データ・コレクション頻度(秒) - finished: string
最小長:
20最大長:32パターン:^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$診断が完了した日時 - samples: array samples
期間のサンプル統計
- started(必須): string
最小長:
20最大長:32パターン:^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$診断が開始した日時 - status(必須):
指定できる値:
[ "starting", "running", "stopped", "killed", "abended" ]診断プロセスのステータス
ネストされたスキーマ: items
型:
objectある時点でのすべてのデータベース・プロセスからのサンプル統計
ソースの表示
- collectionDate(必須): string
最小長:
20最大長:32パターン:^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$サンプルの収集日時 - processSamples(必須): array processSamples
最小アイテム数:
1最大アイテム数:512データベース・プロセス統計
ネストされたスキーマ: processSamples
型:
array最小アイテム数:
1最大アイテム数:
512データベース・プロセス統計
ソースの表示
- 配列: object items
データベース・プロセスからのサンプル統計
ネストされたスキーマ: items
型:
objectデータベース・プロセスからのサンプル統計
ソースの表示
- cpuPercent(必須): number
最小値:
0最大値:100プロセスのCPU使用率 - idlePercent(必須): number
最小値:
0最大値:100プロセスのアイドル時間の割合 - process(必須): process
プロセス詳細
- processId(必須): integer
最小値:
1最大値:4294967295データベース・プロセス識別子 - sessionId(必須): integer
最小値:
0最大値:9223372036854776000データベース・セッション識別子 - topEvent: string
最小長:
1最大長:132上位セッション待機イベント名(アイドル待機を除く) - topEventPercent: number
最小値:
0最大値:100アイドル待機を除く上位セッション待機イベント時間の割合
ネストされたスキーマ: process
プロセス詳細
1つに一致
ソースの表示
- object process-x-oneOf[0]
取得プロセス詳細
- object process-x-oneOf[1]
LogMinerプロセス詳細
- object process-x-oneOf[2]
リーダーの適用プロセス詳細
- object process-x-oneOf[3]
レシーバの適用プロセス詳細
- object process-x-oneOf[4]
コーディネータの適用プロセス詳細
- object process-x-oneOf[5]
サーバーの適用プロセス詳細
ネストされたスキーマ: process-x-oneOf[0]
型:
object取得プロセス詳細
ソースの表示
- bytesMined(必須): integer
最小値:
0最大値:9223372036854776000マイニングREDOバイト数/秒 - bytesSent(必須): integer
最小値:
0最大値:9223372036854776000送信REDOバイト数/秒 - lag(必須): integer
最小値:
0最大値:4294967295取得プロセス・ラグ(秒) - messagesCaptured(必須): integer
最小値:
0最大値:9223372036854776000取得メッセージ数/秒 - state(必須): object state
データベース・プロセス状態
- type(必須):
指定できる値:
[ "capture" ]プロセス・タイプ
ネストされたスキーマ: process-x-oneOf[2]
型:
objectリーダーの適用プロセス詳細
ソースの表示
- bytesReceived(必須): integer
最小値:
0最大値:9223372036854776000受信トレイル・バイト数/秒 - state(必須): object state
データベース・プロセス状態
- type(必須):
指定できる値:
[ "reader" ]プロセス・タイプ
ネストされたスキーマ: process-x-oneOf[3]
型:
objectレシーバの適用プロセス詳細
ソースの表示
- messagesReceived(必須): integer
最小値:
0最大値:9223372036854776000受信メッセージ数/秒 - state(必須): object state
データベース・プロセス状態
- transactionsReceived(必須): integer
最小値:
0最大値:9223372036854776000受信トランザクション数/秒 - type(必須):
指定できる値:
[ "receiver" ]プロセス・タイプ
ネストされたスキーマ: process-x-oneOf[4]
型:
objectコーディネータの適用プロセス詳細
ソースの表示
- state(必須): object state
データベース・プロセス状態
- transactionsApplied(必須): integer
最小値:
0最大値:9223372036854776000適用トランザクション数/秒 - type(必須):
指定できる値:
[ "coordinator" ]プロセス・タイプ
ネストされたスキーマ: process-x-oneOf[5]
型:
objectサーバーの適用プロセス詳細
ソースの表示
- messagesApplied(必須): integer
最小値:
0最大値:9223372036854776000適用メッセージ数/秒 - state(必須): object state
データベース・プロセス状態
- type(必須):
指定できる値:
[ "applier" ]プロセス・タイプ
ネストされたスキーマ: state
型:
objectデータベース・プロセス状態
ソースの表示
- detail(必須): string
最小長:
1最大長:128データベース・プロセスの詳細情報 - status(必須):
指定できる値:
[ "initializing", "waiting", "idle", "suspended", "aborting", "shutdown", "paused", "working", "other" ]データベース・プロセスのステータス
ネストされたスキーマ: state
型:
objectデータベース・プロセス状態
ソースの表示
- detail(必須): string
最小長:
1最大長:128データベース・プロセスの詳細情報 - status(必須):
指定できる値:
[ "initializing", "waiting", "idle", "suspended", "aborting", "shutdown", "paused", "working", "other" ]データベース・プロセスのステータス
ネストされたスキーマ: state
型:
objectデータベース・プロセス状態
ソースの表示
- detail(必須): string
最小長:
1最大長:128データベース・プロセスの詳細情報 - status(必須):
指定できる値:
[ "initializing", "waiting", "idle", "suspended", "aborting", "shutdown", "paused", "working", "other" ]データベース・プロセスのステータス
ネストされたスキーマ: state
型:
objectデータベース・プロセス状態
ソースの表示
- detail(必須): string
最小長:
1最大長:128データベース・プロセスの詳細情報 - status(必須):
指定できる値:
[ "initializing", "waiting", "idle", "suspended", "aborting", "shutdown", "paused", "working", "other" ]データベース・プロセスのステータス
ネストされたスキーマ: state
型:
objectデータベース・プロセス状態
ソースの表示
- detail(必須): string
最小長:
1最大長:128データベース・プロセスの詳細情報 - status(必須):
指定できる値:
[ "initializing", "waiting", "idle", "suspended", "aborting", "shutdown", "paused", "working", "other" ]データベース・プロセスのステータス
レスポンスの例(application/json)
{
"$schema":"api:standardResponse",
"links":[
{
"href":"http://localhost:9012/services/v2/extracts/EXTN/info/diagnostics/EXTN.diagnostics",
"mediaType":"application/json",
"rel":"canonical"
},
{
"href":"http://localhost:9012/services/v2/extracts/EXTN/info/diagnostics/EXTN.diagnostics",
"mediaType":"application/json",
"rel":"self"
},
{
"href":"http://localhost:9012/services/v2/metadata-catalog/diagnosticsDiagnostic",
"mediaType":"application/schema+json",
"rel":"describedby"
}
],
"messages":[
],
"response":{
"$schema":"ogg:diagnostics",
"collectionDuration":60,
"collectionFrequency":5,
"samples":[
{
"collectionDate":"2024-04-03T22:33:56Z",
"processSamples":[
{
"cpuPercent":1.994234323501587,
"idlePercent":0,
"process":{
"bytesMined":0,
"bytesSent":0,
"lag":0,
"messagesCaptured":0,
"state":{
"detail":"WAITING FOR DICTIONARY REDO",
"status":"waiting"
},
"type":"capture"
},
"processId":6021,
"sessionId":4116,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":97.96265411376952
}
]
},
{
"collectionDate":"2024-04-03T22:34:01Z",
"processSamples":[
{
"cpuPercent":66.2612533569336,
"idlePercent":0,
"process":{
"bytesMined":4103968,
"bytesSent":0,
"lag":0,
"messagesCaptured":0,
"state":{
"detail":"MINING (PROCESSED SCN = 2065834)",
"status":"other"
},
"type":"capture"
},
"processId":6021,
"sessionId":4116,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":33.41476821899414
},
{
"cpuPercent":99.51162719726564,
"idlePercent":0,
"process":{
"role":"unknown",
"type":"logminer"
},
"processId":6021,
"sessionId":4116,
"topEvent":"[Administrative] index (re)build lock or pin object",
"topEventPercent":0.3828873038291931
}
]
},
{
"collectionDate":"2024-04-03T22:34:06Z",
"processSamples":[
{
"cpuPercent":93.92576599121094,
"idlePercent":0,
"process":{
"bytesMined":8194196,
"bytesSent":0,
"lag":0,
"messagesCaptured":0,
"state":{
"detail":"DICTIONARY INITIALIZATION",
"status":"initializing"
},
"type":"capture"
},
"processId":6021,
"sessionId":4116,
"topEvent":"[Concurrency] buffer busy waits",
"topEventPercent":3.724546432495117
},
{
"cpuPercent":100,
"idlePercent":0,
"process":{
"role":"unknown",
"type":"logminer"
},
"processId":6021,
"sessionId":4116
}
]
},
{
"collectionDate":"2024-04-03T22:34:11Z",
"processSamples":[
{
"cpuPercent":99.2046127319336,
"idlePercent":0,
"process":{
"bytesMined":8194196,
"bytesSent":0,
"lag":0,
"messagesCaptured":0,
"state":{
"detail":"DICTIONARY INITIALIZATION",
"status":"initializing"
},
"type":"capture"
},
"processId":6021,
"sessionId":4116,
"topEvent":"[User I/O] db file sequential read",
"topEventPercent":0.7902461886405945
},
{
"cpuPercent":0,
"idlePercent":0,
"process":{
"role":"unknown",
"type":"logminer"
},
"processId":6021,
"sessionId":4116,
"topEvent":"[User I/O] db file sequential read",
"topEventPercent":100
}
]
},
{
"collectionDate":"2024-04-03T22:34:16Z",
"processSamples":[
{
"cpuPercent":98.73721313476564,
"idlePercent":0,
"process":{
"bytesMined":8194196,
"bytesSent":0,
"lag":0,
"messagesCaptured":0,
"state":{
"detail":"DICTIONARY INITIALIZATION",
"status":"initializing"
},
"type":"capture"
},
"processId":6021,
"sessionId":4116,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":0.6919344663619995
},
{
"cpuPercent":99.21184539794922,
"idlePercent":0,
"process":{
"role":"unknown",
"type":"logminer"
},
"processId":6021,
"sessionId":4116,
"topEvent":"[User I/O] db file sequential read",
"topEventPercent":0.7881495952606201
}
]
},
{
"collectionDate":"2024-04-03T22:34:21Z",
"processSamples":[
{
"cpuPercent":83.59657287597656,
"idlePercent":0,
"process":{
"bytesMined":8194196,
"bytesSent":0,
"lag":0,
"messagesCaptured":0,
"state":{
"detail":"DICTIONARY INITIALIZATION",
"status":"initializing"
},
"type":"capture"
},
"processId":6021,
"sessionId":4116,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":12.56364917755127
},
{
"cpuPercent":61.01012420654297,
"idlePercent":0,
"process":{
"role":"unknown",
"type":"logminer"
},
"processId":6021,
"sessionId":4116,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":32.695838928222656
}
]
},
{
"collectionDate":"2024-04-03T22:34:26Z",
"processSamples":[
{
"cpuPercent":100,
"idlePercent":0,
"process":{
"bytesMined":0,
"bytesSent":1107,
"lag":0,
"messagesCaptured":0,
"state":{
"detail":"INITIALIZING",
"status":"initializing"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116,
"topEvent":"[System I/O] control file sequential read",
"topEventPercent":100
}
]
},
{
"collectionDate":"2024-04-03T22:34:31Z",
"processSamples":[
{
"cpuPercent":0.3114209473133087,
"idlePercent":0.22257494926452637,
"process":{
"bytesMined":9123912,
"bytesSent":375,
"lag":45,
"messagesCaptured":85,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":99.46448516845705
},
{
"cpuPercent":0.2233061641454697,
"idlePercent":73.27421569824219,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":26.50247573852539
},
{
"cpuPercent":27.863889694213867,
"idlePercent":71.55303192138672,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":0.5830758810043335
},
{
"cpuPercent":9.08746337890625,
"idlePercent":90.19906616210938,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":0.7134700417518616
},
{
"cpuPercent":4.291891098022461,
"idlePercent":94.76383209228516,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":0.9442750215530396
}
]
},
{
"collectionDate":"2024-04-03T22:34:36Z",
"processSamples":[
{
"cpuPercent":21.06574249267578,
"idlePercent":78.82716369628906,
"process":{
"bytesMined":25248188,
"bytesSent":1089179,
"lag":0,
"messagesCaptured":6708,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":0.1070903018116951
},
{
"cpuPercent":0.6760430335998535,
"idlePercent":34.770782470703125,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":64.55316925048828
},
{
"cpuPercent":64.52373504638672,
"idlePercent":25.32482147216797,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":10.050895690917969
},
{
"cpuPercent":12.84963607788086,
"idlePercent":46.48900604248047,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":40.374900817871094
},
{
"cpuPercent":15.77632999420166,
"idlePercent":42.085994720458984,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":42.13019943237305
},
{
"cpuPercent":4.280135154724121,
"idlePercent":0,
"process":{
"role":"reader",
"type":"logminer"
},
"processId":6080,
"sessionId":5084,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":60.149932861328125
}
]
},
{
"collectionDate":"2024-04-03T22:34:41Z",
"processSamples":[
{
"cpuPercent":0.5316092371940613,
"idlePercent":99.46839141845705,
"process":{
"bytesMined":0,
"bytesSent":420,
"lag":1,
"messagesCaptured":1,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116
},
{
"cpuPercent":0.10688245296478271,
"idlePercent":99.89311981201172,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600
},
{
"cpuPercent":0.035819005221128464,
"idlePercent":99.96417999267578,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723
},
{
"cpuPercent":0.0353882871568203,
"idlePercent":99.96461486816406,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843
},
{
"cpuPercent":0.13946425914764404,
"idlePercent":99.86053466796876,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965
},
{
"cpuPercent":0.11597205698490144,
"idlePercent":99.88124084472656,
"process":{
"role":"reader",
"type":"logminer"
},
"processId":6080,
"sessionId":5084,
"topEvent":"[System I/O] log file sequential read",
"topEventPercent":0.002790510654449463
}
]
},
{
"collectionDate":"2024-04-03T22:34:47Z",
"processSamples":[
{
"cpuPercent":0.016634339466691017,
"idlePercent":99.97783660888672,
"process":{
"bytesMined":16781,
"bytesSent":4189,
"lag":1,
"messagesCaptured":18,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116,
"topEvent":"[Network] SQL*Net more data to client",
"topEventPercent":0.005531467031687498
},
{
"cpuPercent":0.03517429158091545,
"idlePercent":99.96482849121094,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600
},
{
"cpuPercent":0.07150375097990036,
"idlePercent":99.92849731445312,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723
},
{
"cpuPercent":0.08429870009422302,
"idlePercent":99.91570281982422,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843
},
{
"cpuPercent":0.31435537338256836,
"idlePercent":99.6850128173828,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965,
"topEvent":"[Other] events in waitclass Other",
"topEventPercent":"0.0006309189484454691"
},
{
"cpuPercent":0.034545160830020905,
"idlePercent":99.9627914428711,
"process":{
"role":"reader",
"type":"logminer"
},
"processId":6080,
"sessionId":5084,
"topEvent":"[System I/O] log file sequential read",
"topEventPercent":0.0026573201175779104
}
]
},
{
"collectionDate":"2024-04-03T22:34:52Z",
"processSamples":[
{
"cpuPercent":0.03596605360507965,
"idlePercent":99.96403503417967,
"process":{
"bytesMined":0,
"bytesSent":682,
"lag":1,
"messagesCaptured":2,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116
},
{
"cpuPercent":0.025496890768408775,
"idlePercent":99.97450256347656,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600
},
{
"cpuPercent":0.024262020364403725,
"idlePercent":99.97573852539064,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723
},
{
"cpuPercent":0.0064379447139799595,
"idlePercent":99.99356079101564,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843
},
{
"cpuPercent":0.021450595930218697,
"idlePercent":99.97854614257812,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965
},
{
"cpuPercent":0.024156423285603523,
"idlePercent":99.97350311279295,
"process":{
"role":"reader",
"type":"logminer"
},
"processId":6080,
"sessionId":5084,
"topEvent":"[System I/O] log file sequential read",
"topEventPercent":0.0023433880414813757
}
]
},
{
"collectionDate":"2024-04-03T22:34:57Z",
"processSamples":[
{
"cpuPercent":0.025443196296691895,
"idlePercent":99.97455596923828,
"process":{
"bytesMined":0,
"bytesSent":551,
"lag":0,
"messagesCaptured":2,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116
},
{
"cpuPercent":0.036204636096954346,
"idlePercent":99.96379852294922,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600
},
{
"cpuPercent":0.03670389950275421,
"idlePercent":99.96329498291016,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723
},
{
"cpuPercent":0.013931955210864544,
"idlePercent":99.98606872558594,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843
},
{
"cpuPercent":0.017979998141527176,
"idlePercent":99.98201751708984,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965
},
{
"cpuPercent":0.0187345203012228,
"idlePercent":99.97907257080078,
"process":{
"role":"reader",
"type":"logminer"
},
"processId":6080,
"sessionId":5084,
"topEvent":"[System I/O] log file sequential read",
"topEventPercent":0.0021951119415462017
}
]
},
{
"collectionDate":"2024-04-03T22:35:02Z",
"processSamples":[
{
"cpuPercent":0.012976668775081636,
"idlePercent":99.98702239990234,
"process":{
"bytesMined":0,
"bytesSent":585,
"lag":0,
"messagesCaptured":2,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116
},
{
"cpuPercent":0.018971990793943405,
"idlePercent":99.98102569580078,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600
},
{
"cpuPercent":0.023088473826646805,
"idlePercent":99.9769058227539,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723
},
{
"cpuPercent":0.004454576876014471,
"idlePercent":99.99554443359376,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843
},
{
"cpuPercent":0.01839647814631462,
"idlePercent":99.98160552978516,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965
},
{
"cpuPercent":0.017091860994696617,
"idlePercent":99.98028564453124,
"process":{
"role":"reader",
"type":"logminer"
},
"processId":6080,
"sessionId":5084,
"topEvent":"[System I/O] log file sequential read",
"topEventPercent":0.0026174962986260653
}
]
},
{
"collectionDate":"2024-04-03T22:35:07Z",
"processSamples":[
{
"cpuPercent":0.02613947167992592,
"idlePercent":99.97386169433594,
"process":{
"bytesMined":417,
"bytesSent":456,
"lag":2,
"messagesCaptured":1,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116
},
{
"cpuPercent":0.05271114036440849,
"idlePercent":99.9472885131836,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600
},
{
"cpuPercent":0.03533753380179405,
"idlePercent":99.96466064453124,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723
},
{
"cpuPercent":0.007140561006963253,
"idlePercent":99.99285888671876,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843
},
{
"cpuPercent":0.02766125462949276,
"idlePercent":99.97233581542967,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965
},
{
"cpuPercent":0.024818003177642822,
"idlePercent":99.97299194335938,
"process":{
"role":"reader",
"type":"logminer"
},
"processId":6080,
"sessionId":5084,
"topEvent":"[System I/O] log file sequential read",
"topEventPercent":0.002188704442232847
}
]
},
{
"collectionDate":"2024-04-03T22:35:12Z",
"processSamples":[
{
"cpuPercent":0.046419061720371246,
"idlePercent":99.95358276367188,
"process":{
"bytesMined":0,
"bytesSent":921,
"lag":1,
"messagesCaptured":4,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116
},
{
"cpuPercent":0.01186494156718254,
"idlePercent":99.9881362915039,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600
},
{
"cpuPercent":0.018267609179019928,
"idlePercent":99.98172760009766,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723
},
{
"cpuPercent":0.024965042248368263,
"idlePercent":99.97503662109376,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843
},
{
"cpuPercent":0,
"idlePercent":100,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965
},
{
"cpuPercent":0.025548143312335014,
"idlePercent":99.97199249267578,
"process":{
"role":"reader",
"type":"logminer"
},
"processId":6080,
"sessionId":5084,
"topEvent":"[System I/O] log file sequential read",
"topEventPercent":0.002459179610013962
}
]
},
{
"collectionDate":"2024-04-03T22:35:17Z",
"processSamples":[
{
"cpuPercent":0.014288472011685371,
"idlePercent":99.98571014404295,
"process":{
"bytesMined":1869,
"bytesSent":1144,
"lag":1,
"messagesCaptured":4,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116
},
{
"cpuPercent":0.04246455803513527,
"idlePercent":99.95753479003906,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600
},
{
"cpuPercent":0.07211459428071976,
"idlePercent":99.92788696289064,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723
},
{
"cpuPercent":0.06125529855489731,
"idlePercent":99.9387435913086,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843
},
{
"cpuPercent":0.007617522496730089,
"idlePercent":99.9923858642578,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965
},
{
"cpuPercent":0.01820440404117107,
"idlePercent":99.97911834716795,
"process":{
"role":"reader",
"type":"logminer"
},
"processId":6080,
"sessionId":5084,
"topEvent":"[System I/O] log file sequential read",
"topEventPercent":0.002674204995855689
}
]
},
{
"collectionDate":"2024-04-03T22:35:22Z",
"processSamples":[
{
"cpuPercent":0.03142524138092995,
"idlePercent":99.96857452392578,
"process":{
"bytesMined":0,
"bytesSent":393,
"lag":1,
"messagesCaptured":2,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116
},
{
"cpuPercent":0.035776857286691666,
"idlePercent":99.96422576904295,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600
},
{
"cpuPercent":0.03264079988002777,
"idlePercent":99.96736145019533,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723
},
{
"cpuPercent":0.01628308743238449,
"idlePercent":99.98371887207033,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843
},
{
"cpuPercent":0.014781993813812733,
"idlePercent":99.98521423339844,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965
},
{
"cpuPercent":0.020612498745322227,
"idlePercent":99.97686767578124,
"process":{
"role":"reader",
"type":"logminer"
},
"processId":6080,
"sessionId":5084,
"topEvent":"[System I/O] log file sequential read",
"topEventPercent":0.00251952582038939
}
]
},
{
"collectionDate":"2024-04-03T22:35:27Z",
"processSamples":[
{
"cpuPercent":0.03374486416578293,
"idlePercent":99.96625518798828,
"process":{
"bytesMined":52,
"bytesSent":904,
"lag":2,
"messagesCaptured":2,
"state":{
"detail":"WAITING FOR TRANSACTION",
"status":"waiting"
},
"type":"capture"
},
"processId":6069,
"sessionId":4116
},
{
"cpuPercent":0.02137153409421444,
"idlePercent":99.97862243652344,
"process":{
"role":"merger",
"type":"logminer"
},
"processId":6072,
"sessionId":4600
},
{
"cpuPercent":0.01518937386572361,
"idlePercent":99.98480987548828,
"process":{
"role":"builder",
"type":"logminer"
},
"processId":6074,
"sessionId":4723
},
{
"cpuPercent":0.03365975245833397,
"idlePercent":99.96633911132812,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6076,
"sessionId":4843
},
{
"cpuPercent":0.007797131314873695,
"idlePercent":99.99220275878906,
"process":{
"role":"preparer",
"type":"logminer"
},
"processId":6078,
"sessionId":4965
},
{
"cpuPercent":0.013947543688118458,
"idlePercent":99.98358917236328,
"process":{
"role":"reader",
"type":"logminer"
},
"processId":6080,
"sessionId":5084,
"topEvent":"[System I/O] log file sequential read",
"topEventPercent":0.002460164250805974
}
]
}
],
"started":"2024-04-03T22:33:51Z",
"status":"running"
}
}