Retrieve an existing Output Trail File Statistics
get
/services/{version}/mpoints/{item}/trailOutput
Required Role: User
Retrieve an existing Output Trail File StatisticsRequest
Path Parameters
-
item(required): string
Minimum Length:
1Maximum Length:32 -
version(required): string
Oracle GoldenGate Service API version.
Allowed Values:[ "v2" ]
Response
Supported Media Types
- application/json
200 Response
Root Schema : Oracle GoldenGate Output trail description
Type:
objectTitle:
Show Source
Oracle GoldenGate Output trail description-
$schema:
Allowed Values:
[ "mpoints:trailOutput" ] -
trailOutputs:
array trailOutputs
Minimum Number of Items:
0Maximum Number of Items:2147483647Trail Output Statistics
Nested Schema : trailOutputs
Type:
arrayMinimum Number of Items:
0Maximum Number of Items:
2147483647Trail Output Statistics
Show Source
Nested Schema : items
Type:
Show Source
object-
hostname:
hostname
The host name for a remote trail
-
ioWriteBytes:
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of I/O Write Bytes Transfered -
ioWriteCount:
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of I/O Write Operations -
portNumber:
integer
Minimum Value:
1Maximum Value:65535The TCP/IP port for the remote trail -
portType:
Allowed Values:
[ "LocalTrail", "Manager", "ServerCollector" ]The type of port connection -
trailBufferFlushes:
integer
Minimum Value:
0Maximum Value:9223372036854776000Number trail file buffer flushes -
trailBufferFlushTime:
integer
Minimum Value:
0Maximum Value:9223372036854776000Time spent flushing trail file buffers -
trailBytesFlushed:
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of bytes flushed from trail file buffers -
trailLastBufferFlushTs:
trailLastBufferFlushTs
Last trail file buffer flush time stamp
-
trailLobBytes:
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of LOB bytes write in trail file -
trailMaxBytes:
integer
Minimum Value:
0Maximum Value:4294967295Max Number of Bytes for a Trail file -
trailName:
string
Minimum Length:
1Maximum Length:16The base name of the trail -
trailPath:
string
Minimum Length:
1Maximum Length:512The path for storing the trail -
trailRba:
integer
Minimum Value:
0Maximum Value:4294967295Current RBA -
trailSeq:
integer
Minimum Value:
0Maximum Value:4294967295Current Sequence -
trailWriteTime:
integer
Minimum Value:
0Maximum Value:9223372036854776000Time spent in write of trail file
Nested Schema : hostname
The host name for a remote trail
Match One
Show Source
-
string
Minimum Length:
1Maximum Length:4095Pattern:^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$Network host name -
hostname-x-oneOf[1]
Network IP address
Nested Schema : trailLastBufferFlushTs
Last trail file buffer flush time stamp
Match One
Show Source
Nested Schema : hostname-x-oneOf[1]
Network IP address
Match One
Show Source
-
string
Minimum Length:
7Maximum Length:15Pattern:^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$Network IPv4 address -
string
Minimum Length:
1Maximum Length:256Pattern:^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$Network IPv6 address
Example Response (application/json)
{
"$schema":"api:standardResponse",
"links":[
{
"rel":"canonical",
"href":"http://phoenix91634.dev3sub2phx.databasede3phx.oraclevcn.com:9904/services/v2/mpoints/EXT300/trailOutput",
"mediaType":"application/json"
},
{
"rel":"self",
"href":"http://phoenix91634.dev3sub2phx.databasede3phx.oraclevcn.com:9904/services/v2/mpoints/EXT300/trailOutput",
"mediaType":"application/json"
},
{
"rel":"describedby",
"href":"http://phoenix91634.dev3sub2phx.databasede3phx.oraclevcn.com:9904/services/v2/metadata-catalog/trailOutput",
"mediaType":"application/schema+json"
}
],
"messages":[
],
"response":{
"$schema":"mpoints:trailOutput",
"trailOutputs":[
{
"trailBufferFlushTime":13806,
"hostname":"phoenix91634",
"trailBytesFlushed":0,
"ioWriteCount":124,
"trailName":"qq",
"trailRba":158439,
"ioWriteBytes":157127,
"trailPath":"/scratch/ogg/oggdeployments/demo/var/lib/data",
"trailMaxBytes":500000000,
"trailLobBytes":0,
"trailBufferFlushes":5532,
"trailWriteTime":0,
"trailSeq":5,
"trailLastBufferFlushTs":"2023-05-16T23:03:55.779Z"
},
{
"trailBufferFlushTime":1097,
"hostname":"phoenix91634",
"trailBytesFlushed":0,
"ioWriteCount":124,
"trailName":"q2",
"trailRba":158439,
"ioWriteBytes":157127,
"trailPath":"/scratch/ogg/oggdeployments/demo/var/lib/data",
"trailMaxBytes":500000000,
"trailLobBytes":0,
"trailBufferFlushes":5532,
"trailWriteTime":0,
"trailSeq":2,
"trailLastBufferFlushTs":"2023-05-16T23:03:55.779Z"
}
]
}
}