- 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