- 博客(8)
- 资源 (4)
- 问答 (1)
- 收藏
- 关注
转载 定位version count 高的脚本
本文来自于oracle官方REQUIREMENTSThe view and function must be installed while connected to SYS (can be done with / as sysdba).The function also must be run using a query as SYS.The function accepts t
2014-11-30 15:27:59 1296
原创 orcle数据库启动验证
数据库启动验证alter session set events 'immediate trace name file_hdrs level 10' dump 所有数据文件头部的控制文件项(一部分信息来自控制文件,一部分来自数据文件)如下dump来理解数据的启动验证SQL> shutdown abortORACLE 例程已经关闭。SQL>SQL> startup moun
2014-11-21 16:24:18 589
原创 查询未绑定变量的sql
--10g之前SELECTsubstr(sql_text,1,40) "SQL", count(*) , sum(executions)"TotExecs" FROMv$sqlarea WHEREexecutions GROUPBY substr(sql
2014-11-12 09:58:27 1610
原创 oracle 大牛李玉根的博客有机会一一拜读在这里收藏一下地址
oracle 大牛李玉根的博客有机会一一拜读在这里收藏一下地址http://www.liyugen.com/
2014-11-11 12:38:14 1625
原创 Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g/11g (文档 ID 28814.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 7.0.16.0 to 11.2.0.2.0 [Release 7.0 to 11.2]Information in this document applies to any platform.PURPOSEHandling Oracle Block Corrup
2014-11-10 16:30:23 1290
原创 rman恢复rac到单实例数据库
In this Document Goal Solution ReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.1 and laterInformation in this do
2014-11-10 13:36:21 638
原创 存储过程里的序列报错Error: PLS-00302: component 'SEQUENCE_NAME' must be declared
今天遇到一个奇怪的问题,存储过程的tiao'y
2014-11-06 16:44:31 22899 2
原创 创建触发器报PL/SQL: ORA-00942: 表或视图不存在
SQL> create user u1 identified by u1;用户已创建。SQL> grant dba to prod;授权成功。SQL> grant dba to u1;授权成功。SQL> create user u2 identified by u2;用户已创建。SQL> grant dba to u2;授权成功。SQL> c
2014-11-04 09:43:56 13184
服务器内存告警,发现是oracle 归档进程arch 占用超过10G(每个arch进程)
2014-05-01
TA创建的收藏夹 TA关注的收藏夹
TA关注的人