SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary¶

class oci.database_management.models.SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary(**kwargs)¶

Bases: object

A summary for all the statistic findings of an object in a SQL Tuning Advisor task. Includes the object’s hash, name, type, schema, problem type and the object reference count.

Attributes

`PROBLEM_TYPE_MISSING`	A constant which can be used with the problem_type property of a SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
`PROBLEM_TYPE_STALE`	A constant which can be used with the problem_type property of a SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
`object_hash_value`	[Required] Gets the object_hash_value of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
`object_name`	[Required] Gets the object_name of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
`object_type`	[Required] Gets the object_type of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
`problem_type`	[Required] Gets the problem_type of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
`reference_count`	[Required] Gets the reference_count of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
`schema`	[Required] Gets the schema of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.

Methods

__init__(**kwargs) Initializes a new SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary object with values from keyword arguments.

PROBLEM_TYPE_MISSING = 'MISSING'¶: A constant which can be used with the problem_type property of a SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary. This constant has a value of “MISSING”

PROBLEM_TYPE_STALE = 'STALE'¶: A constant which can be used with the problem_type property of a SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary. This constant has a value of “STALE”

__init__(**kwargs)¶

Initializes a new SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

object_hash_value (int) – The value to assign to the object_hash_value property of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
object_name (str) – The value to assign to the object_name property of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
object_type (str) – The value to assign to the object_type property of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
schema (str) – The value to assign to the schema property of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
problem_type (str) – The value to assign to the problem_type property of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary. Allowed values for this property are: “MISSING”, “STALE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
reference_count (int) – The value to assign to the reference_count property of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.

object_hash_value¶

[Required] Gets the object_hash_value of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary. Numerical representation of the object.

Returns:	The object_hash_value of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
Return type:	int

object_name¶

[Required] Gets the object_name of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary. Name of the object.

Returns:	The object_name of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
Return type:	str

object_type¶

[Required] Gets the object_type of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary. Type of the object.

Returns:	The object_type of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
Return type:	str

problem_type¶

[Required] Gets the problem_type of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary. Type of statistics problem related to the object.

Allowed values for this property are: “MISSING”, “STALE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The problem_type of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
Return type:	str

reference_count¶

[Required] Gets the reference_count of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary. The number of the times the object is referenced within the SQL Tuning advisor task findings.

Returns:	The reference_count of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
Return type:	int

schema¶

[Required] Gets the schema of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary. Schema of the object.

Returns:	The schema of this SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary.
Return type:	str