ITPub博客

..[@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, 跑了６年的老爷机器，意外太多，最遭的是，两台机器都起不来了其中一个很重要的数据库，由于太大，空间不够，无法做ＥＸＰ，只...

4个310,10个31,中14包13.333333333333113333333333133133333333331113333333333131113333333313311133333333113333333333331111333333333133313333333331331131333333313133313333333131131333333331133311333333311...

一个数据库非正常关机，再次启动数据库时报错：ORA-12709:Error while loading create database character set 首先排除了环境变量的问题，最终发现是以下目录文件损坏：$ORACLE_HOME/ocommon/nls/admin/data从备份...

errpt命令报错：0315-180 logread: UNEXPECTED EOF0315-171 Unable to process the error log file /var/adm/ras/errlog.0315-132 The supplied error log is not valid: /var/adm/ras/errlog.解决办法：1. /usr/lib...

http://www.chinaitpower.com/A/2004-07-04/85503.html--------------------仅转一段----------------------------1 前言　 　　众所周知，MD5是目前应用最多的密码保护方法，该编码传说为不可逆加密编码＜也就是说...

关键字: 物化视图, migration,materialized views,快照,prebuilt table对于要求停机时间很短的迁移,可以一试.a) create empty tables in new database....b) put constraints etc on them (deferrable please, impor...

安装oracle,运行rootpre.sh时报以下错误：Configuring Asynchronous I/O... Asynchronous I/O is already defined /var/ha/soc/hagsdsocket./cdrom/rootpre.sh[338]: /usr/lpp/ssp/bin/spget_syspar: not found: No ...

This tip comes from Anirban Das, a Senior IA from Vernon Hills, IL. We have improved the SQL statement in some points, so WHERE clauses will be correctly executed.In SQL*Plus, it is often difficult to read the results of a SELECT *FROM 'table' statement since the output could wrap across multiple lines. For example, the normal output of SELECT * FROM 'dba_users' would be :USERNAME USER_ID PASSWORD------------------------------ ---------- ---------ACCOUNT_STATUS

·  企业版——行业领先的可伸缩性和可靠性（集群的、单一系统）、事务处理、决策支持及内容管理。  ·  标准版——为不需要企业版选项的中小企业或部门提供了低成本的选择。 &n...

来自网友1应用开发　　　　　1.1　应用程序接口和预编译器　　　　1.1.1　　提供ODBC FOR LINUX版本　　　1.1.2　　OCI客户端版本　　　1.1.3　　OCI启动关闭数据库直接在调用OCI的应用程序中就可以关闭和开启数据库...

p570 oracle9204 rboSQL> set autotrace traceonly;select a.czrkrybh,a.czrkxm,b.czrkpcs from t_person a ,t_huji bwhere a.czrkryid=b.czrkryid and a.czrkgmsfhm='510214197501131748';Execution Plan---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=48337 Card=274445 By tes=20583375) 1 0 HASH JOIN (Cost=48337 Card=274445 Bytes=20583375) 2 1 TABLE ACCESS (BY INDEX ROWID) OF 'T_PERSON' (Cost=2 Card =272416 Bytes=1

在做几个数据库的statspack时，某个数据库总是报错： ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violatedORA-06512: at "PERFSTAT.STATSPACK", line 1361ORA-06512: at "PERFSTAT.STATSPACK", ...

One option for secure communication between the Net8 client and server is to tunnel the communication inside the Secure Shell protocol. Conceptually, it works like this. First, you install an SSH clie...

ora-29723:DML PROCESS STRUCTURE EXCEEDS PERMITTED VALUES解决方法: 加大ops参数， lm_procs .[127 --->  200]

During a migration it may be important, that nobody can connect to the database. You may have two possibilities to achieve thisOn Table Level using LOCK TABLEOn Database Level using RESTRICTED SESSION...

http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpuoct2006.html http://www.oracle.com/technology/global/cn/deploy/security/alerts.htm

在广东，国际主流厂家设备和技术的引进，国内厂商设备的广泛使用，非开挖产业已在城市基.础设施的建设取得了令人印象深刻的成果，产业本身也获得了快速的发展，各级公司由2002年的. 50 家扩展到2004 年140 家，这期...

http://www.tvix.cn/play.php?v=YNgQCEz8rtX