ITPub博客

From:http://blog.chinaunix.net/u2/60332/showart_1838056.htmloracle parallel execution example引子：以前一直没太关注oracle并行这个特性。前几天一个兄弟碰到的一个问题，才让我觉得这个东西...

gb2312转到utf8spool出来并用iconv转到utf8#!/bin/bashfor i in `cat table.txt`do/opt/oracle10g/u01/bin/sqlplus -s  guomei/xyzmn << EOF set newpage 0set linesize 10000       &nbsp...

From:http://www.oracle.com/technology/pub/articles/advanced-linux-commands/part4.html

From:NingooOracle10.2.0.4中，如果数据库压力较大，IO发生短暂停止响应的时候，可能导致数据库实例崩溃。在alert中可以找到如下错误：Thu Apr 2 10:55:36 2009Errors in file /bdump/test.trc:ORA-00494: enqueu...

解决过程：1、查看当前会话数、processes和sessions值，发现session数和2个参数的值已经非常逼近SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 10月 9 15:50:...

From:http://blog.itpub.net/battlemanASM process设置Processes = 25 + (10 + [max number of concurrent database file creations, and file extend operations possible])*nn is the number of RDBMS instance (A...

From:http://www.geekinterview.com/question_details/62921A block fracture occurs when a block is being read by the backup and bieng written to at the same time by the DBWR. This happens because...

From:http://www.oracle-base.com/articles/misc/dml_returning_into_clause.phpDML RETURNING INTO ClauseThe RETURNING INTO clause allows us to return column values for rows affected ...

http://www.oracle.com/technology/deploy/availability/index.html

From:http://www.oracle.com/technology/pub/articles/dulaney_awk.htmlLinux SysadminAWK: The Linux Administrators' Wisdom KitBy Emmett DulaneyLearning Linux? This introduction to the ...

From:http://www.oracle-base.com/articles/misc/BasicEnterpriseManagerTroubleshooting.phpBasic Enterprise Manager TroubleshootingThe web-based Enterprise Manager tool was introduced in Oracle 10...

From:http://www.oracle-base.com/articles/10g/ASMUsingASMLibAndRawDevices.phpASM using ASMLib and Raw DevicesIntroductionPartition the DisksASMLib InstallationRaw Device SetupASM CreationDataba...

From:http://www.puschitz.com/TuningLinuxForOracle.shtml#UsingBlockDevicesForOracle10gRelease2InRHEL4This article is a step by step guide for tuning and optimizing Red Hat Enterprise Linux on x...

ASM Disk Crash - CASE STUDY Posted On Sunday, April 12, 2009 at at 5:00 AM by Anup Kumar Srivastav   Case: (All Disks in a failgroup are lost after a disk/LUN failure)RedundancyNORMAL...

select * from v$version perl  $ORACLE_HOME /OPatch/opatch.pl  versionlsnrctl version

set pagesize 0 set long 90000 set feedback off set echo off--table 's ddlSELECT DBMS_METADATA.GET_DDL('TABLE', U.TABLE_NAME) FROM ...

From:http://space.itpub.net/471666/viewspace-406996ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]参考 Metalink   Note:398622.1Subject:ORA-1...

From:http://space.itpub.net/471666/viewspace-543090Oracle 10g Release 2 CSS parametersOracle Database 10g Release 2 CSS (Cluster Synchronization Service) parameters:With different patch-s...

From:http://space.itpub.net/283894/viewspace-366146

http://www.pythian.com/news/1035/oracle-silent-mode-part-110-installation-of-102-and-111-databases