Package com.oracle.bmc.opsi.model

Class SqlInsightAggregation.Builder

    • Constructor Detail

      • Builder

        public Builder()

    • Method Detail

      • text

        public SqlInsightAggregation.Builder text​(String text)
        Insight text.

        For example Degrading SQLs, Variant SQLs, Inefficient SQLs, Improving SQLs, SQLs with Plan Changes, Degrading SQLs have increasing IO Time above 50%, Degrading SQLs are variant, 2 of the 2 variant SQLs have plan changes, Inefficient SQLs have increasing CPU Time above 50%

        Parameters:
        text - the value to set
        Returns:
        this builder

      • values

        public SqlInsightAggregation.Builder values​(List<Integer> values)
        SQL counts for a given insight.

        For example insight text 2 of 10 SQLs have degrading response time will have values as [2,10]"

        Parameters:
        values - the value to set
        Returns:
        this builder

      • category

        public SqlInsightAggregation.Builder category​(String category)
        Insight category.

        It would be one of the following DEGRADING, VARIANT, INEFFICIENT, CHANGING_PLANS, IMPROVING, DEGRADING_VARIANT, DEGRADING_INEFFICIENT, DEGRADING_CHANGING_PLANS, DEGRADING_INCREASING_IO, DEGRADING_INCREASING_CPU, DEGRADING_INCREASING_INEFFICIENT_WAIT, DEGRADING_CHANGING_PLANS_AND_INCREASING_IO, DEGRADING_CHANGING_PLANS_AND_INCREASING_CPU, DEGRADING_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT,VARIANT_INEFFICIENT, VARIANT_CHANGING_PLANS, VARIANT_INCREASING_IO, VARIANT_INCREASING_CPU, VARIANT_INCREASING_INEFFICIENT_WAIT, VARIANT_CHANGING_PLANS_AND_INCREASING_IO, VARIANT_CHANGING_PLANS_AND_INCREASING_CPU, VARIANT_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT, INEFFICIENT_CHANGING_PLANS, INEFFICIENT_INCREASING_INEFFICIENT_WAIT, INEFFICIENT_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT

        Parameters:
        category - the value to set
        Returns:
        this builder