oracle笔记2

1。查看globalname
select * from global_name;
2.查看执行计划
select * from table(dbms_xplan.display);
3.修改当前session语言
alter session set nls_language=american;
4.kill session
alter system kill session 'sid,SERIAL#';
5.oracle 状态模式
restricted ：alter system enable restricted session;
read-only: alter database open read only;首先：startup mount
6.查看为提交事务
select * from v$transaction;
7.日志文件
alertSID.log
8.trace文件
session level:
alter session set sql_trace = true;每一个操作都被记录
或：dbms_system.set_sql_trace_in_session
instance level:
sql_trace = true;
9. 数据库些文件
sql.bsq 创建数据库
catalog.sql 创建视图和同义词
catproc.sql 装些PL/SQL包
10.数据字典（Data Dictionary）

(1)视图（Data Dictionary view）：
dba_,all_,user_
[img]http://dl.iteye.com/upload/attachment/395341/af84acb8-3e14-359b-abba-1aaa75fcf79b.jpg[/img]

常用视图：
[img]http://dl.iteye.com/upload/attachment/395357/a15f45ef-47c5-3039-b5c5-4b6fe9d2a987.jpg[/img]
(2)动态性能表

[img]http://dl.iteye.com/upload/attachment/395363/1f8ebeae-42e9-3047-a94c-bc1ee0d390fc.jpg[/img]
常用的动态性能表：

[img]http://dl.iteye.com/upload/attachment/395372/8584b395-ecf8-3d88-bd12-449e46ac882c.jpg[/img]
11.数据库启动
(1)nomount

[img]http://dl.iteye.com/upload/attachment/395401/556024be-8521-310c-8488-eedc46a4fbdc.jpg[/img]

(2)mount

[img]http://dl.iteye.com/upload/attachment/395404/936710d3-5b20-3a73-a27a-ecaacfd9fcb0.jpg[/img]

(3)open

[img]http://dl.iteye.com/upload/attachment/395406/436de621-13df-3a3f-9bbc-0a885adea8ea.jpg[/img]