提供综合数据库运维服务与优化方案(不限Oracle MySQL PG GaussDB GoldenDB OceanBase等), 微信/Tel:(+86)134-365-60330
数据库oracle
Automatic block repair allows corrupt data blocks to be automatically repaired as soon as the corruption is detected. This feature reduces the amount of time that data is inaccessible due to block corruption.
今天刚搭建的一个Data guard环境，一开始在日志传输时遇到ora-12592错误，ORA-12592: TNS:bad packet
一个不错的oracle AWR 报告本地文件格式化chrome浏览器插件，看似用js完成，有一些特性非常不错，拿出来分享，作者Tyler Muth –观看 需要翻墙 视频介绍 下载 下载地址1 下载地址2 安装方法 1，下载AWR-Format.crx文件 2，打开chrome 谷歌浏览器，我这里版本是28，点击右上角的按钮或显示菜单，找工具–扩展程序 打开扩展程序页面 3，用鼠标把1 下载的文件托进浏览器的这个页面，增加插件，默认是启用，勾选插件下的“允许访问文件网址” 4，右击本地的AWR html文件，使用google chrome 打开，体验一下吧 — update 如果新版本的chrome 不支持， 可以修改crx为.rar ，解压文件夹，修改manifest.json 的manifest_version 为 3或更高，chrome修改为开发者模式，加载已解压的文件夹即可。
当你在windows NTFS文件系统操作大的数据文件时，有时会遇到下面的错误:
The operating system returned error 665 (The requested operation could not be completed due to a file system limitation)
# crsctl start has
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.
Prior to 10g you can use a unix debugger like gdb, adb or dbx to attach to a shadow process and dump the system state using the function ksudss which is the subroutine in the Oracle source code which does the same.
If you need to recovery the dead transaction record of more than 100(_cleanup_rollback_entries parameter value), PMON only responsible for cleaning up dead session, which is responsible for the SMON recovery dead transaction.
Shrink operations can be performed only on segments in locally managed tablespaces with automatic segment space management (ASSM). Within an ASSM tablespace. Restrictions on the shrink_clause.The shrink_clause is subject to the following restrictions…
insert into table “with” subquery Failing with the following internel error.
ORA-600: internal error code, arguments: [voprvl1], [], [], [], [], [], [], []
A description for this ORA-600 [2003] error is not yet published. ora-600 2663/2662 is a data block SCN is ahead of the current SCN.
Dynamic server tracing allows for tracing at a per-process level and can be enabled ad hoc on any running server process. This is useful for tracing individual server side processes of a specific client connection or for tracing background server processes.
上周也就是2013年的最后一天，突然客户反应有些WEB应用页面报错只提到了ora-28002, 我立即用sqlplus 登录提示是ora-28001,显然密码已经过期, 我清清楚记的才因为一起类似问题, 前不久把所有的oracle 数据库应用用户profile PASSWORD_LIFE_TIME改为unlimited，怎么还会这样呢?
Large objects (LOBs) are not supported in comparison conditions. However, you can use PL/SQL programs for comparisons on CLOB data.
skgpspawn failed:category = 27143, depinfo = 24, op = pipe, loc = skgpspawn2
…
oracle 12c release 1版本引入新功能可隐藏列(invisible columns),这个特性有很多的争议，不明白为什么ORACLE会推出这个特性，因为这个特性可能会带来很多麻烦..
今天开发的同事找我说是一个报表系统的SQL执行第一次很快，再执行就慢的几乎查询无响应，找他要来了SQL，也是常见的表关连LIFT JOIN 、GROUP BY的统计报表, 出于篇幅原因不再贴SQL， 把SQL放到TOAD 中问题依然可以再现，..
Adaptive Log File sync was introduced in 11.2. the feature is exactly enabled since release 11.2.0.3 , It’s enabled through an underscore parameter called _use_adaptive_log_file_sync and the description of this parameter is: adaptively switch between post/wait and polling. Oracle can switches between the 2 methods: Post/wait, traditional method for posting completion of writes to redo … Read more
Sometimes we need to enable sql*net trace to diagnose sqlplus connection problems such as ora-125*
Below are the steps to configure Sql*Net verbose Client side tracing:
Each time your program performs a function call, information about the call is generated. That information includes the location of the call in your program, the arguments of the call, and the local variables ..
This script displays the top 50 longest idle times and list distribution of sessions on the instance..