为什么oracle要引入检查点机制?降低实例恢复的时间通过实验来简单观察下checkpointSQL> select file#,checkpoint_change# from v$datafile order by 1; FILE# CHECKPOINT_CHANGE#---------- ------------------ 1 &nb...【阅读全文】
Start RUEI processing:# On the Reporter server as $RUEI_USERproject -start wgStart the RUEI web server:# On the Reporter server as root service httpd startTo start the Collector, issue the following command as the moniforce user:appsensor start wg【阅读全文】
1.查看所有用户:select * from dba_users;select * from all_users;select * from user_users; //查看当前用户二、查看角色1.当前用户被激活的全部角色 select * from session_roles;3.全部用户被授予的角色 select * from dba_role_privs;select * from dba_role...【阅读全文】
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 18 20:47:22 2011Connected to an idle instance.LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-JAN-2011 20:48:58Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Al...【阅读全文】
目标库和复制库环境: OS: Linux Red Hat AS 4 DB Version: 11.2.0.4 1.目标库和复制库信息 Rman 中的目标库(target database)指的是被复制的库,复制库(duplicate database)是指复制后生成的新库(生成新的DBID).这里为了测试方便,复制库和目标库的目录结构设置相同. 目标库: ...【阅读全文】
1. 确保主库和备库的mgr进程正常运行info all查看2.确保主库的extract正常运行这样的话主库的日志会传到从库的dirdat目录3.创建从库初始化化参数文件文件SQL>connect / as sysdbaConnected.SQL>create pfile='/home/oracle/initslnngk.ora' from spfile;...【阅读全文】
博客文章除注明转载外,均为原创。转载请注明出处。本文链接地址:http://blog.chinaunix.net/uid-31396856-id-5784934.htmlOracle视图except SNAP_ID, and INSTANCE_NUMBER等字段dba_hist_active_sess_history视图的详细信息,请见下表列数据类型NULL...【阅读全文】