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"
}
}