Retrieve Diagnostics
get
/services/{version}/extracts/{extract}/info/diagnostics/{diagnostic}
Required Role: User
Retrieve a diagnostics result for the extract process.
Request
Path Parameters
-
diagnostic(required): string
Minimum Length:
0Maximum Length:22Pattern:^(|[A-Z_$][A-Z0-9_$]{0,7}.diagnostics([.][1-9])?)$The name of the diagnostic results, which is the extract name and '.diagnostics', followed by an optional revision number.
-
extract(required): string
Minimum Length:
1Maximum Length:8Pattern:^[A-Z_$][A-Z0-9_$]*$The name of the extract. Extract names are upper case, begin with an alphabetic character followed by up to seven alpha-numeric characters.
-
version(required): string
Oracle GoldenGate Service API version.
Allowed Values:[ "v2" ]
Query Parameters
-
started: string
The time that the diagnostics collection started. This query parameter applies only to the '{diagnostic}' resource without a revision number. For example:
EXTN.diagnostics?started=2022-08-04T19:40:07Z
Response
Supported Media Types
- application/json
200 Response
Diagnostics retrieved successfully.
Root Schema : Integrated Diagnostics Results
Type:
objectTitle:
Show Source
Integrated Diagnostics Results-
$schema:
string
Allowed Values:
[ "ogg:diagnostics" ] -
collectionDuration(required):
integer
Minimum Value:
1Maximum Value:60Data collection duration in seconds -
collectionFrequency(required):
integer
Minimum Value:
5Maximum Value:60Data collection frequency in seconds -
finished:
string
Minimum Length:
20Maximum Length:32Pattern:^[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])$Date and time the diagnostics finished -
samples:
array samples
Sampled statistics for the time period
-
started(required):
string
Minimum Length:
20Maximum Length:32Pattern:^[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])$Date and time the diagnostics started -
status(required):
Allowed Values:
[ "starting", "running", "stopped", "killed", "abended" ]Status of the diagnostics process
Nested Schema : samples
Type:
arraySampled statistics for the time period
Show Source
-
Array of:
object items
Sampled statistics from all database processes for a point in time
Nested Schema : items
Type:
objectSampled statistics from all database processes for a point in time
Show Source
-
collectionDate(required):
string
Minimum Length:
20Maximum Length:32Pattern:^[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])$Date/Time sample was collected -
processSamples(required):
array processSamples
Minimum Number of Items:
1Maximum Number of Items:512Database process statistics
Nested Schema : processSamples
Type:
arrayMinimum Number of Items:
1Maximum Number of Items:
512Database process statistics
Show Source
-
Array of:
object items
Sampled statistics from a database process
Nested Schema : items
Type:
objectSampled statistics from a database process
Show Source
-
cpuPercent(required):
number
Minimum Value:
0Maximum Value:100Percentage of CPU usage for the process -
idlePercent(required):
number
Minimum Value:
0Maximum Value:100Percentage of idle time for the process -
process(required):
process
Process details
-
processId(required):
integer
Minimum Value:
1Maximum Value:4294967295Database process identifier -
sessionId(required):
integer
Minimum Value:
0Maximum Value:9223372036854776000Database session identifier -
topEvent:
string
Minimum Length:
1Maximum Length:132Top session wait event name, excluding idle waits -
topEventPercent:
number
Minimum Value:
0Maximum Value:100Percentage of top session wait event time, excluding idle waits
Nested Schema : process
Process details
Match One
Show Source
-
object process-x-oneOf[0]
Capture Process Details
-
object process-x-oneOf[1]
LogMiner Process Details
-
object process-x-oneOf[2]
Apply Reader Process Details
-
object process-x-oneOf[3]
Apply Receiver Process Details
-
object process-x-oneOf[4]
Apply Coordinator Process Details
-
object process-x-oneOf[5]
Apply Server Process Details
Nested Schema : process-x-oneOf[0]
Type:
objectCapture Process Details
Show Source
-
bytesMined(required):
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of Redo bytes mined per second -
bytesSent(required):
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of Redo bytes sent per second -
lag(required):
integer
Minimum Value:
0Maximum Value:4294967295Capture process lag in seconds -
messagesCaptured(required):
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of messages captured per second -
state(required):
object state
Database process state
-
type(required):
Allowed Values:
[ "capture" ]Process type
Nested Schema : process-x-oneOf[1]
Type:
objectLogMiner Process Details
Show Source
-
role(required):
Allowed Values:
[ "reader", "preparer", "builder", "merger", "coordinator", "applier", "unknown" ]LogMiner Role -
type(required):
Allowed Values:
[ "logminer" ]Process type
Nested Schema : process-x-oneOf[2]
Type:
objectApply Reader Process Details
Show Source
-
bytesReceived(required):
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of trail bytes received per second -
state(required):
object state
Database process state
-
type(required):
Allowed Values:
[ "reader" ]Process type
Nested Schema : process-x-oneOf[3]
Type:
objectApply Receiver Process Details
Show Source
-
messagesReceived(required):
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of messages received per second -
state(required):
object state
Database process state
-
transactionsReceived(required):
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of transactions received per second -
type(required):
Allowed Values:
[ "receiver" ]Process type
Nested Schema : process-x-oneOf[4]
Type:
objectApply Coordinator Process Details
Show Source
-
state(required):
object state
Database process state
-
transactionsApplied(required):
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of transactions applied per second -
type(required):
Allowed Values:
[ "coordinator" ]Process type
Nested Schema : process-x-oneOf[5]
Type:
objectApply Server Process Details
Show Source
-
messagesApplied(required):
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of messages applied per second -
state(required):
object state
Database process state
-
type(required):
Allowed Values:
[ "applier" ]Process type
Nested Schema : state
Type:
objectDatabase process state
Show Source
-
detail(required):
string
Minimum Length:
1Maximum Length:128Detailed information for the database process -
status(required):
Allowed Values:
[ "initializing", "waiting", "idle", "suspended", "aborting", "shutdown", "paused", "working", "other" ]Status of the database process
Nested Schema : state
Type:
objectDatabase process state
Show Source
-
detail(required):
string
Minimum Length:
1Maximum Length:128Detailed information for the database process -
status(required):
Allowed Values:
[ "initializing", "waiting", "idle", "suspended", "aborting", "shutdown", "paused", "working", "other" ]Status of the database process
Nested Schema : state
Type:
objectDatabase process state
Show Source
-
detail(required):
string
Minimum Length:
1Maximum Length:128Detailed information for the database process -
status(required):
Allowed Values:
[ "initializing", "waiting", "idle", "suspended", "aborting", "shutdown", "paused", "working", "other" ]Status of the database process
Nested Schema : state
Type:
objectDatabase process state
Show Source
-
detail(required):
string
Minimum Length:
1Maximum Length:128Detailed information for the database process -
status(required):
Allowed Values:
[ "initializing", "waiting", "idle", "suspended", "aborting", "shutdown", "paused", "working", "other" ]Status of the database process
Nested Schema : state
Type:
objectDatabase process state
Show Source
-
detail(required):
string
Minimum Length:
1Maximum Length:128Detailed information for the database process -
status(required):
Allowed Values:
[ "initializing", "waiting", "idle", "suspended", "aborting", "shutdown", "paused", "working", "other" ]Status of the database process
Example Response (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"
}
}