1.sql*plus行编辑命令
  L[ist] [n]
  A[ppend] text
  C[hange]/old/new
  C[hange]/text/
  CL[ear] Buff[er]
  Del [m] [n]
  I[nput] text
  n [text]
  O text

 

2.sql*plus文件操作命令
  Save/Get/Start/Edit/Spool/ filename
  Edit
  Exit

 

3.启动实例
  startup  open/mount/nomount
  shutdown normal/immediate/transactional/abort

 

4.连接数据库
  connect system/manager as sysdba;

 

* 启动实例（不打开数据库）后，打开数据库后，再关闭实例
  Connect system/hello@oratest AS SYSDBA
  startup mount
  alter database open
  shutdown normal

 

5.改变数据库为归档模式(注意要先装载，若数据库已打开则先要关闭再装载)
  Connect system/hello@oratest AS SYSDBA
  startup mount
  alter database archivelog/noarchivelog

 

6.常用数据字典
  all_catalog
  all_db_links
  all_tables/views/indexs/triggers/sequences/snapshots/synonyms/users

  user_audit_session
  user_audit_trail
  user_catalog
  user_db_links
  user_role_privs
  user_tables/views/indexs/triggers/sequences/snapshots/synonyms/users

  global_name

  session_privs
  session_roles

  查看所有用户/当前用户信息/用户与角色的关系
  select * from all_users;
  select * from user_users;
  select * from dba_role_privs where grantee = 'SYSTEM';

  查看SCOTT用户的所有表
  select table_name, table_type from all_catalog
   where owner = 'SCOTT' and table_type = 'TABLE';

  查看全局数据库名、当前用户使用的角色
  select * from global_name;
  select * from session_roles;

  查看当前用户所有的数据库链接
  select * from user_db_links;

  查看数据库版本号
  select * from product_component_version;

  查看控制文件、日志文件和临时文件
  select * from V$DATAFILE或DBA_DATA_FILES/V$LOGFILE/V$TEMPFILE;

 

7.暂停/继续数据库
  alter system suspend/resume;

-----------------------------------------------------------------------------------------------------
1.更改创建管理文件参数
   ALTER SYSTEM SET DB_CREATE_FILE_DEST = 'E:\oracle\oradata\Test10';
 ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_1 = 'E:\oracle\oradata\Test21';
 ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_2 = 'E:\oracle\oradata\Test22';
  创建表空间的数据文件
 create tablespace tbs1;
 create tablespace tbs2 datafile size 1M autoextend off;
 create tablespace tbs3 datafile autoextend on maxsize 101M;
 create tablespace tbs4 datafile size 2M, size 3M;
  创建撤消表空间
 create undo tablespace undotbs2;
  修改数据库时，创建数据文件
 alter tablespace tbs1 add datafile size 1M;
  创建临时文件
 create temporary tablespace tmptbs1;
 alter tablespace tmptbs1 add tempfile size 5M;
  创建日志文件
 alter database newDB add logfile 'E:\oracle\oradata\Test21\newlog.log' size 1M;
  查看当前数据库及其进程的状态
 select * from V$database;
        select * from V$instance;
  查看调度进程, 进程速率，共享服务器进程/队列
   select * from V$dispatcher;
 select * from V$dispatcher_rate;
 select * from V$shared_server;
 select * from V$queue;
  查看SGA的容量信息和详细统计信息
 select * from V$sga;
 select * from V$sgastat;
  设置、更改、关闭、查询调度进程
 alter system
    set dispatchers = '(protocol = tcp) (dispatchers = 3) (index =0)'
   select name, network from V$dispatcher;
 alter system shutdown immediate 'D002';
  禁止/允许并行程度 
 alter session disable parallel DDL;
 alter session enable parallel DML;
 alter session force parallel DDL parallel 5;

  查看控制、数据和日志文件
   select * from V$controlfile/V$datafile/V$logfile;