// This is an automatically generated code sample. 
// To make this code sample work in your Oracle Cloud tenancy, 
// please replace the values for any parameters whose current values do not fit
// your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and 
// boolean, number, and enum parameters with values not fitting your use case).

import * as databasemanagement from "oci-databasemanagement";
import common = require("oci-common");

// Create a default authentication provider that uses the DEFAULT
// profile in the configuration file.
// Refer to <see href="https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File>the public documentation</see> on how to prepare a configuration file.

const provider: common.ConfigFileAuthenticationDetailsProvider = new common.ConfigFileAuthenticationDetailsProvider();

(async () => {
    try {
     // Create a service client
     const client = new databasemanagement.SqlTuningClient({ authenticationDetailsProvider: provider });

     // Create a request and dependent object(s).
	const  saveSqlTuningSetAsDetails = {
		credentialDetails: {
			sqlTuningSetAdminCredentialType: "SECRET",			secretId: "ocid1.test.oc1..<unique_ID>EXAMPLE-secretId-Value",
			username: "EXAMPLE-username-Value",
			role: databasemanagement.models.SqlTuningSetAdminCredentialDetails.Role.Sysdba

			}
,
		databaseCredential: {
			credentialType: "SECRET",			passwordSecretId: "ocid1.test.oc1..<unique_ID>EXAMPLE-passwordSecretId-Value",
			username: "EXAMPLE-username-Value",
			role: databasemanagement.models.DatabaseSecretCredentialDetails.Role.Sysdg

			}
,
		showSqlOnly: 314,
		owner: "EXAMPLE-owner-Value",
		name: "EXAMPLE-name-Value",
		destinationSqlTuningSetName: "EXAMPLE-destinationSqlTuningSetName-Value",
		destinationSqlTuningSetDescription: "EXAMPLE-destinationSqlTuningSetDescription-Value",
		destinationSqlTuningSetOwner: "EXAMPLE-destinationSqlTuningSetOwner-Value",
		createNew: 655,
		basicFilter: "EXAMPLE-basicFilter-Value",
		planFilter: databasemanagement.models.SaveSqlTuningSetAsDetails.PlanFilter.MaxElapsedTime,
		recursiveSql: databasemanagement.models.SaveSqlTuningSetAsDetails.RecursiveSql.HasRecursiveSql,
		resultPercentage: 3734.1338,
		resultLimit: 902,
		rankingMeasure1: databasemanagement.models.RankingMeasure.OptimizerCost,
		rankingMeasure2: databasemanagement.models.RankingMeasure.BufferGets,
		rankingMeasure3: databasemanagement.models.RankingMeasure.CpuTime,
		attributeList: "EXAMPLE-attributeList-Value",
		loadOption: databasemanagement.models.SaveSqlTuningSetAsDetails.LoadOption.Insert,
		updateOption: databasemanagement.models.SaveSqlTuningSetAsDetails.UpdateOption.Accumulate,
		updateCondition: databasemanagement.models.SaveSqlTuningSetAsDetails.UpdateCondition.Old,
		updateAttributes: "EXAMPLE-updateAttributes-Value",
		isIgnoreNull: false,
		commitRows: 38,

		}

	const saveSqlTuningSetAsRequest: databasemanagement.requests.SaveSqlTuningSetAsRequest = { 
	managedDatabaseId: "ocid1.test.oc1..<unique_ID>EXAMPLE-managedDatabaseId-Value",
	sqlTuningSetId: 55,
	saveSqlTuningSetAsDetails: saveSqlTuningSetAsDetails,
	opcRequestId: "QPLDJVYHARHGOH4LO1LI<unique_ID>",
	opcRetryToken: "EXAMPLE-opcRetryToken-Value",

		}; 


     // Send request to the Client.
     const saveSqlTuningSetAsResponse = await client.saveSqlTuningSetAs(saveSqlTuningSetAsRequest);
     }
     catch (error) {
         console.log("saveSqlTuningSetAs Failed with error  " + error);
     }
})();