Class FetchSqlTuningSetDetails
The details required to fetch the Sql tuning set details. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredential
Inherited Members
Namespace: Oci.DatabasemanagementService.Models
Assembly: OCI.DotNetSDK.Databasemanagement.dll
Syntax
public class FetchSqlTuningSetDetails
Properties
BasicFilter
Declaration
[JsonProperty(PropertyName = "basicFilter")]
public string BasicFilter { get; set; }
Property Value
Type | Description |
---|---|
string | Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW. User could use any combination of the following columns with appropriate values as Sql predicate Refer to the documentation https://docs.oracle.com/en/database/oracle/oracle-database/18/arpls/DBMS_SQLTUNE.html#GUID-1F4AFB03-7B29-46FC-B3F2-CB01EC36326C |
CredentialDetails
Declaration
[JsonProperty(PropertyName = "credentialDetails")]
public SqlTuningSetAdminCredentialDetails CredentialDetails { get; set; }
Property Value
Type | Description |
---|---|
SqlTuningSetAdminCredentialDetails |
DatabaseCredential
Declaration
[JsonProperty(PropertyName = "databaseCredential")]
public DatabaseCredentialDetails DatabaseCredential { get; set; }
Property Value
Type | Description |
---|---|
DatabaseCredentialDetails |
Name
Declaration
[Required(ErrorMessage = "Name is required.")]
[JsonProperty(PropertyName = "name")]
public string Name { get; set; }
Property Value
Type | Description |
---|---|
string | The name of the Sql tuning set. |
Remarks
Required
Owner
Declaration
[Required(ErrorMessage = "Owner is required.")]
[JsonProperty(PropertyName = "owner")]
public string Owner { get; set; }
Property Value
Type | Description |
---|---|
string | The owner of the Sql tuning set. |
Remarks
Required
RankingMeasure1
Declaration
[JsonProperty(PropertyName = "rankingMeasure1")]
[JsonConverter(typeof(StringEnumConverter))]
public RankingMeasure? RankingMeasure1 { get; set; }
Property Value
Type | Description |
---|---|
RankingMeasure? | Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures. |
RankingMeasure2
Declaration
[JsonProperty(PropertyName = "rankingMeasure2")]
[JsonConverter(typeof(StringEnumConverter))]
public RankingMeasure? RankingMeasure2 { get; set; }
Property Value
Type | Description |
---|---|
RankingMeasure? | Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures. |
RankingMeasure3
Declaration
[JsonProperty(PropertyName = "rankingMeasure3")]
[JsonConverter(typeof(StringEnumConverter))]
public RankingMeasure? RankingMeasure3 { get; set; }
Property Value
Type | Description |
---|---|
RankingMeasure? | Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures. |
RecursiveSql
Declaration
[JsonProperty(PropertyName = "recursiveSql")]
[JsonConverter(typeof(StringEnumConverter))]
public FetchSqlTuningSetDetails.RecursiveSqlEnum? RecursiveSql { get; set; }
Property Value
Type | Description |
---|---|
FetchSqlTuningSetDetails.RecursiveSqlEnum? | Specifies that the filter must include recursive Sql in the Sql tuning set. |
ResultLimit
Declaration
[JsonProperty(PropertyName = "resultLimit")]
public int? ResultLimit { get; set; }
Property Value
Type | Description |
---|---|
int? | The top limit Sql from the filtered source, ranked by the ranking measure. |
ResultPercentage
Declaration
[JsonProperty(PropertyName = "resultPercentage")]
public double ResultPercentage { get; set; }
Property Value
Type | Description |
---|---|
double | Specifies a filter that picks the top n% according to the supplied ranking measure. Note that this parameter applies only if one ranking measure is supplied. |