ITPub博客

Linux下安装oracle的简要步骤笔记 http://blog.chinaunix.net/u2/84422/showart_2315133.html今天手工创建10G数据库失败，报ORA-12701错误http://empo007.itpub.net/post/12076/496062[@more@]

10g中的transaction等待事件http://empo007.itpub.net/post/12076/496412[@more@]

Oracle10gR2 中 Oracle Wallet 的初步使用和维护http://blog.sina.com.cn/s/blog_4d8a2c970100fjks.htmlwallet useful in : 1, client auto login databae. 2, database data encryption.-- detail settings1, in client side , set following parameters in sqlnet.ora file .WALLET_LOCATION =(SOURCE =(METHOD = FILE)(METHOD_DATA =(DIRECTORY = C:temp)))# THE FOLLOWING PARAMETER IS NEEDED FOR AUTO LOGIN. IF SET TO FALSE, THEN DO NOT ALLOW AUTO LOGIN FEATURE.SQLNET.WALLET_OVERRIDE = TRUE -- command to create credentia

Oracle Database 10g Administration Workshop II Volume II Student Guide V3http://wenku.baidu.com/view/d9ea98630b1c59eef8c7b4cd.html[@more@]

Oracle常见SQL分页实现方案介绍http://blog.sina.com.cn/s/blog_4d8a2c970100fjv5.html[@more@]

************error stack ****************C:Documents and SettingsAdministrator>oradim -startup -sid emrDIM-04503: Message 4503 not found; product=RDBMS; facility=ORADIM*******************************this error is similar to sqlplus which refer to mssage file. resolution: 1, set ORACLE_HOME to the correct directory .2, set the environment PATH variable to the correct %oracle_home%bin value. [@more@]

*********error message stack ************C:Documents and SettingsAdministrator>sqlplus / as sysdbaError 14 initializing SQL*PlusMessage file sp1<lang>.msb not foundSP2-0750: You may need to set ORACLE_HOME to your Oracle software directory******************************resolution: 1, set ORACLE_HOME to the correct directory .2, set the environment PATH variable to the correct %oracle_home%bin value. [@more@]

Oracle Stream 深入探讨http://wenku.baidu.com/view/d8cfb864783e0912a2162ae3.html[@more@]

http://www.friendeye.com/?action-viewthread-tid-90385http://www.nb591.com/thread-69032-2-1.htmlhttp://www.51nb.com/forum/thread-1018355-1-1.html[@more@]

10g用户故障快速恢复方法研究http://www.docin.com/p-22877284.htmloracle10g Flashback Databasehttp://singlelove1983.blog.163.com/blog/static/50849047200801794342791/使用Oracle10g Flashback database功能恢复用户错误http://www.eygle.com/archives/2005/03/eoaoracle10g_fl.html[@more@]

http://comtv.blog.51cto.com/17037/222889[@more@]

direct path read/write等待的分析http://iamwang.blog.sohu.com/93404343.html[@more@]

临时表空间消除的方法http://weiranjie.itpub.net/post/26925/479789[@more@]

处理数据库慢的一般方法 以下在XZH2000 博客摘取如果不用分析工具如statspack等，如何快速找出原因？lcm_0090828给出自己常用的checklist:1. 检查表空间资源2. 归档是否正常（归档空间满时，会等待归档，之后用户进程就死掉了）3. 检查alert 信息4. 用vmstat, top命令看看系统i/o, cpu的繁忙程度，以及哪个进程在消耗资源，结合v$process, v$session, v$sqlarea 等视图查找出终端机器，以及其使用的sql 语句等。5. 有没有死锁6. 有时用户进程运行的程序会报错，就根据错误提示寻找根源及解决办法，可能是初始化参数设置不合理[@more@]

Oracle Data block 的物理结构-体系架构http://www.bitscn.com/pdb/oracle/200904/160425.htmlOracle数据块原理深入剖析-入门基础http://www.bitscn.com/pdb/oracle/200904/160356.html[@more@]

技术白皮书：Oracle Data Guard 11g 第1 版 - Oracle DataGuardhttp://www.docin.com/p-66563751.html#Oracle Data Guard 理论知识 http://comtv.blog.51cto.com/17037/435219数据库Standby中的几个概念 - LGWR, ARCH,ASYNC,SYNC,AFFIRMhttp://rocolex.blog.163.com/blog/static/684464102009111111514655/LGWR SYNC AFFIRM也不能保证日志一定写到备机http://space.itpub.net/8242091/viewspace-668027三思笔记]一步一步学DataGuardhttp://wenku.baidu.com/view/4e2db7d528ea81c758f578ac.html[@more@]

Apress.Forecasting.Oracle.Performancehttp://www.docin.com/p-23728137.html[@more@]

Oracle 11gR1中的SecureFile(1)http://database.51cto.com/art/200805/72620.htm[@more@]

Oracle 11g透明数据加密安全特性解析(1)http://school.cnd8.com/oracle/jiaocheng/47585.htmhttp://www.51cto.com/art/200805/73089.htm经验之谈：使用Oracle的TDE特性加密http://www.soft6.com/news/13/133827.html[@more@]

给Oracle BIGFILE表空间增加磁盘(通用的LINUX增加磁盘空间方案)文章分类:操作系统bigfile tablespace由于数据库采用了bigfile表空间，结果磁盘空间200GB用光了。 BIGFILE机制是没有办法加数据文件的，只有一个数据文件。 alter tablespace xxx add datafile '/ora_data/xxx_01.dbf' size 3000m autoextend on next 100M maxsize 10000M; 报： ORA-32771: cannot add file to bigfile tablespace; 解决涉及到的实际操作如下: 0.关闭数据库 1.创建物理卷 pvcreate /dev/sdk 2.加入卷组 vgextend data8vg /dev/sdk 3.把新空间加到逻辑卷中 l