診断の取得
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"
}
}