DataBase

1、打开跟踪信息

SET AUTOT ON STAT

2、查看spfilepoli.ora内容

strings /u01/oracle/spfilepoli.ora | more

3、设置service_names

alter system set service_names='poli' scope=spfile;

4、设置instance_name

alter system set instance_name='poli' scope=spfile;

5、查看alert_SID.log文件

show parameter dump;

查看background_dump_dest参数值，即可查询到;

6、所谓检查点(checkpoint)，就是将数据写到数据文件中.

7、FAST_START_MTTR_TARGET

　　这个参数是在oracle 9i以后，出现的。DBA设置了FAST_START_MTTR_TARGET之后，ORACLE就会根据这个参数值，自动调整Checkpoint频率等信息，来自动适应FAST_START_MTTR_TARGET.

8、日志切换命令

　　alter system switch logfile;

9、SET AUTO[COMMIT] { OFF | ON | IMM[EDIATE] | n }

10、查看Database数据文件

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/RealData/oradata/DATACENTER/system01.dbf
/RealData/oradata/DATACENTER/sysaux01.dbf
/RealData/oradata/DATACENTER/undotbs01.dbf
/RealData/oradata/DATACENTER/users01.dbf
/RealData/oradata/DATACENTER/example01.dbf
/RealData/oradata/DATACENTER/TAB_U2_01.dbf
/RealData/oradata/DATACENTER/tab_u3_01.dbf
/RealData/oradata/DATACENTER/ts0_01.dbf
/RealData/oradata/DATACENTER/ts1_01.dbf
/RealData/oradata/DATACENTER/ts2_01.dbf
/RealData/oradata/DATACENTER/ts3_01.dbf

NAME
--------------------------------------------------------------------------------
/RealData/oradata/DATACENTER/ts4_01.dbf

12 rows selected.

View Datafile

11、查看Database数据库名称

SQL> select name from v$database;

NAME
---------
DATACENT

View Database Name

12、查看Database实例名称

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
DATACENTER

View Instance Name

13、数据库字典信息

SQL> select dbid,name,current_scn,protection_mode,database_role,force_logging,open_mode,switchover_status from v$database;

      DBID NAME      CURRENT_SCN PROTECTION_MODE      DATABASE_ROLE    FOR OPEN_MODE            SWITCHOVER_STATUS
---------- --------- ----------- -------------------- ---------------- --- -------------------- --------------------
2300574392 DB234         1081938 MAXIMUM PERFORMANCE  PRIMARY          NO  READ WRITE           NOT ALLOWED

View Code