OGG Get Error "Statistics reply buffer exceeded. Results truncated..."
Statistics reply buffer exceeded truncated
oracle网络配置:三个配置文件
oracle网络配置 sqlnet tnsnames listener ora
简单记录下logmnr
oracle logmnr
UNDO使用率高,且unexpire过高
UNDO使用率高 且unexpire过高
oracle profiles
oracle profiles
Oracle Listener设置密码示例说明
Oracle Listener 设置密码 示例说明
OGG-00519 Fatal error executing DDL replication: [Error code [1435]
OGG-00519 DDL replication 1435
Oracle DBA的基本任务
Oracle DBA的基本任务
某数据库的节点4因网络问题,主机关闭
某数据库的节点4因网络问题,主机关闭。
Configuring non-raw Multipath Devices for Oracle Clusterware 11g
Configuring non-raw Multipath Devices for Oracle Clusterware 11g (11.1.0, 11.2.0) on RHEL6/OL6 (Doc ID 1538626.1)
数据库打完11.1.0.7.12补丁后数据库启动失败
数据库打完11.1.0.7.12补丁后数据库启动失败,需要打上相应的补丁。
数据库启动在mount状态,无任何报错
数据库启动在mount状态,无任何报错
ORA-1652: unable to extend temp segment by xxx in tablespace XXXXX
ORA-1652: unable to extend temp segment by xxx in tablespace XXXXX
ora.net1.network Could not Start
ora.net1.network Could not Start[grid@node01 bin]$ ./srvctl start nodeapps -n node01PRCR-1013 : Failed to start resource ora.net1.networkPRCR-1064 : Failed to start resource ora.net1.network on node ...
How to Troubleshoot Grid Infrastructure Startup Issues
How to Troubleshoot Grid Infrastructure Startup Issues [ID 1050908.1] -------------------------------------------------------------------------------- Modified 11-OCT-20...
How To Know If An Object (Table / Procedure / View /…) Is Currently Being
How To Know If An Object (Table / Procedure / View /…) Is Currently Being Applies to:Oracle Server – Enterprise Edition – Version: 10.2.0.5 and later [Release: 10.2 a...
hanganalyze分析会话阻塞
hanganalyze分析会话阻塞 参考文档:USING AND READING HANGANALYZE或者[ID 215858.1]1、模拟阻塞会话数据库版本:SQL> select * from v$version;BANNER----------------------------------------...
ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU613$
ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU613$ Error: ORA 1628 Text: max # of extents <num> reached for rollback s...
对索引开启monitoring方法
对索引开启monitoring方法 一个系统,经过长期的运行、维护和版本更新后,可能会产生大量的索引,甚至索引所占空间远远大于数据所占的空间。很多索引,在初期设计时,对于系统来说是有用的。但是...
查询表存在大量行迁移
查询表存在大量行迁移 新建chained_rowssqlplus / as sysdba@?/rdbms/admin/utlchain.sql 对所需要查询的表做分析:analyze table lf.t list chained rows into chained_rows; 查询分析后的...