Class FetchSqlTuningSetDetails

The details required to fetch the Sql tuning set details. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredential

Inheritance
object
FetchSqlTuningSetDetails
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.