@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 (storage server, storage server
connectors and 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.
|
CheckExternalDbSystemConnectorConnectionStatusResponse |
checkExternalDbSystemConnectorConnectionStatus(CheckExternalDbSystemConnectorConnectionStatusRequest request)
Checks the status of the external DB system component connection specified in this connector.
|
CheckExternalExadataStorageConnectorResponse |
checkExternalExadataStorageConnector(CheckExternalExadataStorageConnectorRequest request)
Check the status of the Exadata storage server connection specified by
exadataStorageConnectorId.
|
void |
close() |
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 enable monitoring service on the
exadata infrastructure.
|
CreateExternalExadataStorageConnectorResponse |
createExternalExadataStorageConnector(CreateExternalExadataStorageConnectorRequest request)
Create the 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 the Exadata infrastructure specified by externalExadataInfrastructureId.
|
DeleteExternalExadataStorageConnectorResponse |
deleteExternalExadataStorageConnector(DeleteExternalExadataStorageConnectorRequest request)
Deletes the 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.
|
DisableExternalDbSystemDatabaseManagementResponse |
disableExternalDbSystemDatabaseManagement(DisableExternalDbSystemDatabaseManagementRequest request)
Disables Database Management service for all the components of the specified external DB
system (except databases).
|
DisableExternalExadataInfrastructureManagementResponse |
disableExternalExadataInfrastructureManagement(DisableExternalExadataInfrastructureManagementRequest request)
Disables Database Management service for the Exadata infrastructure specified by
externalExadataInfrastructureId.
|
DiscoverExternalExadataInfrastructureResponse |
discoverExternalExadataInfrastructure(DiscoverExternalExadataInfrastructureRequest request)
Completes the Exadata system prechecking on the following: Verifies if the database systems
are valid RAC database systems.
|
DropTablespaceResponse |
dropTablespace(DropTablespaceRequest request)
Drops the tablespace specified by tablespaceName within the Managed Database specified by
managedDatabaseId.
|
EnableExternalDbSystemDatabaseManagementResponse |
enableExternalDbSystemDatabaseManagement(EnableExternalDbSystemDatabaseManagementRequest request)
Enables Database Management service for all the components of the specified external DB
system (except databases).
|
EnableExternalExadataInfrastructureManagementResponse |
enableExternalExadataInfrastructureManagement(EnableExternalExadataInfrastructureManagementRequest request)
Enables Database Management service for the exadata infrastructure specified by
externalExadataInfrastructureId.
|
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 the Exadata infrastructure specified by
externalExadataInfrastructureId.
|
GetExternalExadataStorageConnectorResponse |
getExternalExadataStorageConnector(GetExternalExadataStorageConnectorRequest request)
Gets the details for the storage server connector specified by exadataStorageConnectorId.
|
GetExternalExadataStorageGridResponse |
getExternalExadataStorageGrid(GetExternalExadataStorageGridRequest request)
Gets the details for the storage server grid specified by exadataStorageGridId.
|
GetExternalExadataStorageServerResponse |
getExternalExadataStorageServer(GetExternalExadataStorageServerRequest request)
Gets the summary for the 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)
Get open alerts from 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.
|
GetTablespaceResponse |
getTablespace(GetTablespaceRequest request)
Gets the details of the tablespace specified by tablespaceName within the Managed Database
specified by managedDatabaseId.
|
GetTopSqlCpuActivityResponse |
getTopSqlCpuActivity(GetTopSqlCpuActivityRequest request)
Get SQL ID with top cpu activity from 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.
|
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 infrastructures for a specific compartment.
|
ListExternalExadataStorageConnectorsResponse |
listExternalExadataStorageConnectors(ListExternalExadataStorageConnectorsRequest request)
Lists the connectors for the specific Exadata infrastructures.
|
ListExternalExadataStorageServersResponse |
listExternalExadataStorageServers(ListExternalExadataStorageServersRequest request)
Lists all the storage servers for the exadata infrastructure or storage grid.
|
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.
|
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.
|
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.
|
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 the Exadata infrastructure specified by
externalExadataInfrastructureId.
|
UpdateExternalExadataStorageConnectorResponse |
updateExternalExadataStorageConnector(UpdateExternalExadataStorageConnectorRequest request)
Updates the details for the 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 (storage server, storage server connectors and 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 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
Check the status of the Exadata storage server connection specified by exadataStorageConnectorId.
checkExternalExadataStorageConnector
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 enable monitoring service on 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
Create the storage server connector after validating the connection information. Or only validates the connection information for creating the connection to the storage server. The connector for one storage server is associated with the Exadata infrastructure discovery or existing Exadata infrastructure.
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 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 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 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 DisableExternalExadataInfrastructureManagementResponse disableExternalExadataInfrastructureManagement(DisableExternalExadataInfrastructureManagementRequest request)
DbManagement
Disables Database Management service for the Exadata infrastructure specified by externalExadataInfrastructureId. It covers the following components Exadata infrastructure Exadata storage grid Exadata storage server Database systems within the Exdata infrastructure will not be impacted and should be disabled explicitly if needed.
disableExternalExadataInfrastructureManagement
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 database systems are valid RAC database systems. Otherwise, return 400 status code with NON_RAC_DATABASE_SYSTEM error code. Verifies if the ASM connectors defined for each database system. Otherwise, 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 storage servers. Otherwise, return 400 status code with INVALID_AGENT error code. Verifies if it is an Exadata system. Otherwise, return 400 status code with INVALID_EXADATA_SYSTEM error code.
Starts the discovery process for the Exadata system infrastructure.The following resources/components could be discovered storage servers from each database systems storage grid for all storage server exadata infrastructure The same API covers both new discovery and re-discovery cases. For the new discovery case, new managed resources/sub-resources are created or override the existing one. For re-discovery case, the existing managed resources/sub-resources are checked to find out which ones should be added or which one 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 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 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 EnableExternalExadataInfrastructureManagementResponse enableExternalExadataInfrastructureManagement(EnableExternalExadataInfrastructureManagementRequest request)
DbManagement
Enables Database Management service 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 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 the Exadata infrastructure specified by externalExadataInfrastructureId. It includes the database 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 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 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 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
Get open alerts from 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 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
Get SQL ID with top cpu activity from 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 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 infrastructures for a specific compartment.
listExternalExadataInfrastructures
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalExadataStorageConnectorsResponse listExternalExadataStorageConnectors(ListExternalExadataStorageConnectorsRequest request)
DbManagement
Lists the connectors for the specific Exadata infrastructures.
listExternalExadataStorageConnectors
in interface DbManagement
request
- The request object containing the details to sendpublic ListExternalExadataStorageServersResponse listExternalExadataStorageServers(ListExternalExadataStorageServersRequest request)
DbManagement
Lists all the storage servers for the exadata infrastructure or storage grid.
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 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 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 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 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 details for the 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.