ITPub博客

The UTL_FILE package lets your PL/SQL programs read and write operating system (OS) text files. It provides a restricted version of standard OS stream file input/output (I/O).Server security for PL/SQ...

os:tru64 ds20 4.0gdb: oracle8174 ops故障现象:数据库越来越慢,直到无法登陆,主机控制台键盘失效.用户重起了主机,盘柜,但两个oracle实例mount半小后报错:ora-00600[2116]系统里报错:所有的vg报无法恢复的io错误.解...

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 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 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.07.01 : 东山区人民可以审办第二代身份证2004.09.06: 白云区人民可以审办第二代身份证...

现在很多用户已经开始注意自己系统的安全性问题了. 一个用户在9月中旬在上班时间，用了一家公司的漏洞扫描程序进行安全检查， 结果刚一开始，oracle就hang住了,什么sql语句也做不了; 隔了几天，在晚上又做了一次；...

windows2003 + oracle9201使用dbca图性建库时遇到：Invalid entry size( expected 42992435 but got 42992437 bytes重复多次均为同样错误.解决办法是：存成脚本，用脚本创建.

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;

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创建数据库的时候，运行到了输入 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...

再续         C3)     Check in your 'BACKGROUND_DUMP_DEST' for your alert log and          ...

使用pl/sql develop编译一个很大的包报错PLS-00123: 程序太大发现用sqlplus编译就没有问题，看来是开发工具的bug了.

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-...

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 ...

..[@more@]set echo onset linesize 121drop table t;clear screencreate table t as select * from all_objects;create index t_idx on t(object_id);begindbms_stats.gather_table_stats( user, 'T', method_opt=> 'for columns REPEAT', cascade => TRUE );end;/pauseclear screenset autotrace traceonly explainselect * from t where object_id = 55;pauseclear screenbegindbms_stats.gather_table_stats( user, 'T', cascade => TRUE );end;/pauseclear screenselect * from t where object_id = 55;pauseset autotrace

http://asktom.oracle.com/pls/ask/f?p=4950%3A8%3A5394402804936673412%3A%3ANO%3A%3AF4950_P8_DISPLAYID%2CF4950_P8_CRITERIA%3A744625626787%2C感谢 Fenng的推荐.

原来以为很顺利的，加内存，加ＣＰＵ，升级一台805到817,数据量１４Ｇ。es40, ra８000, 跑了６年的老爷机器，意外太多，最遭的是，两台机器都起不来了其中一个很重要的数据库，由于太大，空间不够，无法做ＥＸＰ，只...