Show / Hide Table of Contents

Class ListSqlPlansRequest

Inheritance
object
ListSqlPlansRequest
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 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 opc-next-page response header from the previous "List" call. For important details about how pagination works, see List Pagination.

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

Implements

IOciRequest
In this article
Back to top