dba_les03_bj

set wrap off
set linesize 100

timed_statistics = TRUE
alter system set timed_statistics = false scope=memory; /spfile/both

动态参数 和 静态参数
v$system_parameter
ISSES_MODIFIABLE  IS SESSION MODIFIABLE
  alter session set ...
ISSYS_MODIFIABLE  IS SYSTEM  MODIFIABLE
  alter system set ...

create spfile from pfile;
create spfile='d:/oracle/ora90/database/spfile.ora' from pfile;

默认创建文件目录
show parameter db_create

alter system set db_create_file_dest='d:/oracle/oradb';
create tablespace test1;

9i
drop tablespace test1
including contents and datafiles;

startup [nomount|mount|open]
 pfile=
 restrict
 recovery
 force

alter database db01 mount;
alter database db01 open read only;

alter system enable restricted session;

alter database datafile 8 offline;/online;

恢复
1.Redo logs used to reapply changes
2.Undo segments used to roll back uncommitted changes
3.Resources released

altr文件  
Background trace files 后台进程出错写入trace file  background_dump_dest
User trace files 默认是关闭的 user_dump_dest
A user trace file is produced by the user process
connected to the Oracle server through the server process.

Enabling or disabling User Tracing
1 Session level using the Alter session command:
alter session set sql_trace = true
2 Session level by executing DBMS procedure:
dbms_system.SET_SQL_TRACE_IN_SESSION
3 Instance level by setting the initialization parameter:
SQL_TRACE = true