-
编辑 删除
超恐怖的一篇文章【zt】
http://zelef.itpub.net/post/13575/233301
-
编辑 删除
ora-00600[2116]
os:tru64 ds20 4.0gdb: oracle8174 ops故障现象:数据库越来越慢,直到无法登陆,主机控制台键盘失效.用户重起了主机,盘柜,但两个oracle实例mount半小后报错:ora-00600[2116]系统里报错:所有的vg报无法恢复的io错误.解...
-
编辑 删除
Enabling and Disabling Automatic Extension for a Datafile[akadia]
You can create datafiles or alter existing datafiles so that they automatically increase in size when more space is needed in the database. The files increase in specified increments up to a specified...
-
编辑 删除
What is a JDBC KPRB driver and what is it used for ?[akadia]
What is JDBC and what is it used for?JDBC is a set of classes and interfaces written in Java to allow other Java programs to send SQL statements to a relational database management system.Oracle provi...
-
编辑 删除
How to restrict your users to only one Oracle session ? [akadia]
How can I make sure the end user has only one session in the database?This can be a requirement of an application, well, we have not found a good reason for limiting people in this way. However, peopl...
-
编辑 删除
2004.09.03--09.05 这几天献给了广州的第二代身份证系统
好累，加了几天班，不过还是把这个紧迫的政治任务圆满地完成了. 2004.07.01 : 东山区人民可以审办第二代身份证2004.09.06: 白云区人民可以审办第二代身份证...
-
编辑 删除
此等漏洞扫描程序
现在很多用户已经开始注意自己系统的安全性问题了. 一个用户在9月中旬在上班时间，用了一家公司的漏洞扫描程序进行安全检查， 结果刚一开始，oracle就hang住了,什么sql语句也做不了; 隔了几天，在晚上又做了一次；...
-
编辑 删除
使用dbca建库时：invalid size entry
windows2003 + oracle9201使用dbca图性建库时遇到：Invalid entry size( expected 42992435 but got 42992437 bytes重复多次均为同样错误.解决办法是：存成脚本，用脚本创建.
-
编辑 删除
Access Internet Web pages from SQL or PL/SQL[akadia]
Using the package UTL_HTTP, you can access any HTML page from SQLset pages 50000 select utl_http.request('http://www.akadia.com/') from dual;
-
编辑 删除
SQLNET Trace Route from Client to Server[akadia]
The Trace Route Utility (TRCROUTE) enables administrators to discover what path or route a connection is taking from a client to a server. If TRCROUTE encounters a problem, it returns an error stack t...
-
编辑 删除
dbca error: the database name must be between 1 and 8 characte
同事用dbca创建数据库的时候，运行到了输入 Global database name和sid的时候， 已经输入了，但是next的时候提示 the database name must be between 1 and 8 characters the ...
-
编辑 删除
如何冻结数据库
from metalink.GoalWhat is the behaviour of the following two SQL statements? ALTER SYSTEM SUSPEND;ALTER SYSTEM RESUME; FixWhen SUSPEND / RESUME should be used===============================These two c...
-
编辑 删除
"no timer interrupts on cpu 0"
SymptomProblem 1: ES40 is reporting CPU speed of 357MHZ when CPU's are really 500MHZ. Problem 2: Console reports "No Timers interupts on CPU 0 " 分析：The ES40 this was seen on had 4 CPU's...
-
编辑 删除
棘手的ora-03113
再续 C3) Check in your 'BACKGROUND_DUMP_DEST' for your alert log and ...
-
编辑 删除
PLS-00123: 程序太大
使用pl/sql develop编译一个很大的包报错PLS-00123: 程序太大发现用sqlplus编译就没有问题，看来是开发工具的bug了.
-
编辑 删除
2005.10.17--2005.10.19于河源
用户有一个多星期不能正常工作了,一到业务高峰期,系统就变得很慢, 群众的投诉很多:(系统上虽然跑了10几个业务,但最后查出来,还是我们的应用的问题.真是垃圾.晚上去看了亚洲第一喷泉[据说已经不是第一了].最高可以喷...
-
编辑 删除
ORA-07445 kglobal
ORA-07445: exception encountered: core dump [kglobal()+464] [SIGBUS] [unknown code] [0x0000000D8] [] []hp unix, oracle9206 rac.查了metalink,是一个bug:Subject: AMWVIOLATCHK: ORA-03113, ORA-01000, ORA-...
-
编辑 删除
贵州歌后阿幼朵---现在到处都在放她的歌曲
贵州歌后阿幼朵---现在到处都在放她的歌曲苗族歌后阿幼朵心系黔山秀水，情寄家乡父老，在即将发行的新专辑《醉苗乡》中，不仅收录了众多歌唱黔山秀水，赞美贵州人的歌曲，还从每一张唱片收益中捐出一元钱，捐给贵州...
-
编辑 删除
Counting Backwards to Reset a Sequence Value[akadia]
Consider a sequence named "MY_SEQ" which has been created to generate automatic numbers. Somebody, by mistake, has tried to access the sequence from SQL*Plus and consequently the value has been increa...
-
编辑 删除
一个性能问题的解决
现场和问题：A:p690 aix5l oracle9.2.0.5 rac rbo 上级单位 数据库不能随便改变优化模式B:p690 aix5l oracle9.2.0.5 rac rbo 数据库不能随便改变优化模式,应用程序也不能做改动C:p630 主要做测试用的 oracle8.1.7.4 ...
