Class SqlTuningSet.Builder

    • Constructor Detail

      • Builder

        public Builder()
    • Method Detail

      • id

        public SqlTuningSet.Builder id​(Integer id)
        The unique Sql tuning set identifier.
        Parameters:
        id - the value to set
        Returns:
        this builder
      • owner

        public SqlTuningSet.Builder owner​(String owner)
        The owner of the Sql tuning set.
        Parameters:
        owner - the value to set
        Returns:
        this builder
      • name

        public SqlTuningSet.Builder name​(String name)
        The name of the Sql tuning set.
        Parameters:
        name - the value to set
        Returns:
        this builder
      • statementCount

        public SqlTuningSet.Builder statementCount​(Integer statementCount)
        Number of statements in the Sql tuning set
        Parameters:
        statementCount - the value to set
        Returns:
        this builder
      • timeCreated

        public SqlTuningSet.Builder timeCreated​(Date timeCreated)
        The created time of the Sql tuning set.
        Parameters:
        timeCreated - the value to set
        Returns:
        this builder
      • description

        public SqlTuningSet.Builder description​(String description)
        The description of the Sql tuning set.
        Parameters:
        description - the value to set
        Returns:
        this builder
      • timeLastModified

        public SqlTuningSet.Builder timeLastModified​(Date timeLastModified)
        Last modified time of the Sql tuning set.
        Parameters:
        timeLastModified - the value to set
        Returns:
        this builder
      • scheduledJobName

        public SqlTuningSet.Builder scheduledJobName​(String scheduledJobName)
        Name of the Sql tuning set scheduler job.
        Parameters:
        scheduledJobName - the value to set
        Returns:
        this builder
      • errorMessage

        public SqlTuningSet.Builder errorMessage​(String errorMessage)
        Latest execution error of the plsql that was submitted as a scheduler job.
        Parameters:
        errorMessage - the value to set
        Returns:
        this builder
      • allSqlStatementsFetched

        public SqlTuningSet.Builder allSqlStatementsFetched​(SqlTuningSet.AllSqlStatementsFetched allSqlStatementsFetched)
        In OCI database management, there is a limit to fetch only 2000 rows.

        This flag indicates whether all Sql statements of this Sql tuning set matching the filter criteria are fetched or not. Possible values are ‘Yes’ or ‘No’ - Yes - All Sql statements matching the filter criteria are fetched. - No - There are more Sql statements matching the fitler criteria. User should fine tune the filter criteria to narrow down the result set.

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