ITPub博客

Quick Install Guide for Oracle 10g Release 2 on Mac OS X Leopard & Snow Leopard (Intel)Posted by Alex Gorbachev on Apr 13, 2009I was very surprised that Oracle released Oracle...

Short Guide to install Oracle 10 on Linux Martin Zahn, 06.10.2008 Download Files ...

PurposeTo restore files from backups or image copies. By default, RMAN restores files to their default location. You can use the <co...Link URL: http://space.itpub.net/54666/viewspace-17010

Define Useful Variables Generate Output as HTML Change the font and font size Change the default editor Display the database name in the SQL*Plus command prompt Ignore blank lines in SQ...

The optimizer estimates the cost of each join method and chooses the method with the least cost. If a join returns many rows, then the optimizer considers the following three factors:1. A nested loop ...

CBO Statistics in the Data DictionaryThe statistics used by the CBO are stored in the data dictionary. You can collect exact or estimated statistics about physical storage characteristics and data dis...

DBMS_STATS.GATHER_TABLE_STATS SYNTAX要分析一下分区表。Google了一下才找到 DBMS_STATS.Garther_table_stats的Syntax,居然在 tahiti上也没有找到。不知道是我的搜索能力太弱，还是Oracle确实没有这一段。测试了一...

[收集过来，以后培训别人也可以用]第一部分 Oracle性能优化工具及使用 1．Alert Log与Trace Files Alert log Alert log文件的重要意义 Alert log的内容及其诊断 定期收集并监控alert文件的内容 ...Link ...

Just had a test on the parallel ALTER SESSION FORCE PARALLEL QUERY;会话已更改。已用时间: 00: 00: 00.00SQL> select count(*) from b$gc_netelem ; COUNT(*)---------- 8067372<...Link URL: http://space....

[Z]较好的重新启动数据库的步骤因为各种各样的原因，有时候工作数据库需要重新启动. 我列出一个较好的操作步骤，希望对初学者有些帮助.1. ...Link URL: http://space.itpub.net/54666/viewspace-17001...

整理：Fenng 日期：06-Apr-2004 　出处：http://www.dbanotes.net版本：1.01不久前,Oracle(甲骨文)公司在美国加州的总部宣布, Oracle 10g 数据库 与 Oracle RAC 在 TPC-H 基准测试中创造了新的世界纪录.这是...Link ...

我正想发邮件去问怎么证书还没发出来呢,却收到了这份邮件. NND,证书怎么还没来!!!不给我证书,我才不给你填调查呢.

Losing All Members of a Multiplexed Control File When a Backup Is AvailableUse the following procedures to restore a backup control file if a permanent ...Link URL: http://space.itpub.net/54666/viewsp...

In the old version of Oracle, when there is no automatic Undo managment, the Undo segments are manually created in normal tablespace. But most databases in 9i and 10g use automatic Undo managment now...

Draft version 0.7 of my tuning guide. Every 2nd level topic can be a very detailed article.<span style=...Link URL: http://space.itpub.net/54666/viewspace-17003

1. 监控事例的等待select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "Curr",count(*) "Tot" from v$session_Wait group by event order b...Link URL: http://space.itpub.net/5466...

http://www.pcdog.com 2005-5-26 互联网 关于AUTOTRACE的一些讨论分析SQLPLUS的AutoTrace是分析SQL的执行计划，执行效率的一个非常简单方便的工具，在绝大多数情况下，也是非常有用的工具。 这里，我们...Link URL: ...

关于Oracle的性能调整，一般包括两个方面，一是指Oracle数据库本身的调整，比如SGA、PGA的优化设置，二是连接Oracle的应用程序以及SQL语句的优化。做好这两个方面的优化，就可以使一套完整的Oracle应用系统处于良好...

Chapter <span lang="E...Link URL: http://space.itpub.net/54666/viewspace-16986

Oracle 10g Book Center The Oracle 10g book program is the biggest ever for Oracle, comprising 50 books from 37 different authors. The following books from that list are now avai...Link URL: http://spa...