oracle数据库常用的DBA命令 [英] Mostly used DBA Command for oracle databse

问题描述

任何人都可以告诉我在不同情况下(例如恢复，备份，授权和其他日常使用的命令)中用于oracle databse最低20-30命令的最常用的DBA(数据库管理员)命令.

预先谢谢你
Vishal

Can anyone tell me mostly used DBA(Data Base Administrator) commands for oracle databse minimum 20-30 command on different scenarios like recovery, backup, granting and other day to day used commands.

thank you in advance
Vishal

推荐答案

取决于dba的职位描述:可以包括:
-不同的RMAN命令
-特权处理GRANT/REVOKE
-用户创建CREATE USER
-对象:CREATE TABLE，INDEX，VIEW
-表空间CREATE TABLESPACE
-编程创建功能/过程/包装
-但最重要的是，他们具备良好的SQL技能，并且对固定数据字典和动态性能视图都非常了解

Well that depends on the job description for the dba: Could include:
- different RMAN commands
- privilege handling GRANT/REVOKE
- user creation CREATE USER
- objects: CREATE TABLE, INDEX, VIEW
- tablespaces CREATE TABLESPACE
- programming CREATE FUNCTION/PROCEDURE/PACKAGE
- but most of all good SQL skills and understanding on both fixed data dictionary and dynamic performance views

这篇关于oracle数据库常用的DBA命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！