@Generated(value="OracleSDKGenerator", comments="API Version: 20201101") public class DbManagementClient extends BaseSyncClient implements DbManagement
Modifier and Type | Class and Description |
---|---|
static class |
DbManagementClient.Builder
Builder class for this client.
|
Modifier and Type | Field and Description |
---|---|
static Service |
SERVICE
Service instance for DbManagement.
|
Constructor and Description |
---|
DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider,
ClientConfiguration configuration,
ClientConfigurator clientConfigurator,
RequestSignerFactory defaultRequestSignerFactory)
Deprecated.
Use the
builder instead. |
DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider,
ClientConfiguration configuration,
ClientConfigurator clientConfigurator,
RequestSignerFactory defaultRequestSignerFactory,
List<ClientConfigurator> additionalClientConfigurators)
Deprecated.
Use the
builder instead. |
DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider,
ClientConfiguration configuration,
ClientConfigurator clientConfigurator,
RequestSignerFactory defaultRequestSignerFactory,
List<ClientConfigurator> additionalClientConfigurators,
String endpoint)
Deprecated.
Use the
builder instead. |
DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider,
ClientConfiguration configuration,
ClientConfigurator clientConfigurator,
RequestSignerFactory defaultRequestSignerFactory,
Map<SigningStrategy,RequestSignerFactory> signingStrategyRequestSignerFactories,
List<ClientConfigurator> additionalClientConfigurators,
String endpoint)
Deprecated.
Use the
builder instead. |
DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider,
ClientConfiguration configuration,
ClientConfigurator clientConfigurator,
RequestSignerFactory defaultRequestSignerFactory,
Map<SigningStrategy,RequestSignerFactory> signingStrategyRequestSignerFactories,
List<ClientConfigurator> additionalClientConfigurators,
String endpoint,
ExecutorService executorService)
Deprecated.
Use the
builder instead. |
DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider)
Deprecated.
Use the
builder instead. |
DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider,
ClientConfiguration configuration)
Deprecated.
Use the
builder instead. |
DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider,
ClientConfiguration configuration,
ClientConfigurator clientConfigurator)
Deprecated.
Use the
builder instead. |
Modifier and Type | Method and Description |
---|---|
AddDataFilesResponse |
addDataFiles(AddDataFilesRequest request)
Adds data files or temp files to the tablespace.
|
AddManagedDatabaseToManagedDatabaseGroupResponse |
addManagedDatabaseToManagedDatabaseGroup(AddManagedDatabaseToManagedDatabaseGroupRequest request)
Adds a Managed Database to a specific Managed Database Group.
|
AddmTasksResponse |
addmTasks(AddmTasksRequest request)
Lists the metadata for each ADDM task who’s end snapshot time falls within the provided start
and end time.
|
static DbManagementClient.Builder |
builder()
Create a builder for this client.
|
ChangeDatabaseParametersResponse |
changeDatabaseParameters(ChangeDatabaseParametersRequest request)
Changes database parameter values.
|
ChangeDbManagementPrivateEndpointCompartmentResponse |
changeDbManagementPrivateEndpointCompartment(ChangeDbManagementPrivateEndpointCompartmentRequest request)
Moves the Database Management private endpoint and its dependent resources to the specified
compartment.
|
ChangeExternalDbSystemCompartmentResponse |
changeExternalDbSystemCompartment(ChangeExternalDbSystemCompartmentRequest request)
Moves the external DB system and its related resources (excluding databases) to the specified
compartment.
|
ChangeExternalExadataInfrastructureCompartmentResponse |
changeExternalExadataInfrastructureCompartment(ChangeExternalExadataInfrastructureCompartmentRequest request)
Moves the Exadata infrastructure and its related resources (Exadata storage server, Exadata
storage server connectors and Exadata storage server grid) to the specified compartment.
|
ChangeJobCompartmentResponse |
changeJobCompartment(ChangeJobCompartmentRequest request)
Moves a job.
|
ChangeManagedDatabaseGroupCompartmentResponse |
changeManagedDatabaseGroupCompartment(ChangeManagedDatabaseGroupCompartmentRequest request)
Moves a Managed Database Group to a different compartment.
|
ChangePlanRetentionResponse |
changePlanRetention(ChangePlanRetentionRequest request)
Changes the retention period of unused plans.
|
ChangeSpaceBudgetResponse |
changeSpaceBudget(ChangeSpaceBudgetRequest request)
Changes the disk space limit for the SQL Management Base.
|
ChangeSqlPlanBaselinesAttributesResponse |
changeSqlPlanBaselinesAttributes(ChangeSqlPlanBaselinesAttributesRequest request)
Changes one or more attributes of a single plan or all plans associated with a SQL statement.
|
CheckExternalDbSystemConnectorConnectionStatusResponse |
checkExternalDbSystemConnectorConnectionStatus(CheckExternalDbSystemConnectorConnectionStatusRequest request)
Checks the status of the external DB system component connection specified in this connector.
|
CheckExternalExadataStorageConnectorResponse |
checkExternalExadataStorageConnector(CheckExternalExadataStorageConnectorRequest request)
Checks the status of the Exadata storage server connection specified by
exadataStorageConnectorId.
|
void |
close() |
ConfigureAutomaticCaptureFiltersResponse |
configureAutomaticCaptureFilters(ConfigureAutomaticCaptureFiltersRequest request)
Configures automatic capture filters to capture only those statements that match the filter
criteria.
|
ConfigureAutomaticSpmEvolveAdvisorTaskResponse |
configureAutomaticSpmEvolveAdvisorTask(ConfigureAutomaticSpmEvolveAdvisorTaskRequest request)
Configures the Automatic SPM Evolve Advisor task
SYS_AUTO_SPM_EVOLVE_TASK by specifying
task parameters. |
CreateDbManagementPrivateEndpointResponse |
createDbManagementPrivateEndpoint(CreateDbManagementPrivateEndpointRequest request)
Creates a new Database Management private endpoint.
|
CreateExternalDbSystemResponse |
createExternalDbSystem(CreateExternalDbSystemRequest request)
Creates an external DB system and its related resources.
|
CreateExternalDbSystemConnectorResponse |
createExternalDbSystemConnector(CreateExternalDbSystemConnectorRequest request)
Creates a new external connector.
|
CreateExternalDbSystemDiscoveryResponse |
createExternalDbSystemDiscovery(CreateExternalDbSystemDiscoveryRequest request)
Creates an external DB system discovery resource and initiates the discovery process.
|
CreateExternalExadataInfrastructureResponse |
createExternalExadataInfrastructure(CreateExternalExadataInfrastructureRequest request)
Creates an OCI resource for the Exadata infrastructure and enables the Monitoring service for
the Exadata infrastructure.
|
CreateExternalExadataStorageConnectorResponse |
createExternalExadataStorageConnector(CreateExternalExadataStorageConnectorRequest request)
Creates the Exadata storage server connector after validating the connection information.
|
CreateJobResponse |
createJob(CreateJobRequest request)
Creates a job to be executed on a Managed Database or Managed Database Group.
|
CreateManagedDatabaseGroupResponse |
createManagedDatabaseGroup(CreateManagedDatabaseGroupRequest request)
Creates a Managed Database Group.
|
CreateTablespaceResponse |
createTablespace(CreateTablespaceRequest request)
Creates a tablespace within the Managed Database specified by managedDatabaseId.
|
DeleteDbManagementPrivateEndpointResponse |
deleteDbManagementPrivateEndpoint(DeleteDbManagementPrivateEndpointRequest request)
Deletes a specific Database Management private endpoint.
|
DeleteExternalDbSystemResponse |
deleteExternalDbSystem(DeleteExternalDbSystemRequest request)
Deletes the external DB system specified by
externalDbSystemId . |
DeleteExternalDbSystemConnectorResponse |
deleteExternalDbSystemConnector(DeleteExternalDbSystemConnectorRequest request)
Deletes the external connector specified by
externalDbSystemConnectorId . |
DeleteExternalDbSystemDiscoveryResponse |
deleteExternalDbSystemDiscovery(DeleteExternalDbSystemDiscoveryRequest request)
Deletes the external DB system discovery resource specified by
externalDbSystemDiscoveryId . |
DeleteExternalExadataInfrastructureResponse |
deleteExternalExadataInfrastructure(DeleteExternalExadataInfrastructureRequest request)
Deletes the Exadata infrastructure specified by externalExadataInfrastructureId.
|
DeleteExternalExadataStorageConnectorResponse |
deleteExternalExadataStorageConnector(DeleteExternalExadataStorageConnectorRequest request)
Deletes the Exadata storage server connector specified by exadataStorageConnectorId.
|
DeleteJobResponse |
deleteJob(DeleteJobRequest request)
Deletes the job specified by jobId.
|
DeleteManagedDatabaseGroupResponse |
deleteManagedDatabaseGroup(DeleteManagedDatabaseGroupRequest request)
Deletes the Managed Database Group specified by managedDatabaseGroupId.
|
DeletePreferredCredentialResponse |
deletePreferredCredential(DeletePreferredCredentialRequest request)
Deletes the preferred credential based on the credentialName.
|
DisableAutomaticInitialPlanCaptureResponse |
disableAutomaticInitialPlanCapture(DisableAutomaticInitialPlanCaptureRequest request)
Disables automatic initial plan capture.
|
DisableAutomaticSpmEvolveAdvisorTaskResponse |
disableAutomaticSpmEvolveAdvisorTask(DisableAutomaticSpmEvolveAdvisorTaskRequest request)
Disables the Automatic SPM Evolve Advisor task.
|
DisableExternalDbSystemDatabaseManagementResponse |
disableExternalDbSystemDatabaseManagement(DisableExternalDbSystemDatabaseManagementRequest request)
Disables Database Management service for all the components of the specified external DB
system (except databases).
|
DisableExternalDbSystemStackMonitoringResponse |
disableExternalDbSystemStackMonitoring(DisableExternalDbSystemStackMonitoringRequest request)
Disables Stack Monitoring for all the components of the specified external DB system (except
databases).
|
DisableExternalExadataInfrastructureManagementResponse |
disableExternalExadataInfrastructureManagement(DisableExternalExadataInfrastructureManagementRequest request)
Disables Database Management for the Exadata infrastructure specified by
externalExadataInfrastructureId.
|
DisableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse |
disableHighFrequencyAutomaticSpmEvolveAdvisorTask(DisableHighFrequencyAutomaticSpmEvolveAdvisorTaskRequest request)
Disables the high-frequency Automatic SPM Evolve Advisor task.
|
DisableSqlPlanBaselinesUsageResponse |
disableSqlPlanBaselinesUsage(DisableSqlPlanBaselinesUsageRequest request)
Disables the use of SQL plan baselines stored in SQL Management Base.
|
DiscoverExternalExadataInfrastructureResponse |
discoverExternalExadataInfrastructure(DiscoverExternalExadataInfrastructureRequest request)
Completes the Exadata system prechecking on the following:
|
DropSqlPlanBaselinesResponse |
dropSqlPlanBaselines(DropSqlPlanBaselinesRequest request)
Drops a single plan or all plans associated with a SQL statement.
|
DropTablespaceResponse |
dropTablespace(DropTablespaceRequest request)
Drops the tablespace specified by tablespaceName within the Managed Database specified by
managedDatabaseId.
|
EnableAutomaticInitialPlanCaptureResponse |
enableAutomaticInitialPlanCapture(EnableAutomaticInitialPlanCaptureRequest request)
Enables automatic initial plan capture.
|
EnableAutomaticSpmEvolveAdvisorTaskResponse |
enableAutomaticSpmEvolveAdvisorTask(EnableAutomaticSpmEvolveAdvisorTaskRequest request)
Enables the Automatic SPM Evolve Advisor task.
|
EnableExternalDbSystemDatabaseManagementResponse |
enableExternalDbSystemDatabaseManagement(EnableExternalDbSystemDatabaseManagementRequest request)
Enables Database Management service for all the components of the specified external DB
system (except databases).
|
EnableExternalDbSystemStackMonitoringResponse |
enableExternalDbSystemStackMonitoring(EnableExternalDbSystemStackMonitoringRequest request)
Enables Stack Monitoring for all the components of the specified external DB system (except
databases).
|
EnableExternalExadataInfrastructureManagementResponse |
enableExternalExadataInfrastructureManagement(EnableExternalExadataInfrastructureManagementRequest request)
Enables Database Management for the Exadata infrastructure specified by
externalExadataInfrastructureId.
|
EnableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse |
enableHighFrequencyAutomaticSpmEvolveAdvisorTask(EnableHighFrequencyAutomaticSpmEvolveAdvisorTaskRequest request)
Enables the high-frequency Automatic SPM Evolve Advisor task.
|
EnableSqlPlanBaselinesUsageResponse |
enableSqlPlanBaselinesUsage(EnableSqlPlanBaselinesUsageRequest request)
Enables the use of SQL plan baselines stored in SQL Management Base.
|
GenerateAwrSnapshotResponse |
generateAwrSnapshot(GenerateAwrSnapshotRequest request)
Creates an AWR snapshot for the target database.
|
GetAwrDbReportResponse |
getAwrDbReport(GetAwrDbReportRequest request)
Gets the AWR report for the specific database.
|
GetAwrDbSqlReportResponse |
getAwrDbSqlReport(GetAwrDbSqlReportRequest request)
Gets the SQL health check report for one SQL of the specific database.
|
GetClusterCacheMetricResponse |
getClusterCacheMetric(GetClusterCacheMetricRequest request)
Gets the metrics related to cluster cache for the Oracle Real Application Clusters (Oracle
RAC) database specified by managedDatabaseId.
|
GetDatabaseFleetHealthMetricsResponse |
getDatabaseFleetHealthMetrics(GetDatabaseFleetHealthMetricsRequest request)
Gets the health metrics for a fleet of databases in a compartment or in a Managed Database
Group.
|
GetDatabaseHomeMetricsResponse |
getDatabaseHomeMetrics(GetDatabaseHomeMetricsRequest request)
Gets a summary of the activity and resource usage metrics like DB Time, CPU, User I/O, Wait,
Storage, and Memory for a Managed Database.
|
GetDbManagementPrivateEndpointResponse |
getDbManagementPrivateEndpoint(GetDbManagementPrivateEndpointRequest request)
Gets the details of a specific Database Management private endpoint.
|
protected ClientConfigurator |
getDefaultConfigurator() |
String |
getEndpoint() |
GetExternalAsmResponse |
getExternalAsm(GetExternalAsmRequest request)
Gets the details for the external ASM specified by
externalAsmId . |
GetExternalAsmConfigurationResponse |
getExternalAsmConfiguration(GetExternalAsmConfigurationRequest request)
Gets configuration details including disk groups for the external ASM specified by
externalAsmId . |
GetExternalAsmInstanceResponse |
getExternalAsmInstance(GetExternalAsmInstanceRequest request)
Gets the details for the external ASM instance specified by
externalAsmInstanceId . |
GetExternalClusterResponse |
getExternalCluster(GetExternalClusterRequest request)
Gets the details for the external cluster specified by
externalClusterId . |
GetExternalClusterInstanceResponse |
getExternalClusterInstance(GetExternalClusterInstanceRequest request)
Gets the details for the external cluster instance specified by
externalClusterInstanceId . |
GetExternalDbHomeResponse |
getExternalDbHome(GetExternalDbHomeRequest request)
Gets the details for the external DB home specified by
externalDbHomeId . |
GetExternalDbNodeResponse |
getExternalDbNode(GetExternalDbNodeRequest request)
Gets the details for the external DB node specified by
externalDbNodeId . |
GetExternalDbSystemResponse |
getExternalDbSystem(GetExternalDbSystemRequest request)
Gets the details for the external DB system specified by
externalDbSystemId . |
GetExternalDbSystemConnectorResponse |
getExternalDbSystemConnector(GetExternalDbSystemConnectorRequest request)
Gets the details for the external connector specified by
externalDbSystemConnectorId . |
GetExternalDbSystemDiscoveryResponse |
getExternalDbSystemDiscovery(GetExternalDbSystemDiscoveryRequest request)
Gets the details for the external DB system discovery resource specified by
externalDbSystemDiscoveryId . |
GetExternalExadataInfrastructureResponse |
getExternalExadataInfrastructure(GetExternalExadataInfrastructureRequest request)
Gets the details for the Exadata infrastructure specified by externalExadataInfrastructureId.
|
GetExternalExadataStorageConnectorResponse |
getExternalExadataStorageConnector(GetExternalExadataStorageConnectorRequest request)
Gets the details for the Exadata storage server connector specified by
exadataStorageConnectorId.
|
GetExternalExadataStorageGridResponse |
getExternalExadataStorageGrid(GetExternalExadataStorageGridRequest request)
Gets the details for the Exadata storage server grid specified by exadataStorageGridId.
|
GetExternalExadataStorageServerResponse |
getExternalExadataStorageServer(GetExternalExadataStorageServerRequest request)
Gets the summary for the Exadata storage server specified by exadataStorageServerId.
|
GetExternalListenerResponse |
getExternalListener(GetExternalListenerRequest request)
Gets the details for the external listener specified by
externalListenerId . |
GetIormPlanResponse |
getIormPlan(GetIormPlanRequest request)
Get the IORM plan from the specific Exadata storage server.
|
GetJobResponse |
getJob(GetJobRequest request)
Gets the details for the job specified by jobId.
|
GetJobExecutionResponse |
getJobExecution(GetJobExecutionRequest request)
Gets the details for the job execution specified by jobExecutionId.
|
GetJobRunResponse |
getJobRun(GetJobRunRequest request)
Gets the details for the job run specified by jobRunId.
|
GetManagedDatabaseResponse |
getManagedDatabase(GetManagedDatabaseRequest request)
Gets the details for the Managed Database specified by managedDatabaseId.
|
GetManagedDatabaseGroupResponse |
getManagedDatabaseGroup(GetManagedDatabaseGroupRequest request)
Gets the details for the Managed Database Group specified by managedDatabaseGroupId.
|
GetOpenAlertHistoryResponse |
getOpenAlertHistory(GetOpenAlertHistoryRequest request)
Gets the open alerts from the specified Exadata storage server.
|
GetOptimizerStatisticsAdvisorExecutionResponse |
getOptimizerStatisticsAdvisorExecution(GetOptimizerStatisticsAdvisorExecutionRequest request)
Gets a comprehensive report of the Optimizer Statistics Advisor execution, which includes
details of the Managed Database, findings, recommendations, rationale, and examples.
|
GetOptimizerStatisticsAdvisorExecutionScriptResponse |
getOptimizerStatisticsAdvisorExecutionScript(GetOptimizerStatisticsAdvisorExecutionScriptRequest request)
Gets the Oracle system-generated script for the specified Optimizer Statistics Advisor
execution.
|
GetOptimizerStatisticsCollectionOperationResponse |
getOptimizerStatisticsCollectionOperation(GetOptimizerStatisticsCollectionOperationRequest request)
Gets a detailed report of the Optimizer Statistics Collection operation for the specified
Managed Database.
|
DbManagementPaginators |
getPaginators()
Gets the pre-configured paginators available for list operations in this service which may
return multiple pages of data.
|
GetPdbMetricsResponse |
getPdbMetrics(GetPdbMetricsRequest request)
Gets a summary of the resource usage metrics such as CPU, User I/O, and Storage for each PDB
within a specific CDB.
|
GetPreferredCredentialResponse |
getPreferredCredential(GetPreferredCredentialRequest request)
Gets the preferred credential details for a Managed Database based on credentialName.
|
GetSqlPlanBaselineResponse |
getSqlPlanBaseline(GetSqlPlanBaselineRequest request)
Gets the SQL plan baseline details for the specified planName.
|
GetSqlPlanBaselineConfigurationResponse |
getSqlPlanBaselineConfiguration(GetSqlPlanBaselineConfigurationRequest request)
Gets the configuration details of SQL plan baselines for the specified Managed Database.
|
GetTablespaceResponse |
getTablespace(GetTablespaceRequest request)
Gets the details of the tablespace specified by tablespaceName within the Managed Database
specified by managedDatabaseId.
|
GetTopSqlCpuActivityResponse |
getTopSqlCpuActivity(GetTopSqlCpuActivityRequest request)
Gets the SQL IDs with the top CPU activity from the Exadata storage server.
|
GetUserResponse |
getUser(GetUserRequest request)
Gets the details of the user specified by managedDatabaseId and userName.
|
DbManagementWaiters |
getWaiters()
Gets the pre-configured waiters available for resources for this service.
|
GetWorkRequestResponse |
getWorkRequest(GetWorkRequestRequest request)
Gets the status of the work request with the given Work Request ID
|
ImplementOptimizerStatisticsAdvisorRecommendationsResponse |
implementOptimizerStatisticsAdvisorRecommendations(ImplementOptimizerStatisticsAdvisorRecommendationsRequest request)
Asynchronously implements the findings and recommendations of the Optimizer Statistics
Advisor execution.
|
ListAsmPropertiesResponse |
listAsmProperties(ListAsmPropertiesRequest request)
Gets the list of ASM properties for the specified managedDatabaseId.
|
ListAssociatedDatabasesResponse |
listAssociatedDatabases(ListAssociatedDatabasesRequest request)
Gets the list of databases using a specific Database Management private endpoint.
|
ListAwrDbsResponse |
listAwrDbs(ListAwrDbsRequest request)
Gets the list of databases and their snapshot summary details available in the AWR of the
specified Managed Database.
|
ListAwrDbSnapshotsResponse |
listAwrDbSnapshots(ListAwrDbSnapshotsRequest request)
Lists AWR snapshots for the specified database in the AWR.
|
ListConsumerGroupPrivilegesResponse |
listConsumerGroupPrivileges(ListConsumerGroupPrivilegesRequest request)
Gets the list of consumer group privileges granted to a specific user.
|
ListCursorCacheStatementsResponse |
listCursorCacheStatements(ListCursorCacheStatementsRequest request)
Lists the SQL statements from shared SQL area, also called the cursor cache.
|
ListDataAccessContainersResponse |
listDataAccessContainers(ListDataAccessContainersRequest request)
Gets the list of containers for a specific user.
|
ListDatabaseParametersResponse |
listDatabaseParameters(ListDatabaseParametersRequest request)
Gets the list of database parameters for the specified Managed Database.
|
ListDbManagementPrivateEndpointsResponse |
listDbManagementPrivateEndpoints(ListDbManagementPrivateEndpointsRequest request)
Gets a list of Database Management private endpoints.
|
ListExternalAsmDiskGroupsResponse |
listExternalAsmDiskGroups(ListExternalAsmDiskGroupsRequest request)
Lists ASM disk groups for the external ASM specified by
externalAsmId . |
ListExternalAsmInstancesResponse |
listExternalAsmInstances(ListExternalAsmInstancesRequest request)
Lists the ASM instances in the specified external ASM.
|
ListExternalAsmsResponse |
listExternalAsms(ListExternalAsmsRequest request)
Lists the ASMs in the specified external DB system.
|
ListExternalAsmUsersResponse |
listExternalAsmUsers(ListExternalAsmUsersRequest request)
Lists ASM users for the external ASM specified by
externalAsmId . |
ListExternalClusterInstancesResponse |
listExternalClusterInstances(ListExternalClusterInstancesRequest request)
Lists the cluster instances in the specified external cluster.
|
ListExternalClustersResponse |
listExternalClusters(ListExternalClustersRequest request)
Lists the clusters in the specified external DB system.
|
ListExternalDatabasesResponse |
listExternalDatabases(ListExternalDatabasesRequest request)
Lists the external databases in the specified compartment or in the specified DB system.
|
ListExternalDbHomesResponse |
listExternalDbHomes(ListExternalDbHomesRequest request)
Lists the DB homes in the specified external DB system.
|
ListExternalDbNodesResponse |
listExternalDbNodes(ListExternalDbNodesRequest request)
Lists the external DB nodes in the specified external DB system.
|
ListExternalDbSystemConnectorsResponse |
listExternalDbSystemConnectors(ListExternalDbSystemConnectorsRequest request)
Lists the external connectors in the specified external DB system.
|
ListExternalDbSystemDiscoveriesResponse |
listExternalDbSystemDiscoveries(ListExternalDbSystemDiscoveriesRequest request)
Lists the external DB system discovery resources in the specified compartment.
|
ListExternalDbSystemsResponse |
listExternalDbSystems(ListExternalDbSystemsRequest request)
Lists the external DB systems in the specified compartment.
|
ListExternalExadataInfrastructuresResponse |
listExternalExadataInfrastructures(ListExternalExadataInfrastructuresRequest request)
Lists the Exadata infrastructure resources in the specified compartment.
|
ListExternalExadataStorageConnectorsResponse |
listExternalExadataStorageConnectors(ListExternalExadataStorageConnectorsRequest request)
Lists the Exadata storage server connectors for the specified Exadata infrastructure.
|
ListExternalExadataStorageServersResponse |
listExternalExadataStorageServers(ListExternalExadataStorageServersRequest request)
Lists the Exadata storage servers for the specified Exadata infrastructure.
|
ListExternalListenersResponse |
listExternalListeners(ListExternalListenersRequest request)
Lists the listeners in the specified external DB system.
|
ListExternalListenerServicesResponse |
listExternalListenerServices(ListExternalListenerServicesRequest request)
Lists the database services registered with the specified external listener for the specified
Managed Database.
|
ListJobExecutionsResponse |
listJobExecutions(ListJobExecutionsRequest request)
Gets the job execution for a specific ID or the list of job executions for a job, job run,
Managed Database or Managed Database Group in a specific compartment.
|
ListJobRunsResponse |
listJobRuns(ListJobRunsRequest request)
Gets the job run for a specific ID or the list of job runs for a job, Managed Database or
Managed Database Group in a specific compartment.
|
ListJobsResponse |
listJobs(ListJobsRequest request)
Gets the job for a specific ID or the list of jobs for a Managed Database or Managed Database
Group in a specific compartment.
|
ListManagedDatabaseGroupsResponse |
listManagedDatabaseGroups(ListManagedDatabaseGroupsRequest request)
Gets the Managed Database Group for a specific ID or the list of Managed Database Groups in a
specific compartment.
|
ListManagedDatabasesResponse |
listManagedDatabases(ListManagedDatabasesRequest request)
Gets the Managed Database for a specific ID or the list of Managed Databases in a specific
compartment.
|
ListObjectPrivilegesResponse |
listObjectPrivileges(ListObjectPrivilegesRequest request)
Gets the list of object privileges granted to a specific user.
|
ListOptimizerStatisticsAdvisorExecutionsResponse |
listOptimizerStatisticsAdvisorExecutions(ListOptimizerStatisticsAdvisorExecutionsRequest request)
Lists the details of the Optimizer Statistics Advisor task executions, such as their
duration, and the number of findings, if any.
|
ListOptimizerStatisticsCollectionAggregationsResponse |
listOptimizerStatisticsCollectionAggregations(ListOptimizerStatisticsCollectionAggregationsRequest request)
Gets a list of the optimizer statistics collection operations per hour, grouped by task or
object status for the specified Managed Database.
|
ListOptimizerStatisticsCollectionOperationsResponse |
listOptimizerStatisticsCollectionOperations(ListOptimizerStatisticsCollectionOperationsRequest request)
Lists the Optimizer Statistics Collection (Auto and Manual) task operation summary for the
specified Managed Database.
|
ListPreferredCredentialsResponse |
listPreferredCredentials(ListPreferredCredentialsRequest request)
Gets the list of preferred credentials for a given Managed Database.
|
ListProxiedForUsersResponse |
listProxiedForUsers(ListProxiedForUsersRequest request)
Gets the list of users on whose behalf the current user acts as proxy.
|
ListProxyUsersResponse |
listProxyUsers(ListProxyUsersRequest request)
Gets the list of proxy users for the current user.
|
ListRolesResponse |
listRoles(ListRolesRequest request)
Gets the list of roles granted to a specific user.
|
ListSqlPlanBaselineJobsResponse |
listSqlPlanBaselineJobs(ListSqlPlanBaselineJobsRequest request)
Lists the database jobs used for loading SQL plan baselines in the specified Managed
Database.
|
ListSqlPlanBaselinesResponse |
listSqlPlanBaselines(ListSqlPlanBaselinesRequest request)
Lists the SQL plan baselines for the specified Managed Database.
|
ListSystemPrivilegesResponse |
listSystemPrivileges(ListSystemPrivilegesRequest request)
Gets the list of system privileges granted to a specific user.
|
ListTablespacesResponse |
listTablespaces(ListTablespacesRequest request)
Gets the list of tablespaces for the specified managedDatabaseId.
|
ListTableStatisticsResponse |
listTableStatistics(ListTableStatisticsRequest request)
Lists the database table statistics grouped by different statuses such as Not Stale Stats,
Stale Stats, and No Stats.
|
ListUsersResponse |
listUsers(ListUsersRequest request)
Gets the list of users for the specified managedDatabaseId.
|
ListWorkRequestErrorsResponse |
listWorkRequestErrors(ListWorkRequestErrorsRequest request)
Returns a paginated list of errors for a given work request.
|
ListWorkRequestLogsResponse |
listWorkRequestLogs(ListWorkRequestLogsRequest request)
Returns a paginated list of logs for a given work request.
|
ListWorkRequestsResponse |
listWorkRequests(ListWorkRequestsRequest request)
The list of work requests in a specific compartment was retrieved successfully.
|
LoadSqlPlanBaselinesFromAwrResponse |
loadSqlPlanBaselinesFromAwr(LoadSqlPlanBaselinesFromAwrRequest request)
Loads plans from Automatic Workload Repository (AWR) snapshots.
|
LoadSqlPlanBaselinesFromCursorCacheResponse |
loadSqlPlanBaselinesFromCursorCache(LoadSqlPlanBaselinesFromCursorCacheRequest request)
Loads plans for statements directly from the shared SQL area, also called the cursor cache.
|
PatchExternalDbSystemDiscoveryResponse |
patchExternalDbSystemDiscovery(PatchExternalDbSystemDiscoveryRequest request)
Patches the external DB system discovery specified by
externalDbSystemDiscoveryId . |
void |
populateServiceParametersInEndpoint(String endpoint,
Map<String,Object> requiredParametersMap)
Populate the parameters in the endpoint with its corresponding value and update the base
endpoint.
|
void |
refreshClient()
Rebuild the backing
HttpClient . |
RemoveDataFileResponse |
removeDataFile(RemoveDataFileRequest request)
Removes a data file or temp file from the tablespace.
|
RemoveManagedDatabaseFromManagedDatabaseGroupResponse |
removeManagedDatabaseFromManagedDatabaseGroup(RemoveManagedDatabaseFromManagedDatabaseGroupRequest request)
Removes a Managed Database from a Managed Database Group.
|
ResetDatabaseParametersResponse |
resetDatabaseParameters(ResetDatabaseParametersRequest request)
Resets database parameter values to their default or startup values.
|
ResizeDataFileResponse |
resizeDataFile(ResizeDataFileRequest request)
Resizes a data file or temp file within the tablespace.
|
RunHistoricAddmResponse |
runHistoricAddm(RunHistoricAddmRequest request)
Creates and executes a historic ADDM task using the specified AWR snapshot IDs.
|
void |
setEndpoint(String endpoint) |
void |
setRegion(Region region)
Sets the region to call (ex, Region.US_PHOENIX_1).
|
void |
setRegion(String regionId)
Sets the region to call (ex, ‘us-phoenix-1’).
|
SummarizeAwrDbCpuUsagesResponse |
summarizeAwrDbCpuUsages(SummarizeAwrDbCpuUsagesRequest request)
Summarizes the AWR CPU resource limits and metrics for the specified database in AWR.
|
SummarizeAwrDbMetricsResponse |
summarizeAwrDbMetrics(SummarizeAwrDbMetricsRequest request)
Summarizes the metric samples for the specified database in the AWR.
|
SummarizeAwrDbParameterChangesResponse |
summarizeAwrDbParameterChanges(SummarizeAwrDbParameterChangesRequest request)
Summarizes the database parameter change history for one database parameter of the specified
database in AWR.
|
SummarizeAwrDbParametersResponse |
summarizeAwrDbParameters(SummarizeAwrDbParametersRequest request)
Summarizes the database parameter history for the specified database in AWR.
|
SummarizeAwrDbSnapshotRangesResponse |
summarizeAwrDbSnapshotRanges(SummarizeAwrDbSnapshotRangesRequest request)
Summarizes the AWR snapshot ranges that contain continuous snapshots, for the specified
Managed Database.
|
SummarizeAwrDbSysstatsResponse |
summarizeAwrDbSysstats(SummarizeAwrDbSysstatsRequest request)
Summarizes the AWR SYSSTAT sample data for the specified database in AWR.
|
SummarizeAwrDbTopWaitEventsResponse |
summarizeAwrDbTopWaitEvents(SummarizeAwrDbTopWaitEventsRequest request)
Summarizes the AWR top wait events.
|
SummarizeAwrDbWaitEventBucketsResponse |
summarizeAwrDbWaitEventBuckets(SummarizeAwrDbWaitEventBucketsRequest request)
Summarizes AWR wait event data into value buckets and frequency, for the specified database
in the AWR.
|
SummarizeAwrDbWaitEventsResponse |
summarizeAwrDbWaitEvents(SummarizeAwrDbWaitEventsRequest request)
Summarizes the AWR wait event sample data for the specified database in the AWR.
|
SummarizeExternalAsmMetricsResponse |
summarizeExternalAsmMetrics(SummarizeExternalAsmMetricsRequest request)
Gets metrics for the external ASM specified by
externalAsmId . |
SummarizeExternalClusterMetricsResponse |
summarizeExternalClusterMetrics(SummarizeExternalClusterMetricsRequest request)
Gets metrics for the external cluster specified by
externalClusterId . |
SummarizeExternalDbNodeMetricsResponse |
summarizeExternalDbNodeMetrics(SummarizeExternalDbNodeMetricsRequest request)
Gets metrics for the external DB node specified by
externalDbNodeId . |
SummarizeExternalDbSystemAvailabilityMetricsResponse |
summarizeExternalDbSystemAvailabilityMetrics(SummarizeExternalDbSystemAvailabilityMetricsRequest request)
Gets availability metrics for the components present in the external DB system specified by
externalDbSystemId . |
SummarizeExternalListenerMetricsResponse |
summarizeExternalListenerMetrics(SummarizeExternalListenerMetricsRequest request)
Gets metrics for the external listener specified by
externalListenerId . |
SummarizeJobExecutionsStatusesResponse |
summarizeJobExecutionsStatuses(SummarizeJobExecutionsStatusesRequest request)
Gets the number of job executions grouped by status for a job, Managed Database, or Database
Group in a specific compartment.
|
SummarizeManagedDatabaseAvailabilityMetricsResponse |
summarizeManagedDatabaseAvailabilityMetrics(SummarizeManagedDatabaseAvailabilityMetricsRequest request)
Gets the availability metrics related to managed database for the Oracle database specified
by managedDatabaseId.
|
SummarizeSqlPlanBaselinesResponse |
summarizeSqlPlanBaselines(SummarizeSqlPlanBaselinesRequest request)
Gets the number of SQL plan baselines aggregated by their attributes.
|
SummarizeSqlPlanBaselinesByLastExecutionResponse |
summarizeSqlPlanBaselinesByLastExecution(SummarizeSqlPlanBaselinesByLastExecutionRequest request)
Gets the number of SQL plan baselines aggregated by the age of their last execution in weeks.
|
TestPreferredCredentialResponse |
testPreferredCredential(TestPreferredCredentialRequest request)
Tests the preferred credential.
|
void |
updateBaseEndpoint(String endpoint)
This method should be used for parameterized endpoint templates only.
|
UpdateDbManagementPrivateEndpointResponse |
updateDbManagementPrivateEndpoint(UpdateDbManagementPrivateEndpointRequest request)
Updates one or more attributes of a specific Database Management private endpoint.
|
UpdateExternalAsmResponse |
updateExternalAsm(UpdateExternalAsmRequest request)
Updates the external ASM specified by
externalAsmId . |
UpdateExternalClusterResponse |
updateExternalCluster(UpdateExternalClusterRequest request)
Updates the external cluster specified by
externalClusterId . |
UpdateExternalClusterInstanceResponse |
updateExternalClusterInstance(UpdateExternalClusterInstanceRequest request)
Updates the external cluster instance specified by
externalClusterInstanceId . |
UpdateExternalDbNodeResponse |
updateExternalDbNode(UpdateExternalDbNodeRequest request)
Updates the external DB node specified by
externalDbNodeId . |
UpdateExternalDbSystemResponse |
updateExternalDbSystem(UpdateExternalDbSystemRequest request)
Updates the external DB system specified by
externalDbSystemId . |
UpdateExternalDbSystemConnectorResponse |
updateExternalDbSystemConnector(UpdateExternalDbSystemConnectorRequest request)
Updates the external connector specified by
externalDbSystemConnectorId . |
UpdateExternalDbSystemDiscoveryResponse |
updateExternalDbSystemDiscovery(UpdateExternalDbSystemDiscoveryRequest request)
Updates the external DB system discovery specified by
externalDbSystemDiscoveryId . |
UpdateExternalExadataInfrastructureResponse |
updateExternalExadataInfrastructure(UpdateExternalExadataInfrastructureRequest request)
Updates the details for the Exadata infrastructure specified by
externalExadataInfrastructureId.
|
UpdateExternalExadataStorageConnectorResponse |
updateExternalExadataStorageConnector(UpdateExternalExadataStorageConnectorRequest request)
Updates the Exadata storage server connector specified by exadataStorageConnectorId.
|
UpdateExternalListenerResponse |
updateExternalListener(UpdateExternalListenerRequest request)
Updates the external listener specified by
externalListenerId . |
UpdateJobResponse |
updateJob(UpdateJobRequest request)
Updates the details for the recurring scheduled job specified by jobId.
|
UpdateManagedDatabaseGroupResponse |
updateManagedDatabaseGroup(UpdateManagedDatabaseGroupRequest request)
Updates the Managed Database Group specified by managedDatabaseGroupId.
|
UpdatePreferredCredentialResponse |
updatePreferredCredential(UpdatePreferredCredentialRequest request)
Updates the preferred credential based on the credentialName.
|
UpdateTablespaceResponse |
updateTablespace(UpdateTablespaceRequest request)
Updates the attributes of the tablespace specified by tablespaceName within the Managed
Database specified by managedDatabaseId.
|
void |
useRealmSpecificEndpointTemplate(boolean useOfRealmSpecificEndpointTemplateEnabled)
This method should be used to enable or disable the use of realm-specific endpoint template.
|
clientCall
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getEndpoint, refreshClient, setEndpoint, useRealmSpecificEndpointTemplate
close
public static final Service SERVICE
Service instance for DbManagement.
@Deprecated public DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider)
builder
instead.Create a new client instance.
authenticationDetailsProvider
- The authentication details (see DbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)@Deprecated public DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration)
builder
instead.Create a new client instance.
authenticationDetailsProvider
- The authentication details (see DbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
- ClientBuilderBase.configuration
@Deprecated public DbManagementClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator)
builder
instead.Create a new client instance.
authenticationDetailsProvider
- The authentication details (see DbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
- ClientBuilderBase.configuration
clientConfigurator
- ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
@Deprecated public DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory)
builder
instead.Create a new client instance.
authenticationDetailsProvider
- The authentication details (see DbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
- ClientBuilderBase.configuration
clientConfigurator
- ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
defaultRequestSignerFactory
- ClientBuilderBase.requestSignerFactory
@Deprecated public DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, List<ClientConfigurator> additionalClientConfigurators)
builder
instead.Create a new client instance.
authenticationDetailsProvider
- The authentication details (see DbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
- ClientBuilderBase.configuration
clientConfigurator
- ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
defaultRequestSignerFactory
- ClientBuilderBase.requestSignerFactory
additionalClientConfigurators
- ClientBuilderBase.additionalClientConfigurators
@Deprecated public DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, List<ClientConfigurator> additionalClientConfigurators, String endpoint)
builder
instead.Create a new client instance.
authenticationDetailsProvider
- The authentication details (see DbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
- ClientBuilderBase.configuration
clientConfigurator
- ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
defaultRequestSignerFactory
- ClientBuilderBase.requestSignerFactory
additionalClientConfigurators
- ClientBuilderBase.additionalClientConfigurators
endpoint
- ClientBuilderBase.endpoint(java.lang.String)
@Deprecated public DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, Map<SigningStrategy,RequestSignerFactory> signingStrategyRequestSignerFactories, List<ClientConfigurator> additionalClientConfigurators, String endpoint)
builder
instead.Create a new client instance.
authenticationDetailsProvider
- The authentication details (see DbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
- ClientBuilderBase.configuration
clientConfigurator
- ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
defaultRequestSignerFactory
- ClientBuilderBase.requestSignerFactory
additionalClientConfigurators
- ClientBuilderBase.additionalClientConfigurators
endpoint
- ClientBuilderBase.endpoint(java.lang.String)
signingStrategyRequestSignerFactories
- ClientBuilderBase.signingStrategyRequestSignerFactories
@Deprecated public DbManagementClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, Map<SigningStrategy,RequestSignerFactory> signingStrategyRequestSignerFactories, List<ClientConfigurator> additionalClientConfigurators, String endpoint, ExecutorService executorService)
builder
instead.Create a new client instance.
authenticationDetailsProvider
- The authentication details (see DbManagementClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider)
)configuration
- ClientBuilderBase.configuration
clientConfigurator
- ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
defaultRequestSignerFactory
- ClientBuilderBase.requestSignerFactory
additionalClientConfigurators
- ClientBuilderBase.additionalClientConfigurators
endpoint
- ClientBuilderBase.endpoint(java.lang.String)
signingStrategyRequestSignerFactories
- ClientBuilderBase.signingStrategyRequestSignerFactories
executorService
- DbManagementClient.Builder.executorService
public static DbManagementClient.Builder builder()
Create a builder for this client.
public void setRegion(Region region)
DbManagement
Sets the region to call (ex, Region.US_PHOENIX_1).
Note, this will call setEndpoint
after resolving the
endpoint. If the service is not available in this Region, however, an
IllegalArgumentException will be raised.
setRegion
in interface DbManagement
region
- The region of the service.public void setRegion(String regionId)
DbManagement
Sets the region to call (ex, ‘us-phoenix-1’).
Note, this will first try to map the region ID to a known Region and call setRegion
.
If no known Region could be determined, it will create an endpoint based on the default
endpoint format (Region.formatDefaultRegionEndpoint(Service, String)
and then call setEndpoint
.
setRegion
in interface DbManagement
regionId
- The public region ID.public AddDataFilesResponse addDataFiles(AddDataFilesRequest request)
DbManagement
Adds data files or temp files to the tablespace.
addDataFiles
in interface DbManagement
request
- The request object containing the details to sendpublic AddManagedDatabaseToManagedDatabaseGroupResponse addManagedDatabaseToManagedDatabaseGroup(AddManagedDatabaseToManagedDatabaseGroupRequest request)
DbManagement
Adds a Managed Database to a specific Managed Database Group. After the database is added, it will be included in the management activities performed on the Managed Database Group.
addManagedDatabaseToManagedDatabaseGroup
in interface DbManagement
request
- The request object containing the details to sendpublic AddmTasksResponse addmTasks(AddmTasksRequest request)
DbManagement
Lists the metadata for each ADDM task who’s end snapshot time falls within the provided start and end time. Details include the name of the ADDM task, description, user, status and creation date time.
addmTasks
in interface DbManagement
request
- The request object containing the details to sendpublic ChangeDatabaseParametersResponse changeDatabaseParameters(ChangeDatabaseParametersRequest request)
DbManagement
Changes database parameter values. There are two kinds of database parameters:
- Dynamic parameters: They can be changed for the current Oracle Database instance. The changes take effect immediately. - Static parameters: They cannot be changed for the current instance. You must change these parameters and then restart the database before changes take effect.
*Note:** If the instance is started using a text initialization parameter file, the parameter changes are applicable only for the current instance. You must update them manually to be passed to a future instance.
changeDatabaseParameters
in interface DbManagement
request
- The request object containing the details to sendpublic ChangeDbManagementPrivateEndpointCompartmentResponse changeDbManagementPrivateEndpointCompartment(ChangeDbManagementPrivateEndpointCompartmentRequest request)
DbManagement
Moves the Database Management private endpoint and its dependent resources to the specified compartment.
changeDbManagementPrivateEndpointCompartment
in interface DbManagement
request
- The request object containing the details to sendpublic ChangeExternalDbSystemCompartmentResponse changeExternalDbSystemCompartment(ChangeExternalDbSystemCompartmentRequest request)
DbManagement
Moves the external DB system and its related resources (excluding databases) to the specified compartment.
changeExternalDbSystemCompartment
in interface DbManagement
request
- The request object containing the details to sendpublic ChangeExternalExadataInfrastructureCompartmentResponse changeExternalExadataInfrastructureCompartment(ChangeExternalExadataInfrastructureCompartmentRequest request)
DbManagement
Moves the Exadata infrastructure and its related resources (Exadata storage server, Exadata storage server connectors and Exadata storage server grid) to the specified compartment.
changeExternalExadataInfrastructureCompartment
in interface DbManagement
request
- The request object containing the details to sendpublic ChangeJobCompartmentResponse changeJobCompartment(ChangeJobCompartmentRequest request)
DbManagement
Moves a job.
changeJobCompartment
in interface DbManagement
request
- The request object containing the details to sendpublic ChangeManagedDatabaseGroupCompartmentResponse changeManagedDatabaseGroupCompartment(ChangeManagedDatabaseGroupCompartmentRequest request)
DbManagement
Moves a Managed Database Group to a different compartment. The destination compartment must not have a Managed Database Group with the same name.
changeManagedDatabaseGroupCompartment
in interface DbManagement
request
- The request object containing the details to sendpublic ChangePlanRetentionResponse changePlanRetention(ChangePlanRetentionRequest request)
DbManagement
Changes the retention period of unused plans. The period can range between 5 and 523 weeks.
The database purges plans that have not been used for longer than the plan retention period.
changePlanRetention
in interface DbManagement
request
- The request object containing the details to sendpublic ChangeSpaceBudgetResponse changeSpaceBudget(ChangeSpaceBudgetRequest request)
DbManagement
Changes the disk space limit for the SQL Management Base. The allowable range for this limit is between 1% and 50%.
changeSpaceBudget
in interface DbManagement
request
- The request object containing the details to sendpublic ChangeSqlPlanBaselinesAttributesResponse changeSqlPlanBaselinesAttributes(ChangeSqlPlanBaselinesAttributesRequest request)
DbManagement
Changes one or more attributes of a single plan or all plans associated with a SQL statement.
changeSqlPlanBaselinesAttributes
in interface DbManagement
request
- The request object containing the details to sendpublic CheckExternalDbSystemConnectorConnectionStatusResponse checkExternalDbSystemConnectorConnectionStatus(CheckExternalDbSystemConnectorConnectionStatusRequest request)
DbManagement
Checks the status of the external DB system component connection specified in this connector. This operation will refresh the connectionStatus and timeConnectionStatusLastUpdated fields.
checkExternalDbSystemConnectorConnectionStatus
in interface DbManagement
request
- The request object containing the details to sendpublic CheckExternalExadataStorageConnectorResponse checkExternalExadataStorageConnector(CheckExternalExadataStorageConnectorRequest request)
DbManagement
Checks the status of the Exadata storage server connection specified by exadataStorageConnectorId.
checkExternalExadataStorageConnector
in interface DbManagement
request
- The request object containing the details to sendpublic ConfigureAutomaticCaptureFiltersResponse configureAutomaticCaptureFilters(ConfigureAutomaticCaptureFiltersRequest request)
DbManagement
Configures automatic capture filters to capture only those statements that match the filter criteria.
configureAutomaticCaptureFilters
in interface DbManagement
request
- The request object containing the details to sendpublic ConfigureAutomaticSpmEvolveAdvisorTaskResponse configureAutomaticSpmEvolveAdvisorTask(ConfigureAutomaticSpmEvolveAdvisorTaskRequest request)
DbManagement
Configures the Automatic SPM Evolve Advisor task SYS_AUTO_SPM_EVOLVE_TASK
by specifying
task parameters. As the task is owned by SYS
, only SYS
can set task parameters.
configureAutomaticSpmEvolveAdvisorTask
in interface DbManagement
request
- The request object containing the details to sendpublic CreateDbManagementPrivateEndpointResponse createDbManagementPrivateEndpoint(CreateDbManagementPrivateEndpointRequest request)
DbManagement
Creates a new Database Management private endpoint.
createDbManagementPrivateEndpoint
in interface DbManagement
request
- The request object containing the details to sendpublic CreateExternalDbSystemResponse createExternalDbSystem(CreateExternalDbSystemRequest request)
DbManagement
Creates an external DB system and its related resources.
createExternalDbSystem
in interface DbManagement
request
- The request object containing the details to sendpublic CreateExternalDbSystemConnectorResponse createExternalDbSystemConnector(CreateExternalDbSystemConnectorRequest request)
DbManagement
Creates a new external connector.
createExternalDbSystemConnector
in interface DbManagement
request
- The request object containing the details to sendpublic CreateExternalDbSystemDiscoveryResponse createExternalDbSystemDiscovery(CreateExternalDbSystemDiscoveryRequest request)
DbManagement
Creates an external DB system discovery resource and initiates the discovery process.
createExternalDbSystemDiscovery
in interface DbManagement
request
- The request object containing the details to sendpublic CreateExternalExadataInfrastructureResponse createExternalExadataInfrastructure(CreateExternalExadataInfrastructureRequest request)
DbManagement
Creates an OCI resource for the Exadata infrastructure and enables the Monitoring service for the Exadata infrastructure. The following resource/subresources are created: Infrastructure Storage server connectors Storage servers Storage grids
createExternalExadataInfrastructure
in interface DbManagement
request
- The request object containing the details to sendpublic CreateExternalExadataStorageConnectorResponse createExternalExadataStorageConnector(CreateExternalExadataStorageConnectorRequest request)
DbManagement
Creates the Exadata storage server connector after validating the connection information.
createExternalExadataStorageConnector
in interface DbManagement
request
- The request object containing the details to sendpublic CreateJobResponse createJob(CreateJobRequest request)
DbManagement
Creates a job to be executed on a Managed Database or Managed Database Group. Only one of the parameters, managedDatabaseId or managedDatabaseGroupId should be provided as input in CreateJobDetails resource in request body.
createJob
in interface DbManagement
request
- The request object containing the details to sendpublic CreateManagedDatabaseGroupResponse createManagedDatabaseGroup(CreateManagedDatabaseGroupRequest request)
DbManagement
Creates a Managed Database Group. The group does not contain any Managed Databases when it is created, and they must be added later.
createManagedDatabaseGroup
in interface DbManagement
request
- The request object containing the details to sendpublic CreateTablespaceResponse createTablespace(CreateTablespaceRequest request)
DbManagement
Creates a tablespace within the Managed Database specified by managedDatabaseId.
createTablespace
in interface DbManagement
request
- The request object containing the details to sendpublic DeleteDbManagementPrivateEndpointResponse deleteDbManagementPrivateEndpoint(DeleteDbManagementPrivateEndpointRequest request)
DbManagement
Deletes a specific Database Management private endpoint.
deleteDbManagementPrivateEndpoint
in interface DbManagement
request
- The request object containing the details to sendpublic DeleteExternalDbSystemResponse deleteExternalDbSystem(DeleteExternalDbSystemRequest request)
DbManagement
Deletes the external DB system specified by externalDbSystemId
.
deleteExternalDbSystem
in interface DbManagement
request
- The request object containing the details to sendpublic DeleteExternalDbSystemConnectorResponse deleteExternalDbSystemConnector(DeleteExternalDbSystemConnectorRequest request)
DbManagement
Deletes the external connector specified by externalDbSystemConnectorId
.
deleteExternalDbSystemConnector
in interface DbManagement
request
- The request object containing the details to sendpublic DeleteExternalDbSystemDiscoveryResponse deleteExternalDbSystemDiscovery(DeleteExternalDbSystemDiscoveryRequest request)
DbManagement
Deletes the external DB system discovery resource specified by externalDbSystemDiscoveryId
.
deleteExternalDbSystemDiscovery
in interface DbManagement
request
- The request object containing the details to sendpublic DeleteExternalExadataInfrastructureResponse deleteExternalExadataInfrastructure(DeleteExternalExadataInfrastructureRequest request)
DbManagement
Deletes the Exadata infrastructure specified by externalExadataInfrastructureId.
deleteExternalExadataInfrastructure
in interface DbManagement
request
- The request object containing the details to sendpublic DeleteExternalExadataStorageConnectorResponse deleteExternalExadataStorageConnector(DeleteExternalExadataStorageConnectorRequest request)
DbManagement
Deletes the Exadata storage server connector specified by exadataStorageConnectorId.
deleteExternalExadataStorageConnector
in interface DbManagement
request
- The request object containing the details to sendpublic DeleteJobResponse deleteJob(DeleteJobRequest request)
DbManagement
Deletes the job specified by jobId.
deleteJob
in interface DbManagement
request
- The request object containing the details to sendpublic DeleteManagedDatabaseGroupResponse deleteManagedDatabaseGroup(DeleteManagedDatabaseGroupRequest request)
DbManagement
Deletes the Managed Database Group specified by managedDatabaseGroupId. If the group contains Managed Databases, then it cannot be deleted.
deleteManagedDatabaseGroup
in interface DbManagement
request
- The request object containing the details to sendpublic DeletePreferredCredentialResponse deletePreferredCredential(DeletePreferredCredentialRequest request)
DbManagement
Deletes the preferred credential based on the credentialName.
deletePreferredCredential
in interface DbManagement
request
- The request object containing the details to sendpublic DisableAutomaticInitialPlanCaptureResponse disableAutomaticInitialPlanCapture(DisableAutomaticInitialPlanCaptureRequest request)
DbManagement
Disables automatic initial plan capture.
disableAutomaticInitialPlanCapture
in interface DbManagement
request
- The request object containing the details to sendpublic DisableAutomaticSpmEvolveAdvisorTaskResponse disableAutomaticSpmEvolveAdvisorTask(DisableAutomaticSpmEvolveAdvisorTaskRequest request)
DbManagement
Disables the Automatic SPM Evolve Advisor task.
One client controls both Automatic SQL Tuning Advisor and Automatic SPM Evolve Advisor. Thus, the same task enables or disables both.
disableAutomaticSpmEvolveAdvisorTask
in interface DbManagement
request
- The request object containing the details to sendpublic DisableExternalDbSystemDatabaseManagementResponse disableExternalDbSystemDatabaseManagement(DisableExternalDbSystemDatabaseManagementRequest request)
DbManagement
Disables Database Management service for all the components of the specified external DB system (except databases).
disableExternalDbSystemDatabaseManagement
in interface DbManagement
request
- The request object containing the details to sendpublic DisableExternalDbSystemStackMonitoringResponse disableExternalDbSystemStackMonitoring(DisableExternalDbSystemStackMonitoringRequest request)
DbManagement
Disables Stack Monitoring for all the components of the specified external DB system (except databases).
disableExternalDbSystemStackMonitoring
in interface DbManagement
request
- The request object containing the details to sendpublic DisableExternalExadataInfrastructureManagementResponse disableExternalExadataInfrastructureManagement(DisableExternalExadataInfrastructureManagementRequest request)
DbManagement
Disables Database Management for the Exadata infrastructure specified by externalExadataInfrastructureId. It covers the following components:
- Exadata infrastructure - Exadata storage grid - Exadata storage server
Note that Database Management will not be disabled for the DB systems within the Exadata infrastructure and should be disabled explicitly, if required.
disableExternalExadataInfrastructureManagement
in interface DbManagement
request
- The request object containing the details to sendpublic DisableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse disableHighFrequencyAutomaticSpmEvolveAdvisorTask(DisableHighFrequencyAutomaticSpmEvolveAdvisorTaskRequest request)
DbManagement
Disables the high-frequency Automatic SPM Evolve Advisor task.
It is available only on Oracle Exadata Database Machine, Oracle Database Exadata Cloud Service (ExaCS) and Oracle Database Exadata Cloud@Customer (ExaCC).
disableHighFrequencyAutomaticSpmEvolveAdvisorTask
in interface DbManagement
request
- The request object containing the details to sendpublic DisableSqlPlanBaselinesUsageResponse disableSqlPlanBaselinesUsage(DisableSqlPlanBaselinesUsageRequest request)
DbManagement
Disables the use of SQL plan baselines stored in SQL Management Base.
When disabled, the optimizer does not use any SQL plan baselines.
disableSqlPlanBaselinesUsage
in interface DbManagement
request
- The request object containing the details to sendpublic DiscoverExternalExadataInfrastructureResponse discoverExternalExadataInfrastructure(DiscoverExternalExadataInfrastructureRequest request)
DbManagement
Completes the Exadata system prechecking on the following:
- Verifies if the DB systems are valid RAC DB systems or return 400 status code with NON_RAC_DATABASE_SYSTEM error code. - Verifies if the ASM connector defined for each DB system or return 400 status code with CONNECTOR_NOT_DEFINED error code. - Verifies if the agents associated with ASM are valid and could be used for the Exadata storage servers or return 400 status code with INVALID_AGENT error code. - Verifies if it is an Exadata system or return 400 status code with INVALID_EXADATA_SYSTEM error code.
Starts the discovery process for the Exadata system infrastructure. The following resources/components are discovered
- Exadata storage servers from each DB systems - Exadata storage grid for all Exadata storage servers - Exadata infrastructure
The same API covers both new discovery and rediscovery cases. For the new discovery case, new managed resources/sub-resources are created or the existing ones are overridden. For rediscovery case, the existing managed resources/sub-resources are checked to find out which ones should be added or which ones should be removed based on the unique key defined for each resource/sub-resource.
discoverExternalExadataInfrastructure
in interface DbManagement
request
- The request object containing the details to sendpublic DropSqlPlanBaselinesResponse dropSqlPlanBaselines(DropSqlPlanBaselinesRequest request)
DbManagement
Drops a single plan or all plans associated with a SQL statement.
dropSqlPlanBaselines
in interface DbManagement
request
- The request object containing the details to sendpublic DropTablespaceResponse dropTablespace(DropTablespaceRequest request)
DbManagement
Drops the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.
dropTablespace
in interface DbManagement
request
- The request object containing the details to sendpublic EnableAutomaticInitialPlanCaptureResponse enableAutomaticInitialPlanCapture(EnableAutomaticInitialPlanCaptureRequest request)
DbManagement
Enables automatic initial plan capture. When enabled, the database checks whether executed SQL statements are eligible for automatic capture. It creates initial plan baselines for eligible statements.
By default, the database creates a SQL plan baseline for every eligible repeatable statement, including all recursive SQL and monitoring SQL. Thus, automatic capture may result in the creation of an extremely large number of plan baselines. To limit the statements that are eligible for plan baselines, configure filters.
enableAutomaticInitialPlanCapture
in interface DbManagement
request
- The request object containing the details to sendpublic EnableAutomaticSpmEvolveAdvisorTaskResponse enableAutomaticSpmEvolveAdvisorTask(EnableAutomaticSpmEvolveAdvisorTaskRequest request)
DbManagement
Enables the Automatic SPM Evolve Advisor task. By default, the automatic task
SYS_AUTO_SPM_EVOLVE_TASK
runs every day in the scheduled maintenance window.
The SPM Evolve Advisor performs the following tasks:
- Checks AWR for top SQL - Looks for alternative plans in all available sources - Adds unaccepted plans to the plan history - Tests the execution of as many plans as possible during the maintenance window - Adds the alternative plan to the baseline if it performs better than the current plan
One client controls both Automatic SQL Tuning Advisor and Automatic SPM Evolve Advisor. Thus, the same task enables or disables both.
enableAutomaticSpmEvolveAdvisorTask
in interface DbManagement
request
- The request object containing the details to sendpublic EnableExternalDbSystemDatabaseManagementResponse enableExternalDbSystemDatabaseManagement(EnableExternalDbSystemDatabaseManagementRequest request)
DbManagement
Enables Database Management service for all the components of the specified external DB system (except databases).
enableExternalDbSystemDatabaseManagement
in interface DbManagement
request
- The request object containing the details to sendpublic EnableExternalDbSystemStackMonitoringResponse enableExternalDbSystemStackMonitoring(EnableExternalDbSystemStackMonitoringRequest request)
DbManagement
Enables Stack Monitoring for all the components of the specified external DB system (except databases).
enableExternalDbSystemStackMonitoring
in interface DbManagement
request
- The request object containing the details to sendpublic EnableExternalExadataInfrastructureManagementResponse enableExternalExadataInfrastructureManagement(EnableExternalExadataInfrastructureManagementRequest request)
DbManagement
Enables Database Management for the Exadata infrastructure specified by externalExadataInfrastructureId. It covers the following components:
- Exadata infrastructure - Exadata storage grid - Exadata storage server
enableExternalExadataInfrastructureManagement
in interface DbManagement
request
- The request object containing the details to sendpublic EnableHighFrequencyAutomaticSpmEvolveAdvisorTaskResponse enableHighFrequencyAutomaticSpmEvolveAdvisorTask(EnableHighFrequencyAutomaticSpmEvolveAdvisorTaskRequest request)
DbManagement
Enables the high-frequency Automatic SPM Evolve Advisor task. The high-frequency task runs every hour and runs for no longer than 30 minutes. These settings are not configurable.
The high-frequency task complements the standard Automatic SPM Evolve Advisor task. They are independent and are scheduled through two different frameworks.
It is available only on Oracle Exadata Database Machine, Oracle Database Exadata Cloud Service (ExaCS) and Oracle Database Exadata Cloud@Customer (ExaCC).
enableHighFrequencyAutomaticSpmEvolveAdvisorTask
in interface DbManagement
request
- The request object containing the details to sendpublic EnableSqlPlanBaselinesUsageResponse enableSqlPlanBaselinesUsage(EnableSqlPlanBaselinesUsageRequest request)
DbManagement
Enables the use of SQL plan baselines stored in SQL Management Base.
When enabled, the optimizer uses SQL plan baselines to select plans to avoid potential performance regressions.
enableSqlPlanBaselinesUsage
in interface DbManagement
request
- The request object containing the details to sendpublic GenerateAwrSnapshotResponse generateAwrSnapshot(GenerateAwrSnapshotRequest request)
DbManagement
Creates an AWR snapshot for the target database.
generateAwrSnapshot
in interface DbManagement
request
- The request object containing the details to sendpublic GetAwrDbReportResponse getAwrDbReport(GetAwrDbReportRequest request)
DbManagement
Gets the AWR report for the specific database.
getAwrDbReport
in interface DbManagement
request
- The request object containing the details to sendpublic GetAwrDbSqlReportResponse getAwrDbSqlReport(GetAwrDbSqlReportRequest request)
DbManagement
Gets the SQL health check report for one SQL of the specific database.
getAwrDbSqlReport
in interface DbManagement
request
- The request object containing the details to sendpublic GetClusterCacheMetricResponse getClusterCacheMetric(GetClusterCacheMetricRequest request)
DbManagement
Gets the metrics related to cluster cache for the Oracle Real Application Clusters (Oracle RAC) database specified by managedDatabaseId.
getClusterCacheMetric
in interface DbManagement
request
- The request object containing the details to sendpublic GetDatabaseFleetHealthMetricsResponse getDatabaseFleetHealthMetrics(GetDatabaseFleetHealthMetricsRequest request)
DbManagement
Gets the health metrics for a fleet of databases in a compartment or in a Managed Database Group. Either the CompartmentId or the ManagedDatabaseGroupId query parameters must be provided to retrieve the health metrics.
getDatabaseFleetHealthMetrics
in interface DbManagement
request
- The request object containing the details to sendpublic GetDatabaseHomeMetricsResponse getDatabaseHomeMetrics(GetDatabaseHomeMetricsRequest request)
DbManagement
Gets a summary of the activity and resource usage metrics like DB Time, CPU, User I/O, Wait, Storage, and Memory for a Managed Database.
getDatabaseHomeMetrics
in interface DbManagement
request
- The request object containing the details to sendpublic GetDbManagementPrivateEndpointResponse getDbManagementPrivateEndpoint(GetDbManagementPrivateEndpointRequest request)
DbManagement
Gets the details of a specific Database Management private endpoint.
getDbManagementPrivateEndpoint
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalAsmResponse getExternalAsm(GetExternalAsmRequest request)
DbManagement
Gets the details for the external ASM specified by externalAsmId
.
getExternalAsm
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalAsmConfigurationResponse getExternalAsmConfiguration(GetExternalAsmConfigurationRequest request)
DbManagement
Gets configuration details including disk groups for the external ASM specified by
externalAsmId
.
getExternalAsmConfiguration
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalAsmInstanceResponse getExternalAsmInstance(GetExternalAsmInstanceRequest request)
DbManagement
Gets the details for the external ASM instance specified by externalAsmInstanceId
.
getExternalAsmInstance
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalClusterResponse getExternalCluster(GetExternalClusterRequest request)
DbManagement
Gets the details for the external cluster specified by externalClusterId
.
getExternalCluster
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalClusterInstanceResponse getExternalClusterInstance(GetExternalClusterInstanceRequest request)
DbManagement
Gets the details for the external cluster instance specified by externalClusterInstanceId
.
getExternalClusterInstance
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalDbHomeResponse getExternalDbHome(GetExternalDbHomeRequest request)
DbManagement
Gets the details for the external DB home specified by externalDbHomeId
.
getExternalDbHome
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalDbNodeResponse getExternalDbNode(GetExternalDbNodeRequest request)
DbManagement
Gets the details for the external DB node specified by externalDbNodeId
.
getExternalDbNode
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalDbSystemResponse getExternalDbSystem(GetExternalDbSystemRequest request)
DbManagement
Gets the details for the external DB system specified by externalDbSystemId
.
getExternalDbSystem
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalDbSystemConnectorResponse getExternalDbSystemConnector(GetExternalDbSystemConnectorRequest request)
DbManagement
Gets the details for the external connector specified by externalDbSystemConnectorId
.
getExternalDbSystemConnector
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalDbSystemDiscoveryResponse getExternalDbSystemDiscovery(GetExternalDbSystemDiscoveryRequest request)
DbManagement
Gets the details for the external DB system discovery resource specified by
externalDbSystemDiscoveryId
.
getExternalDbSystemDiscovery
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalExadataInfrastructureResponse getExternalExadataInfrastructure(GetExternalExadataInfrastructureRequest request)
DbManagement
Gets the details for the Exadata infrastructure specified by externalExadataInfrastructureId. It includes the DB systems and storage grid within the Exadata infrastructure.
getExternalExadataInfrastructure
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalExadataStorageConnectorResponse getExternalExadataStorageConnector(GetExternalExadataStorageConnectorRequest request)
DbManagement
Gets the details for the Exadata storage server connector specified by exadataStorageConnectorId.
getExternalExadataStorageConnector
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalExadataStorageGridResponse getExternalExadataStorageGrid(GetExternalExadataStorageGridRequest request)
DbManagement
Gets the details for the Exadata storage server grid specified by exadataStorageGridId.
getExternalExadataStorageGrid
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalExadataStorageServerResponse getExternalExadataStorageServer(GetExternalExadataStorageServerRequest request)
DbManagement
Gets the summary for the Exadata storage server specified by exadataStorageServerId.
getExternalExadataStorageServer
in interface DbManagement
request
- The request object containing the details to sendpublic GetExternalListenerResponse getExternalListener(GetExternalListenerRequest request)
DbManagement
Gets the details for the external listener specified by externalListenerId
.
getExternalListener
in interface DbManagement
request
- The request object containing the details to sendpublic GetIormPlanResponse getIormPlan(GetIormPlanRequest request)
DbManagement
Get the IORM plan from the specific Exadata storage server.
getIormPlan
in interface DbManagement
request
- The request object containing the details to sendpublic GetJobResponse getJob(GetJobRequest request)
DbManagement
Gets the details for the job specified by jobId.
getJob
in interface DbManagement
request
- The request object containing the details to sendpublic GetJobExecutionResponse getJobExecution(GetJobExecutionRequest request)
DbManagement
Gets the details for the job execution specified by jobExecutionId.
getJobExecution
in interface DbManagement
request
- The request object containing the details to sendpublic GetJobRunResponse getJobRun(GetJobRunRequest request)
DbManagement
Gets the details for the job run specified by jobRunId.
getJobRun
in interface DbManagement
request
- The request object containing the details to sendpublic GetManagedDatabaseResponse getManagedDatabase(GetManagedDatabaseRequest request)
DbManagement
Gets the details for the Managed Database specified by managedDatabaseId.
getManagedDatabase
in interface DbManagement
request
- The request object containing the details to sendpublic GetManagedDatabaseGroupResponse getManagedDatabaseGroup(GetManagedDatabaseGroupRequest request)
DbManagement
Gets the details for the Managed Database Group specified by managedDatabaseGroupId.
getManagedDatabaseGroup
in interface DbManagement
request
- The request object containing the details to sendpublic GetOpenAlertHistoryResponse getOpenAlertHistory(GetOpenAlertHistoryRequest request)
DbManagement
Gets the open alerts from the specified Exadata storage server.
getOpenAlertHistory
in interface DbManagement
request
- The request object containing the details to sendpublic GetOptimizerStatisticsAdvisorExecutionResponse getOptimizerStatisticsAdvisorExecution(GetOptimizerStatisticsAdvisorExecutionRequest request)
DbManagement
Gets a comprehensive report of the Optimizer Statistics Advisor execution, which includes details of the Managed Database, findings, recommendations, rationale, and examples.
getOptimizerStatisticsAdvisorExecution
in interface DbManagement
request
- The request object containing the details to sendpublic GetOptimizerStatisticsAdvisorExecutionScriptResponse getOptimizerStatisticsAdvisorExecutionScript(GetOptimizerStatisticsAdvisorExecutionScriptRequest request)
DbManagement
Gets the Oracle system-generated script for the specified Optimizer Statistics Advisor execution.
getOptimizerStatisticsAdvisorExecutionScript
in interface DbManagement
request
- The request object containing the details to sendpublic GetOptimizerStatisticsCollectionOperationResponse getOptimizerStatisticsCollectionOperation(GetOptimizerStatisticsCollectionOperationRequest request)
DbManagement
Gets a detailed report of the Optimizer Statistics Collection operation for the specified Managed Database.
getOptimizerStatisticsCollectionOperation
in interface DbManagement
request
- The request object containing the details to sendpublic GetPdbMetricsResponse getPdbMetrics(GetPdbMetricsRequest request)
DbManagement
Gets a summary of the resource usage metrics such as CPU, User I/O, and Storage for each PDB within a specific CDB. If comparmentId is specified, then the metrics for each PDB (within the CDB) in the specified compartment are retrieved. If compartmentId is not specified, then the metrics for all the PDBs within the CDB are retrieved.
getPdbMetrics
in interface DbManagement
request
- The request object containing the details to sendpublic GetPreferredCredentialResponse getPreferredCredential(GetPreferredCredentialRequest request)
DbManagement
Gets the preferred credential details for a Managed Database based on credentialName.
getPreferredCredential
in interface DbManagement
request
- The request object containing the details to sendpublic GetSqlPlanBaselineResponse getSqlPlanBaseline(GetSqlPlanBaselineRequest request)
DbManagement
Gets the SQL plan baseline details for the specified planName.
getSqlPlanBaseline
in interface DbManagement
request
- The request object containing the details to sendpublic GetSqlPlanBaselineConfigurationResponse getSqlPlanBaselineConfiguration(GetSqlPlanBaselineConfigurationRequest request)
DbManagement
Gets the configuration details of SQL plan baselines for the specified Managed Database. The details include the settings for the capture and use of SQL plan baselines, SPM Evolve Advisor task, and SQL Management Base.
getSqlPlanBaselineConfiguration
in interface DbManagement
request
- The request object containing the details to sendpublic GetTablespaceResponse getTablespace(GetTablespaceRequest request)
DbManagement
Gets the details of the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.
getTablespace
in interface DbManagement
request
- The request object containing the details to sendpublic GetTopSqlCpuActivityResponse getTopSqlCpuActivity(GetTopSqlCpuActivityRequest request)
DbManagement
Gets the SQL IDs with the top CPU activity from the Exadata storage server.
getTopSqlCpuActivity
in interface DbManagement
request
- The request object containing the details to sendpublic GetUserResponse getUser(GetUserRequest request)
DbManagement
Gets the details of the user specified by managedDatabaseId and userName.
getUser
in interface DbManagement
request
- The request object containing the details to sendpublic GetWorkRequestResponse getWorkRequest(GetWorkRequestRequest request)
DbManagement
Gets the status of the work request with the given Work Request ID
getWorkRequest
in interface DbManagement
request
- The request object containing the details to sendpublic ImplementOptimizerStatisticsAdvisorRecommendationsResponse implementOptimizerStatisticsAdvisorRecommendations(ImplementOptimizerStatisticsAdvisorRecommendationsRequest request)
DbManagement
Asynchronously implements the findings and recommendations of the Optimizer Statistics Advisor execution.
implementOptimizerStatisticsAdvisorRecommendations
in interface DbManagement
request
- The request object containing the details to sendpublic ListAsmPropertiesResponse listAsmProperties(ListAsmPropertiesRequest request)
DbManagement
Gets the list of ASM properties for the specified managedDatabaseId.
listAsmProperties
in interface DbManagement
request
- The request object containing the details to sendpublic ListAssociatedDatabasesResponse listAssociatedDatabases(ListAssociatedDatabasesRequest request)
DbManagement
Gets the list of databases using a specific Database Management private endpoint.
listAssociatedDatabases
in interface DbManagement
request
- The request object containing the details to sendpublic ListAwrDbSnapshotsResponse listAwrDbSnapshots(ListAwrDbSnapshotsRequest request)
DbManagement
Lists AWR snapshots for the specified database in the AWR.
listAwrDbSnapshots
in interface DbManagement
request
- The request object containing the details to sendpublic ListAwrDbsResponse listAwrDbs(ListAwrDbsRequest request)
DbManagement
Gets the list of databases and their snapshot summary details available in the AWR of the specified Managed Database.
listAwrDbs
in interface DbManagement
request
- The request object containing the details to sendpublic ListConsumerGroupPrivilegesResponse listConsumerGroupPrivileges(ListConsumerGroupPrivilegesRequest request)
DbManagement
Gets the list of consumer group privileges granted to a specific user.
listConsumerGroupPrivileges
in interface DbManagement
request
- The request object containing the details to sendpublic ListCursorCacheStatementsResponse listCursorCacheStatements(ListCursorCacheStatementsRequest request)
DbManagement
Lists the SQL statements from shared SQL area, also called the cursor cache.
listCursorCacheStatements
in interface DbManagement
request
- The request object containing the details to sendpublic ListDataAccessContainersResponse listDataAccessContainers(ListDataAccessContainersRequest request)
DbManagement
Gets the list of containers for a specific user. This is only applicable if ALL_CONTAINERS !=‘Y’.
listDataAccessContainers
in interface DbManagement
request
- The request object containing the details to sendpublic ListDatabaseParametersResponse listDatabaseParameters(ListDatabaseParametersRequest request)
DbManagement
Gets the list of database parameters for the specified Managed Database. The parameters are listed in alphabetical order, along with their current values.
listDatabaseParameters
in interface DbManagement
request
- The request object containing the details to sendpublic ListDbManagementPrivateEndpointsResponse listDbManagementPrivateEndpoints(ListDbManagementPrivateEndpointsRequest request)
DbManagement
Gets a list of Database Management private endpoints.
listDbManagementPrivateEndpoints
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalAsmDiskGroupsResponse listExternalAsmDiskGroups(ListExternalAsmDiskGroupsRequest request)
DbManagement
Lists ASM disk groups for the external ASM specified by externalAsmId
.
listExternalAsmDiskGroups
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalAsmInstancesResponse listExternalAsmInstances(ListExternalAsmInstancesRequest request)
DbManagement
Lists the ASM instances in the specified external ASM.
listExternalAsmInstances
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalAsmUsersResponse listExternalAsmUsers(ListExternalAsmUsersRequest request)
DbManagement
Lists ASM users for the external ASM specified by externalAsmId
.
listExternalAsmUsers
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalAsmsResponse listExternalAsms(ListExternalAsmsRequest request)
DbManagement
Lists the ASMs in the specified external DB system.
listExternalAsms
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalClusterInstancesResponse listExternalClusterInstances(ListExternalClusterInstancesRequest request)
DbManagement
Lists the cluster instances in the specified external cluster.
listExternalClusterInstances
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalClustersResponse listExternalClusters(ListExternalClustersRequest request)
DbManagement
Lists the clusters in the specified external DB system.
listExternalClusters
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalDatabasesResponse listExternalDatabases(ListExternalDatabasesRequest request)
DbManagement
Lists the external databases in the specified compartment or in the specified DB system.
listExternalDatabases
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalDbHomesResponse listExternalDbHomes(ListExternalDbHomesRequest request)
DbManagement
Lists the DB homes in the specified external DB system.
listExternalDbHomes
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalDbNodesResponse listExternalDbNodes(ListExternalDbNodesRequest request)
DbManagement
Lists the external DB nodes in the specified external DB system.
listExternalDbNodes
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalDbSystemConnectorsResponse listExternalDbSystemConnectors(ListExternalDbSystemConnectorsRequest request)
DbManagement
Lists the external connectors in the specified external DB system.
listExternalDbSystemConnectors
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalDbSystemDiscoveriesResponse listExternalDbSystemDiscoveries(ListExternalDbSystemDiscoveriesRequest request)
DbManagement
Lists the external DB system discovery resources in the specified compartment.
listExternalDbSystemDiscoveries
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalDbSystemsResponse listExternalDbSystems(ListExternalDbSystemsRequest request)
DbManagement
Lists the external DB systems in the specified compartment.
listExternalDbSystems
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalExadataInfrastructuresResponse listExternalExadataInfrastructures(ListExternalExadataInfrastructuresRequest request)
DbManagement
Lists the Exadata infrastructure resources in the specified compartment.
listExternalExadataInfrastructures
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalExadataStorageConnectorsResponse listExternalExadataStorageConnectors(ListExternalExadataStorageConnectorsRequest request)
DbManagement
Lists the Exadata storage server connectors for the specified Exadata infrastructure.
listExternalExadataStorageConnectors
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalExadataStorageServersResponse listExternalExadataStorageServers(ListExternalExadataStorageServersRequest request)
DbManagement
Lists the Exadata storage servers for the specified Exadata infrastructure.
listExternalExadataStorageServers
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalListenerServicesResponse listExternalListenerServices(ListExternalListenerServicesRequest request)
DbManagement
Lists the database services registered with the specified external listener for the specified Managed Database.
listExternalListenerServices
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalListenersResponse listExternalListeners(ListExternalListenersRequest request)
DbManagement
Lists the listeners in the specified external DB system.
listExternalListeners
in interface DbManagement
request
- The request object containing the details to sendpublic ListJobExecutionsResponse listJobExecutions(ListJobExecutionsRequest request)
DbManagement
Gets the job execution for a specific ID or the list of job executions for a job, job run, Managed Database or Managed Database Group in a specific compartment. Only one of the parameters, ID, jobId, jobRunId, managedDatabaseId or managedDatabaseGroupId should be provided. If none of these parameters is provided, all the job executions in the compartment are listed. Job executions can also be filtered based on the name and status parameters.
listJobExecutions
in interface DbManagement
request
- The request object containing the details to sendpublic ListJobRunsResponse listJobRuns(ListJobRunsRequest request)
DbManagement
Gets the job run for a specific ID or the list of job runs for a job, Managed Database or Managed Database Group in a specific compartment. Only one of the parameters, ID, jobId, managedDatabaseId, or managedDatabaseGroupId should be provided. If none of these parameters is provided, all the job runs in the compartment are listed. Job runs can also be filtered based on name and runStatus parameters.
listJobRuns
in interface DbManagement
request
- The request object containing the details to sendpublic ListJobsResponse listJobs(ListJobsRequest request)
DbManagement
Gets the job for a specific ID or the list of jobs for a Managed Database or Managed Database Group in a specific compartment. Only one of the parameters, ID, managedDatabaseId or managedDatabaseGroupId, should be provided. If none of these parameters is provided, all the jobs in the compartment are listed. Jobs can also be filtered based on the name and lifecycleState parameters.
listJobs
in interface DbManagement
request
- The request object containing the details to sendpublic ListManagedDatabaseGroupsResponse listManagedDatabaseGroups(ListManagedDatabaseGroupsRequest request)
DbManagement
Gets the Managed Database Group for a specific ID or the list of Managed Database Groups in a specific compartment. Managed Database Groups can also be filtered based on the name parameter. Only one of the parameters, ID or name should be provided. If none of these parameters is provided, all the Managed Database Groups in the compartment are listed.
listManagedDatabaseGroups
in interface DbManagement
request
- The request object containing the details to sendpublic ListManagedDatabasesResponse listManagedDatabases(ListManagedDatabasesRequest request)
DbManagement
Gets the Managed Database for a specific ID or the list of Managed Databases in a specific
compartment. Managed Databases can be filtered based on the name parameter. Only one of the
parameters, ID or name should be provided. If neither of these parameters is provided, all
the Managed Databases in the compartment are listed. Managed Databases can also be filtered
based on the deployment type and management option. If the deployment type is not specified
or if it is ONPREMISE
, then the management option is not considered and Managed Databases
with ADVANCED
management option are listed.
listManagedDatabases
in interface DbManagement
request
- The request object containing the details to sendpublic ListObjectPrivilegesResponse listObjectPrivileges(ListObjectPrivilegesRequest request)
DbManagement
Gets the list of object privileges granted to a specific user.
listObjectPrivileges
in interface DbManagement
request
- The request object containing the details to sendpublic ListOptimizerStatisticsAdvisorExecutionsResponse listOptimizerStatisticsAdvisorExecutions(ListOptimizerStatisticsAdvisorExecutionsRequest request)
DbManagement
Lists the details of the Optimizer Statistics Advisor task executions, such as their duration, and the number of findings, if any. Optionally, you can specify a date-time range (of seven days) to obtain the list of executions that fall within the specified time range. If the date-time range is not specified, then the executions in the last seven days are listed.
listOptimizerStatisticsAdvisorExecutions
in interface DbManagement
request
- The request object containing the details to sendpublic ListOptimizerStatisticsCollectionAggregationsResponse listOptimizerStatisticsCollectionAggregations(ListOptimizerStatisticsCollectionAggregationsRequest request)
DbManagement
Gets a list of the optimizer statistics collection operations per hour, grouped by task or object status for the specified Managed Database. You must specify a value for GroupByQueryParam to determine whether the data should be grouped by task status or task object status. Optionally, you can specify a date-time range (of seven days) to obtain collection aggregations within the specified time range. If the date-time range is not specified, then the operations in the last seven days are listed. You can further filter the results by providing the optional type of TaskTypeQueryParam. If the task type not provided, then both Auto and Manual tasks are considered for aggregation.
listOptimizerStatisticsCollectionAggregations
in interface DbManagement
request
- The request object containing the details to sendpublic ListOptimizerStatisticsCollectionOperationsResponse listOptimizerStatisticsCollectionOperations(ListOptimizerStatisticsCollectionOperationsRequest request)
DbManagement
Lists the Optimizer Statistics Collection (Auto and Manual) task operation summary for the specified Managed Database. The summary includes the details of each operation and the number of tasks grouped by status: Completed, In Progress, Failed, and so on. Optionally, you can specify a date-time range (of seven days) to obtain the list of operations that fall within the specified time range. If the date-time range is not specified, then the operations in the last seven days are listed. This API also enables the pagination of results and the opc-next-page response header indicates whether there is a next page. If you use the same header value in a consecutive request, the next page records are returned. To obtain the required results, you can apply the different types of filters supported by this API.
listOptimizerStatisticsCollectionOperations
in interface DbManagement
request
- The request object containing the details to sendpublic ListPreferredCredentialsResponse listPreferredCredentials(ListPreferredCredentialsRequest request)
DbManagement
Gets the list of preferred credentials for a given Managed Database.
listPreferredCredentials
in interface DbManagement
request
- The request object containing the details to sendpublic ListProxiedForUsersResponse listProxiedForUsers(ListProxiedForUsersRequest request)
DbManagement
Gets the list of users on whose behalf the current user acts as proxy.
listProxiedForUsers
in interface DbManagement
request
- The request object containing the details to sendpublic ListProxyUsersResponse listProxyUsers(ListProxyUsersRequest request)
DbManagement
Gets the list of proxy users for the current user.
listProxyUsers
in interface DbManagement
request
- The request object containing the details to sendpublic ListRolesResponse listRoles(ListRolesRequest request)
DbManagement
Gets the list of roles granted to a specific user.
listRoles
in interface DbManagement
request
- The request object containing the details to sendpublic ListSqlPlanBaselineJobsResponse listSqlPlanBaselineJobs(ListSqlPlanBaselineJobsRequest request)
DbManagement
Lists the database jobs used for loading SQL plan baselines in the specified Managed Database.
listSqlPlanBaselineJobs
in interface DbManagement
request
- The request object containing the details to sendpublic ListSqlPlanBaselinesResponse listSqlPlanBaselines(ListSqlPlanBaselinesRequest request)
DbManagement
Lists the SQL plan baselines for the specified Managed Database.
listSqlPlanBaselines
in interface DbManagement
request
- The request object containing the details to sendpublic ListSystemPrivilegesResponse listSystemPrivileges(ListSystemPrivilegesRequest request)
DbManagement
Gets the list of system privileges granted to a specific user.
listSystemPrivileges
in interface DbManagement
request
- The request object containing the details to sendpublic ListTableStatisticsResponse listTableStatistics(ListTableStatisticsRequest request)
DbManagement
Lists the database table statistics grouped by different statuses such as Not Stale Stats, Stale Stats, and No Stats. This also includes the percentage of each status.
listTableStatistics
in interface DbManagement
request
- The request object containing the details to sendpublic ListTablespacesResponse listTablespaces(ListTablespacesRequest request)
DbManagement
Gets the list of tablespaces for the specified managedDatabaseId.
listTablespaces
in interface DbManagement
request
- The request object containing the details to sendpublic ListUsersResponse listUsers(ListUsersRequest request)
DbManagement
Gets the list of users for the specified managedDatabaseId.
listUsers
in interface DbManagement
request
- The request object containing the details to sendpublic ListWorkRequestErrorsResponse listWorkRequestErrors(ListWorkRequestErrorsRequest request)
DbManagement
Returns a paginated list of errors for a given work request.
listWorkRequestErrors
in interface DbManagement
request
- The request object containing the details to sendpublic ListWorkRequestLogsResponse listWorkRequestLogs(ListWorkRequestLogsRequest request)
DbManagement
Returns a paginated list of logs for a given work request.
listWorkRequestLogs
in interface DbManagement
request
- The request object containing the details to sendpublic ListWorkRequestsResponse listWorkRequests(ListWorkRequestsRequest request)
DbManagement
The list of work requests in a specific compartment was retrieved successfully.
listWorkRequests
in interface DbManagement
request
- The request object containing the details to sendpublic LoadSqlPlanBaselinesFromAwrResponse loadSqlPlanBaselinesFromAwr(LoadSqlPlanBaselinesFromAwrRequest request)
DbManagement
Loads plans from Automatic Workload Repository (AWR) snapshots. You must specify the beginning and ending of the snapshot range. Optionally, you can apply a filter to load only plans that meet specified criteria. By default, the optimizer uses the loaded plans the next time that the database executes the SQL statements.
loadSqlPlanBaselinesFromAwr
in interface DbManagement
request
- The request object containing the details to sendpublic LoadSqlPlanBaselinesFromCursorCacheResponse loadSqlPlanBaselinesFromCursorCache(LoadSqlPlanBaselinesFromCursorCacheRequest request)
DbManagement
Loads plans for statements directly from the shared SQL area, also called the cursor cache. By applying a filter on the module name, the schema, or the SQL ID you identify the SQL statement or set of SQL statements to load.
loadSqlPlanBaselinesFromCursorCache
in interface DbManagement
request
- The request object containing the details to sendpublic PatchExternalDbSystemDiscoveryResponse patchExternalDbSystemDiscovery(PatchExternalDbSystemDiscoveryRequest request)
DbManagement
Patches the external DB system discovery specified by externalDbSystemDiscoveryId
.
patchExternalDbSystemDiscovery
in interface DbManagement
request
- The request object containing the details to sendpublic RemoveDataFileResponse removeDataFile(RemoveDataFileRequest request)
DbManagement
Removes a data file or temp file from the tablespace.
removeDataFile
in interface DbManagement
request
- The request object containing the details to sendpublic RemoveManagedDatabaseFromManagedDatabaseGroupResponse removeManagedDatabaseFromManagedDatabaseGroup(RemoveManagedDatabaseFromManagedDatabaseGroupRequest request)
DbManagement
Removes a Managed Database from a Managed Database Group. Any management activities that are currently running on this database will continue to run to completion. However, any activities scheduled to run in the future will not be performed on this database.
removeManagedDatabaseFromManagedDatabaseGroup
in interface DbManagement
request
- The request object containing the details to sendpublic ResetDatabaseParametersResponse resetDatabaseParameters(ResetDatabaseParametersRequest request)
DbManagement
Resets database parameter values to their default or startup values.
resetDatabaseParameters
in interface DbManagement
request
- The request object containing the details to sendpublic ResizeDataFileResponse resizeDataFile(ResizeDataFileRequest request)
DbManagement
Resizes a data file or temp file within the tablespace.
resizeDataFile
in interface DbManagement
request
- The request object containing the details to sendpublic RunHistoricAddmResponse runHistoricAddm(RunHistoricAddmRequest request)
DbManagement
Creates and executes a historic ADDM task using the specified AWR snapshot IDs. If an existing ADDM task uses the provided awr snapshot IDs, the existing task will be returned.
runHistoricAddm
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeAwrDbCpuUsagesResponse summarizeAwrDbCpuUsages(SummarizeAwrDbCpuUsagesRequest request)
DbManagement
Summarizes the AWR CPU resource limits and metrics for the specified database in AWR.
summarizeAwrDbCpuUsages
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeAwrDbMetricsResponse summarizeAwrDbMetrics(SummarizeAwrDbMetricsRequest request)
DbManagement
Summarizes the metric samples for the specified database in the AWR. The metric samples are summarized based on the Time dimension for each metric.
summarizeAwrDbMetrics
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeAwrDbParameterChangesResponse summarizeAwrDbParameterChanges(SummarizeAwrDbParameterChangesRequest request)
DbManagement
Summarizes the database parameter change history for one database parameter of the specified database in AWR. One change history record contains the previous value, the changed value, and the corresponding time range. If the database parameter value was changed multiple times within the time range, then multiple change history records are created for the same parameter. Note that this API only returns information on change history details for one database parameter. To get a list of all the database parameters whose values were changed during a specified time range, use the following API endpoint: /managedDatabases/{managedDatabaseId}/awrDbs/{awrDbId}/awrDbParameters
summarizeAwrDbParameterChanges
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeAwrDbParametersResponse summarizeAwrDbParameters(SummarizeAwrDbParametersRequest request)
DbManagement
Summarizes the database parameter history for the specified database in AWR. This includes the list of database parameters, with information on whether the parameter values were modified within the query time range. Note that each database parameter is only listed once. Depending on the optional query parameters, the returned summary gets all the database parameters, which include:
- Each parameter whose value was changed during the time range: (valueChanged =\"Y\") - Each parameter whose value was unchanged during the time range: (valueChanged =\"N\") - Each parameter whose value was changed at the system level during the time range: (valueChanged =\"Y\" and valueModified = \"SYSTEM_MOD\") - Each parameter whose value was unchanged during the time range, however, the value is not the default value: (valueChanged =\"N\" and valueDefault = \"FALSE\")
Note that this API does not return information on the number of times each database parameter has been changed within the time range. To get the database parameter value change history for a specific parameter, use the following API endpoint: /managedDatabases/{managedDatabaseId}/awrDbs/{awrDbId}/awrDbParameterChanges
summarizeAwrDbParameters
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeAwrDbSnapshotRangesResponse summarizeAwrDbSnapshotRanges(SummarizeAwrDbSnapshotRangesRequest request)
DbManagement
Summarizes the AWR snapshot ranges that contain continuous snapshots, for the specified Managed Database.
summarizeAwrDbSnapshotRanges
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeAwrDbSysstatsResponse summarizeAwrDbSysstats(SummarizeAwrDbSysstatsRequest request)
DbManagement
Summarizes the AWR SYSSTAT sample data for the specified database in AWR. The statistical data is summarized based on the Time dimension for each statistic.
summarizeAwrDbSysstats
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeAwrDbTopWaitEventsResponse summarizeAwrDbTopWaitEvents(SummarizeAwrDbTopWaitEventsRequest request)
DbManagement
Summarizes the AWR top wait events.
summarizeAwrDbTopWaitEvents
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeAwrDbWaitEventBucketsResponse summarizeAwrDbWaitEventBuckets(SummarizeAwrDbWaitEventBucketsRequest request)
DbManagement
Summarizes AWR wait event data into value buckets and frequency, for the specified database in the AWR.
summarizeAwrDbWaitEventBuckets
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeAwrDbWaitEventsResponse summarizeAwrDbWaitEvents(SummarizeAwrDbWaitEventsRequest request)
DbManagement
Summarizes the AWR wait event sample data for the specified database in the AWR. The event data is summarized based on the Time dimension for each event.
summarizeAwrDbWaitEvents
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeExternalAsmMetricsResponse summarizeExternalAsmMetrics(SummarizeExternalAsmMetricsRequest request)
DbManagement
Gets metrics for the external ASM specified by externalAsmId
.
summarizeExternalAsmMetrics
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeExternalClusterMetricsResponse summarizeExternalClusterMetrics(SummarizeExternalClusterMetricsRequest request)
DbManagement
Gets metrics for the external cluster specified by externalClusterId
.
summarizeExternalClusterMetrics
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeExternalDbNodeMetricsResponse summarizeExternalDbNodeMetrics(SummarizeExternalDbNodeMetricsRequest request)
DbManagement
Gets metrics for the external DB node specified by externalDbNodeId
.
summarizeExternalDbNodeMetrics
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeExternalDbSystemAvailabilityMetricsResponse summarizeExternalDbSystemAvailabilityMetrics(SummarizeExternalDbSystemAvailabilityMetricsRequest request)
DbManagement
Gets availability metrics for the components present in the external DB system specified by
externalDbSystemId
.
summarizeExternalDbSystemAvailabilityMetrics
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeExternalListenerMetricsResponse summarizeExternalListenerMetrics(SummarizeExternalListenerMetricsRequest request)
DbManagement
Gets metrics for the external listener specified by externalListenerId
.
summarizeExternalListenerMetrics
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeJobExecutionsStatusesResponse summarizeJobExecutionsStatuses(SummarizeJobExecutionsStatusesRequest request)
DbManagement
Gets the number of job executions grouped by status for a job, Managed Database, or Database Group in a specific compartment. Only one of the parameters, jobId, managedDatabaseId, or managedDatabaseGroupId should be provided.
summarizeJobExecutionsStatuses
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeManagedDatabaseAvailabilityMetricsResponse summarizeManagedDatabaseAvailabilityMetrics(SummarizeManagedDatabaseAvailabilityMetricsRequest request)
DbManagement
Gets the availability metrics related to managed database for the Oracle database specified by managedDatabaseId.
summarizeManagedDatabaseAvailabilityMetrics
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeSqlPlanBaselinesResponse summarizeSqlPlanBaselines(SummarizeSqlPlanBaselinesRequest request)
DbManagement
Gets the number of SQL plan baselines aggregated by their attributes.
summarizeSqlPlanBaselines
in interface DbManagement
request
- The request object containing the details to sendpublic SummarizeSqlPlanBaselinesByLastExecutionResponse summarizeSqlPlanBaselinesByLastExecution(SummarizeSqlPlanBaselinesByLastExecutionRequest request)
DbManagement
Gets the number of SQL plan baselines aggregated by the age of their last execution in weeks.
summarizeSqlPlanBaselinesByLastExecution
in interface DbManagement
request
- The request object containing the details to sendpublic TestPreferredCredentialResponse testPreferredCredential(TestPreferredCredentialRequest request)
DbManagement
Tests the preferred credential.
testPreferredCredential
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateDbManagementPrivateEndpointResponse updateDbManagementPrivateEndpoint(UpdateDbManagementPrivateEndpointRequest request)
DbManagement
Updates one or more attributes of a specific Database Management private endpoint.
updateDbManagementPrivateEndpoint
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateExternalAsmResponse updateExternalAsm(UpdateExternalAsmRequest request)
DbManagement
Updates the external ASM specified by externalAsmId
.
updateExternalAsm
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateExternalClusterResponse updateExternalCluster(UpdateExternalClusterRequest request)
DbManagement
Updates the external cluster specified by externalClusterId
.
updateExternalCluster
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateExternalClusterInstanceResponse updateExternalClusterInstance(UpdateExternalClusterInstanceRequest request)
DbManagement
Updates the external cluster instance specified by externalClusterInstanceId
.
updateExternalClusterInstance
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateExternalDbNodeResponse updateExternalDbNode(UpdateExternalDbNodeRequest request)
DbManagement
Updates the external DB node specified by externalDbNodeId
.
updateExternalDbNode
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateExternalDbSystemResponse updateExternalDbSystem(UpdateExternalDbSystemRequest request)
DbManagement
Updates the external DB system specified by externalDbSystemId
.
updateExternalDbSystem
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateExternalDbSystemConnectorResponse updateExternalDbSystemConnector(UpdateExternalDbSystemConnectorRequest request)
DbManagement
Updates the external connector specified by externalDbSystemConnectorId
.
updateExternalDbSystemConnector
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateExternalDbSystemDiscoveryResponse updateExternalDbSystemDiscovery(UpdateExternalDbSystemDiscoveryRequest request)
DbManagement
Updates the external DB system discovery specified by externalDbSystemDiscoveryId
.
updateExternalDbSystemDiscovery
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateExternalExadataInfrastructureResponse updateExternalExadataInfrastructure(UpdateExternalExadataInfrastructureRequest request)
DbManagement
Updates the details for the Exadata infrastructure specified by externalExadataInfrastructureId.
updateExternalExadataInfrastructure
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateExternalExadataStorageConnectorResponse updateExternalExadataStorageConnector(UpdateExternalExadataStorageConnectorRequest request)
DbManagement
Updates the Exadata storage server connector specified by exadataStorageConnectorId.
updateExternalExadataStorageConnector
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateExternalListenerResponse updateExternalListener(UpdateExternalListenerRequest request)
DbManagement
Updates the external listener specified by externalListenerId
.
updateExternalListener
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateJobResponse updateJob(UpdateJobRequest request)
DbManagement
Updates the details for the recurring scheduled job specified by jobId. Note that non-recurring (one time) jobs cannot be updated.
updateJob
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateManagedDatabaseGroupResponse updateManagedDatabaseGroup(UpdateManagedDatabaseGroupRequest request)
DbManagement
Updates the Managed Database Group specified by managedDatabaseGroupId.
updateManagedDatabaseGroup
in interface DbManagement
request
- The request object containing the details to sendpublic UpdatePreferredCredentialResponse updatePreferredCredential(UpdatePreferredCredentialRequest request)
DbManagement
Updates the preferred credential based on the credentialName.
updatePreferredCredential
in interface DbManagement
request
- The request object containing the details to sendpublic UpdateTablespaceResponse updateTablespace(UpdateTablespaceRequest request)
DbManagement
Updates the attributes of the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.
updateTablespace
in interface DbManagement
request
- The request object containing the details to sendpublic DbManagementWaiters getWaiters()
DbManagement
Gets the pre-configured waiters available for resources for this service.
getWaiters
in interface DbManagement
public DbManagementPaginators getPaginators()
DbManagement
Gets the pre-configured paginators available for list operations in this service which may
return multiple pages of data. These paginators provide an Iterable
interface so that service responses, or resources/records, can be iterated through without
having to manually deal with pagination and page tokens.
getPaginators
in interface DbManagement
protected ClientConfigurator getDefaultConfigurator()
public void useRealmSpecificEndpointTemplate(boolean useOfRealmSpecificEndpointTemplateEnabled)
useOfRealmSpecificEndpointTemplateEnabled
- This flag can be set to true or false to
enable or disable the use of realm-specific endpoint template respectivelypublic final void populateServiceParametersInEndpoint(String endpoint, Map<String,Object> requiredParametersMap)
endpoint
- The endpoint template in userequiredParametersMap
- Map of parameter name as key and value set in request path or
query parameter as valuepublic final void updateBaseEndpoint(String endpoint)
endpoint
- The updated endpoint to usepublic final void setEndpoint(String endpoint)
public final String getEndpoint()
public final void refreshClient()
HttpClient
. This will call ClientConfigurator
s again, and
can be used to e.g. refresh the SSL certificate.public final void close()
close
in interface AutoCloseable
Copyright © 2016–2023. All rights reserved.