Class SummarizeSqlPlanInsightsRequest

Inheritance
object
SummarizeSqlPlanInsightsRequest
Implements
Inherited Members
Namespace: Oci.OpsiService.Requests
Assembly: OCI.DotNetSDK.Opsi.dll
Syntax
public class SummarizeSqlPlanInsightsRequest : IOciRequest
Examples

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

Properties

AnalysisTimeInterval

Declaration
[HttpConverter(TargetEnum.Query, "analysisTimeInterval")]
public string AnalysisTimeInterval { get; set; }
Property Value
Type Description
string

Specify time period in ISO 8601 format with respect to current time. Default is last 30 days represented by P30D. If timeInterval is specified, then timeIntervalStart and timeIntervalEnd will be ignored. Examples P90D (last 90 days), P4W (last 4 weeks), P2M (last 2 months), P1Y (last 12 months), . Maximum value allowed is 25 months prior to current time (P25M).

CompartmentId

Declaration
[Required(ErrorMessage = "CompartmentId is required.")]
[HttpConverter(TargetEnum.Query, "compartmentId")]
public string CompartmentId { get; set; }
Property Value
Type Description
string

The OCID of the compartment.
Remarks

Required

DatabaseId

Declaration
[HttpConverter(TargetEnum.Query, "databaseId")]
public string DatabaseId { get; set; }
Property Value
Type Description
string

Optional OCID of the associated DBaaS entity.

Id

Declaration
[HttpConverter(TargetEnum.Query, "id")]
public string Id { get; set; }
Property Value
Type Description
string

OCID of the database insight resource.

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.

Page

Declaration
[HttpConverter(TargetEnum.Query, "page")]
public string Page { get; set; }
Property Value
Type Description
string

For list pagination. The value of the opc-next-page response header from the previous "List" call. For important details about how pagination works, see List Pagination.

SqlIdentifier

Declaration
[Required(ErrorMessage = "SqlIdentifier is required.")]
[HttpConverter(TargetEnum.Query, "sqlIdentifier")]
public string SqlIdentifier { get; set; }
Property Value
Type Description
string

Unique SQL_ID for a SQL Statement. Example: 6rgjh9bjmy2s7
Remarks

Required

TimeIntervalEnd

Declaration
[HttpConverter(TargetEnum.Query, "timeIntervalEnd")]
public DateTime? TimeIntervalEnd { get; set; }
Property Value
Type Description
DateTime?

Analysis end time in UTC in ISO 8601 format(exclusive). Example 2019-10-30T00:00:00Z (yyyy-MM-ddThh:mm:ssZ). timeIntervalStart and timeIntervalEnd are used together. If timeIntervalEnd is not specified, current time is used as timeIntervalEnd.

TimeIntervalStart

Declaration
[HttpConverter(TargetEnum.Query, "timeIntervalStart")]
public DateTime? TimeIntervalStart { get; set; }
Property Value
Type Description
DateTime?

Analysis start time in UTC in ISO 8601 format(inclusive). Example 2019-10-30T00:00:00Z (yyyy-MM-ddThh:mm:ssZ). The minimum allowed value is 2 years prior to the current day. timeIntervalStart and timeIntervalEnd parameters are used together. If analysisTimeInterval is specified, this parameter is ignored.

Implements