(3)Manage a Oracle Instance

• Init Parameter Start Sequence
  spfile<sid>.ora--------spfile.ora-----------init<sid>
  select * from v$system_parameter    查看所有参数
  alter system set name=value scope=memory(spfile,both)
  desc v$system_parameter
  ISSES_MODIFIABLE(true,false)    ISSYS_MODIFIABLE(immediate,deferred,none)
• Create spfile
  create spfile from pfile
• Oracle Managed File (OMF)
  DB_CREATE_FILE_DEST: for data files
  DB_CREATE_ONLINE_LOG_DEST_N: redo, control files N maximun=5
  drop tablespace xxx including contents and datafiles
• Startup
  startup [nomount|mount|open]
              pfile=
              restrict
              recovery
              force
  alter database db01 mount
  alter database db01 open read only
  alter database open read only
  alter system enable restricted session
  grant restricted session to xxx
  alter system disable restricted session
• shutdown
  Normal       transactional        immediate        abort
  
• Diagnostic Files
  alterSID.log                        (bdump)                        BACKGROUND_DUMP_DEST
  Background trace files       (bdump)                        BACKGROUND_DUMP_DEST
  User trace files                   (udump)                        缺省是关闭的 USER_DUMP_DEST    MAX_DUMP_FILE_SIZE(default 10M)
  sql_trace                            boolean     FALSE
  trace_enabled                    boolean     TRUE

          Session level: dbms_system.SET_SQL_TRACE_IN_SESSION
          （1）execute DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(7, 1304, true);
         （2）SELECT t.SID,t.SERIAL# FROM v$session t