| Operation | Description |
|---|---|
| Create a tenant | You can perform this operation to create a tenant. |
| Unit specification management | You can perform this operation to add, modify, and delete unit specifications. |
| Create a user under an Oracle tenant | You can perform this operation to create a user under an Oracle tenant. |
| Lock a tenant | You can perform this operation to lock a tenant so that it cannot be accessed by users. |
| Copy a tenant | You can perform this operation to quickly create a tenant by copying an existing tenant. |
| Delete a tenant | You can perform this operation to delete a tenant that is in the disabled state. |
| Create a replica | You can perform this operation to create a replica for a tenant. |
| Change the password of the SYS tenant | You can perform this operation to change the password of the SYS tenant. |
| Edit a tenant replica of a zone | You can perform this operation to modify the tenant replica information, including the replica type, unit specification, unit quantity, and zone priority. |
| Delete a tenant replica from a zone | You can perform this operation to delete a tenant replica from a zone. |
| Modify zone priorities | You can perform this operation to modify the priority of a zone. |
| Modify the whitelist | You can perform this operation to enable other clients to access a tenant by modifying the whitelist of the tenant. |
| View the topology of a tenant | The tenant topology provides the following information: the distribution of the tenant replicas in the cluster, the cluster in which the replicas and tenant are located, and the status of the hosts on which the replicas depend. |
| Database management | You can perform this operation to view, create, delete, and modify databases in a tenant. |
| User management under a MySQL tenant | You can perform this operation to view users, create and delete a user, and grant and revoke user privileges in the current MySQL tenant. |
| User overview under an Oracle tenant | You can perform the user management operation to view users and roles in an Oracle tenant. |
| Create a user under an Oracle tenant | You can perform this operation to create a user under an Oracle tenant. |
| Change the password of a user under an Oracle tenant | You can perform this operation to change the password of a user under an Oracle tenant. |
| Delete a user under an Oracle tenant | You can perform this operation to delete a user under an Oracle tenant. |
| Create a role under an Oracle tenant | You can perform this operation to create a role under an Oracle tenant. |
| Manage users | You can perform this operation to modify system privileges and roles of a user under an Oracle tenant and add accessible objects for the user. |
| Manage roles | You can perform this operation to modify a role and its system privileges and add accessible objects for the role. |
| Performance monitoring | You can perform this operation to view the performance statistics of a tenant. |
| Tenant resource management | You can perform this operation to view the resource usage tendency and the information about databases and table groups of a tenant. |
| Transaction diagnostics | You can perform this operation to identify and analyze large transactions. |
| Suspicious SQL diagnostics | You can perform this operation to view the SQL statements that meet the diagnostic conditions and the suggested solutions. |
| Top SQL diagnostics | You can perform this operation to view the SQL statements with the longest average execution time in a tenant and other execution-related information. |
| Slow SQL diagnostics | You can perform this operation to identify SQL statements whose execution time exceeds 100 ms. You can use the slow SQL diagnostics feature to identify risky statements and avoid risks. |
| ParallelSQL diagnostics | ParallelSQL displays the SQL statements that involve multiple server nodes in a single execution. You can perform this operation to troubleshoot SQL problems such as complex SQL statements and irreproducible SQL problems. |
| View SQL statement details | You can perform this operation to view SQL statement details, including the execution status, execution plans, bound indexes, and whether throttling is enabled. |
| View the SQL collection enable/disable history | You can perform this operation to view the SQL collection enable/disable operations. |
| View outlines | You can perform this operation to view outlines of the current tenant, including the outlines for throttling, execution plan binding, and index binding. |
| View request analysis | You can perform this operation to learn of the overall SQL execution status based on the execution time distribution of different types of SQL statements on the request analysis page. |
| Back up and recover a tenant | You can perform this operation to initiate a recovery task to recover the current tenant and view the backup strategies and details of recovery tasks. |
| View tenant sessions | You can perform this operation to view all sessions and active sessions of the current tenant and retrieve sessions. |
| View session statistics | You can perform this operation to view session statistics of the currently logged-on user in different dimensions. |
| View deadlock analysis | You can perform this operation to view all deadlocks and deadlock analysis results in the current tenant. |
| Manage the ASH report | You can perform this operation to generate and view the Active Sessions History (ASH) report. |
| View parameters | You can perform this operation to view all parameters of the current tenant or parameters that meet the specified search criteria. |
| Modify parameters | You can perform this operation to modify the parameter values of the current tenant. |
| View the parameter modification history | You can perform this operation to view the parameter modification records of the current tenant. |
| Manage tenant parameter templates | A tenant parameter template contains predefined tenant parameters. You can use a tenant parameter template to create a series of tenants that have similar configurations without the need to repeatedly configure tenant parameters. |
Tenant management operations
share
Previous topic