Class GetAwrDatabaseSqlReportRequest

Inheritance

object

GetAwrDatabaseSqlReportRequest

Implements

IOciRequest

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.OpsiService.Requests

Assembly: OCI.DotNetSDK.Opsi.dll

Syntax

public class GetAwrDatabaseSqlReportRequest : IOciRequest

Examples

Click here to see an example of how to use GetAwrDatabaseSqlReport request.

Properties

AwrHubId

Declaration

[Required(ErrorMessage = "AwrHubId is required.")]
[HttpConverter(TargetEnum.Path, "awrHubId")]
public string AwrHubId { get; set; }

Property Value

Type	Description
string	Unique Awr Hub identifier

Remarks

Required

AwrSourceDatabaseIdentifier

Declaration

[Required(ErrorMessage = "AwrSourceDatabaseIdentifier is required.")]
[HttpConverter(TargetEnum.Query, "awrSourceDatabaseIdentifier")]
public string AwrSourceDatabaseIdentifier { get; set; }

Property Value

Type	Description
string	The internal ID of the database. The internal ID of the database is not the OCID. It can be retrieved from the following endpoint: /awrHubs/{awrHubId}/awrDatabases

Remarks

Required

BeginSnapshotIdentifierGreaterThanOrEqualTo

Declaration

[HttpConverter(TargetEnum.Query, "beginSnapshotIdentifierGreaterThanOrEqualTo")]
public int? BeginSnapshotIdentifierGreaterThanOrEqualTo { get; set; }

Property Value

Type	Description
int?	The optional greater than or equal to filter on the snapshot ID.

EndSnapshotIdentifierLessThanOrEqualTo

Declaration

[HttpConverter(TargetEnum.Query, "endSnapshotIdentifierLessThanOrEqualTo")]
public int? EndSnapshotIdentifierLessThanOrEqualTo { get; set; }

Property Value

Type	Description
int?	The optional less than or equal to query parameter to filter the snapshot Identifier.

InstanceNumber

Declaration

[HttpConverter(TargetEnum.Query, "instanceNumber")]
public string InstanceNumber { get; set; }

Property Value

Type	Description
string	The optional single value query parameter to filter by database instance number.

OpcRequestId

Declaration

[HttpConverter(TargetEnum.Header, "opc-request-id")]
public string OpcRequestId { get; set; }

Property Value

Type	Description
string	Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.

ReportFormat

Declaration

[HttpConverter(TargetEnum.Query, "reportFormat")]
public GetAwrDatabaseSqlReportRequest.ReportFormatEnum? ReportFormat { get; set; }

Property Value

Type	Description
GetAwrDatabaseSqlReportRequest.ReportFormatEnum?	The format of the AWR report.

SqlId

Declaration

[Required(ErrorMessage = "SqlId is required.")]
[HttpConverter(TargetEnum.Query, "sqlId")]
public string SqlId { get; set; }

Property Value

Type	Description
string	The parameter to filter SQL by ID. Note that the SQL ID is generated internally by Oracle for each SQL statement and can be retrieved from AWR Report API (/awrHubs/{awrHubId}/awrDbReport).

Remarks

Required

TimeGreaterThanOrEqualTo

Declaration

[HttpConverter(TargetEnum.Query, "timeGreaterThanOrEqualTo")]
public DateTime? TimeGreaterThanOrEqualTo { get; set; }

Property Value

Type	Description
DateTime?	The optional greater than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z

TimeLessThanOrEqualTo

Declaration

[HttpConverter(TargetEnum.Query, "timeLessThanOrEqualTo")]
public DateTime? TimeLessThanOrEqualTo { get; set; }

Property Value

Type	Description
DateTime?	The optional less than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z

Implements

IOciRequest