Class ListSqlPlansRequest
Implements
Inherited Members
Namespace: Oci.OpsiService.Requests
Assembly: OCI.DotNetSDK.Opsi.dll
Syntax
public class ListSqlPlansRequest : IOciRequest
Examples
Click here to see an example of how to use ListSqlPlans request.
Properties
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 |
PlanHash
Declaration
[Required(ErrorMessage = "PlanHash is required.")]
[HttpConverter(TargetEnum.Query, "planHash", CollectionFormatType.Multi)]
public List<long> PlanHash { get; set; }
Property Value
Type | Description |
---|---|
List<long> | Unique plan hash for a SQL Plan of a particular SQL Statement. Example: 9820154385 |
Remarks
Required
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