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:
1
Maximum 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:
object
Title:
Show Source
Oracle GoldenGate Output trail description
-
$schema:
Allowed Values:
[ "mpoints:trailOutput" ]
-
trailOutputs:
array trailOutputs
Minimum Number of Items:
0
Maximum Number of Items:2147483647
Trail Output Statistics
Nested Schema : trailOutputs
Type:
array
Minimum Number of Items:
0
Maximum Number of Items:
2147483647
Trail Output Statistics
Show Source
Nested Schema : items
Type:
Show Source
object
-
hostname:
hostname
The host name for a remote trail
-
ioWriteBytes:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Number of I/O Write Bytes Transfered -
ioWriteCount:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Number of I/O Write Operations -
portNumber:
integer
Minimum Value:
1
Maximum Value:65535
The TCP/IP port for the remote trail -
portType:
Allowed Values:
[ "LocalTrail", "Manager", "ServerCollector" ]
The type of port connection -
trailBufferFlushes:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Number trail file buffer flushes -
trailBufferFlushTime:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Time spent flushing trail file buffers -
trailBytesFlushed:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Number of bytes flushed from trail file buffers -
trailLastBufferFlushTs:
trailLastBufferFlushTs
Last trail file buffer flush time stamp
-
trailLobBytes:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Number of LOB bytes write in trail file -
trailMaxBytes:
integer
Minimum Value:
0
Maximum Value:4294967295
Max Number of Bytes for a Trail file -
trailName:
string
Minimum Length:
1
Maximum Length:16
The base name of the trail -
trailPath:
string
Minimum Length:
1
Maximum Length:512
The path for storing the trail -
trailRba:
integer
Minimum Value:
0
Maximum Value:4294967295
Current RBA -
trailSeq:
integer
Minimum Value:
0
Maximum Value:4294967295
Current Sequence -
trailWriteTime:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Time spent in write of trail file
Nested Schema : hostname
The host name for a remote trail
Match One
Show Source
-
string
Minimum Length:
1
Maximum Length:4095
Pattern:^(((([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:
7
Maximum Length:15
Pattern:^((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:
1
Maximum Length:256
Pattern:^((([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"
}
]
}
}