dba_les03_bj

最新推荐文章于 2025-10-21 22:09:11 发布

原创最新推荐文章于 2025-10-21 22:09:11 发布 · 697 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#session #statistics #system #database #initialization

oracle 技术专栏收录该内容

10 篇文章

订阅专栏

博客围绕Oracle数据库展开，介绍了系统参数设置，如动态和静态参数的修改，还涉及创建和删除表空间、数据库启动与挂载、会话限制等操作，同时提及日志恢复、跟踪文件相关内容，包括后台和用户跟踪文件的启用与禁用。

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