查看DG主、从机状态SELECT DESTINATION, STATUS, archiver,log_sequence ,error FROM V$ARCHIVE_DEST WHERE STATUS 'DEFERRED' AND STATUS 'INACTIVE';查看是否存在GAPselect * from v$archive_gap;查看DEST情况SELECT * from v$archi...【阅读全文】
1、查一下这些视图的定义你就能理解,它们的源都是一个。 SELECT view_definition FROM v$fixed_view_definition WHERE view_name='GV$SQL'; SELECT view_definition FROM v$fixed_view_definition WHERE view_name='GV$SQL_AREA'; 2、实际上最模糊的是v$sql与v$sqlarea,区别与联系除biti说的还有: ...【阅读全文】
Reference data is not available for verifying prerequisites on this operating system distribution Verification cannot proceed 在oracle linux 6.4上安装grid,安装前检查环境运行 runcluvfy.sh 报错,如下: [oracle@node2 grid]$ ./runcluvfy.sh stage -pre crsinst -n node1,node2 -ver...【阅读全文】
有时候对表进行了大量的更新操作或者在表中增加了一列含有默认值的列,那么就有可能出现表的行迁移情况,这种情况造成了对数据访问的过多的逻辑读HR@orcl>create table employee_test as select * from employees;表已创建。HR@orcl>desc employee_test名称 ...【阅读全文】
使用情况点击(此处)折叠或打开select name,space_limit/1024/1024/1024 总大小_g,space_used/1024/1024/1024 已用_G from v$recovery_file_dest;修改大小点击(此处)折叠或打开alter system set db_recovery_file_dest_size=80G;RMAN清...【阅读全文】
在操作系统内输入如下命令,来查看oracle错误号的详细信息[oracle@oracle ~]$ oerr ora 192101921, 00000, "role name '%s' conflicts with another user or role name"// *Cause: There is already a user or role with that name.// *Action: Specify a different role name....【阅读全文】