-
编辑 删除
数据库启动，关闭，restore时scn的情况
1,当数据库clean shutdown时 (normal，immediate)，ckpt进程会将scn写到四个地方去，其中control file中有3个，datafile中1个----control file的三个地方1.System checkpoint SCN ===========> (SYSTEM CHECKPOINT SCN in control file)SQL> select checkpoint_change# from v$database;2.Datafile checkpoint SCN ===============> (DATAFILE CHECKPOINT SCN in control file)SQL> select name,checkpoint_change# from v$datafile 3.Stop SCN ======================> (STOP SCN in control file)SQL> select name,la
-
编辑 删除
ORACLE 动态注册和静态注册的区别
1, oracle 10g 用netca方式建立的都默认为动态注册方式2，如果想改为静态注册的方式则在listener.ora 中加入如下内容即可SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = JEFF ) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) --就这一段 (GLOBAL_DBNAME = jeff) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCO
