Class ListSqlPlanBaselinesRequest

Inheritance

object

ListSqlPlanBaselinesRequest

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.DatabasemanagementService.Requests

Assembly: OCI.DotNetSDK.Databasemanagement.dll

Syntax

public class ListSqlPlanBaselinesRequest : IOciRequest

Examples

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

Properties

IsAccepted

Declaration

[HttpConverter(TargetEnum.Query, "isAccepted")]
public bool? IsAccepted { get; set; }

Property Value

Type	Description
bool?	A filter to return only SQL plan baselines that are either accepted or not accepted. By default, all SQL plan baselines are returned.

IsAdaptive

Declaration

[HttpConverter(TargetEnum.Query, "isAdaptive")]
public bool? IsAdaptive { get; set; }

Property Value

Type	Description
bool?	A filter to return only SQL plan baselines that are either adaptive or not adaptive. By default, all SQL plan baselines are returned.

IsAutoPurged

Declaration

[HttpConverter(TargetEnum.Query, "isAutoPurged")]
public bool? IsAutoPurged { get; set; }

Property Value

Type	Description
bool?	A filter to return only SQL plan baselines that are either auto-purged or not auto-purged. By default, all SQL plan baselines are returned.

IsEnabled

Declaration

[HttpConverter(TargetEnum.Query, "isEnabled")]
public bool? IsEnabled { get; set; }

Property Value

Type	Description
bool?	A filter to return only SQL plan baselines that are either enabled or not enabled. By default, all SQL plan baselines are returned.

IsFixed

Declaration

[HttpConverter(TargetEnum.Query, "isFixed")]
public bool? IsFixed { get; set; }

Property Value

Type	Description
bool?	A filter to return only SQL plan baselines that are either fixed or not fixed. By default, all SQL plan baselines are returned.

IsNeverExecuted

Declaration

[HttpConverter(TargetEnum.Query, "isNeverExecuted")]
public bool? IsNeverExecuted { get; set; }

Property Value

Type	Description
bool?	A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned.

IsReproduced

Declaration

[HttpConverter(TargetEnum.Query, "isReproduced")]
public bool? IsReproduced { get; set; }

Property Value

Type	Description
bool?	A filter to return only SQL plan baselines that were either reproduced or not reproduced by the optimizer. By default, all SQL plan baselines are returned.

Limit

Declaration

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

Property Value

Type	Description
int?	The maximum number of records returned in the paginated response.

ManagedDatabaseId

Declaration

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

Property Value

Type	Description
string	The OCID of the Managed Database.

Remarks

Required

OpcNamedCredentialId

Declaration

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

Property Value

Type	Description
string	The OCID of the Named Credential.

OpcRequestId

Declaration

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

Property Value

Type	Description
string	The client request ID for tracing.

Origin

Declaration

[HttpConverter(TargetEnum.Query, "origin")]
public SqlPlanBaselineOrigin? Origin { get; set; }

Property Value

Type	Description
SqlPlanBaselineOrigin?	A filter to return all the SQL plan baselines that match the origin.

Page

Declaration

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

Property Value

Type	Description
string	The page token representing the page from where the next set of paginated results are retrieved. This is usually retrieved from a previous list call.

PlanName

Declaration

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

Property Value

Type	Description
string	A filter to return only SQL plan baselines that match the plan name.

SortBy

Declaration

[HttpConverter(TargetEnum.Query, "sortBy")]
public ListSqlPlanBaselinesRequest.SortByEnum? SortBy { get; set; }

Property Value

Type	Description
ListSqlPlanBaselinesRequest.SortByEnum?	The option to sort the SQL plan baseline summary data.

SortOrder

Declaration

[HttpConverter(TargetEnum.Query, "sortOrder")]
public SortOrders? SortOrder { get; set; }

Property Value

Type	Description
SortOrders?	The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order. Descending order is the default order.

SqlHandle

Declaration

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

Property Value

Type	Description
string	A filter to return all the SQL plan baselines for the specified SQL handle.

SqlText

Declaration

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

Property Value

Type	Description
string	A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.

TimeLastExecutedGreaterThan

Declaration

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

Property Value

Type	Description
DateTime?	A filter to return only SQL plan baselines whose last execution time is after the specified value. By default, all SQL plan baselines are returned.

TimeLastExecutedLessThan

Declaration

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

Property Value

Type	Description
DateTime?	A filter to return only SQL plan baselines whose last execution time is before the specified value. By default, all SQL plan baselines are returned.

Implements

IOciRequest