<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuichen9967</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuichen9967]]></copyright><item><title><![CDATA[在 RHEL3 上配置 Oracle 10g Data Guard]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395247</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395247</guid><author>cuichen9967</author><pubDate>Wed, 20 Jun 2007 13:48:57 +0800</pubDate><description><![CDATA[在 RHEL3 上配置 Oracle 10g Data Guard =========================================================== 作者: wxy0327(http://w...]]></description><category></category></item><item><title><![CDATA[分区表的建立，访问]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395246</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395246</guid><author>cuichen9967</author><pubDate>Tue, 12 Jun 2007 10:37:49 +0800</pubDate><description><![CDATA[范围分区表：CREATE TABLE sales (invoice_no NUMBER, ... sale_date DATE NOT NULL ) PARTITION BY RANGE (sale_date) (PARTITI...]]></description><category></category></item><item><title><![CDATA[oracle 内存的配置]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395244</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395244</guid><author>cuichen9967</author><pubDate>Sat, 09 Jun 2007 11:22:16 +0800</pubDate><description><![CDATA[服务器有1G内存,该配置SGA=500--600m 50%shared_pool_size=100m 20% db_cache_size=400 80%data_buffers 在9i 是 db_cache_size;作者：co...]]></description><category></category></item><item><title><![CDATA[表空间建立的一些原则]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100509775</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100509775</guid><author>cuichen9967</author><pubDate>Thu, 07 Jun 2007 15:28:49 +0800</pubDate><description><![CDATA[静态表一个表空间生产表在个表空间历史表一个表空间分区的单独建立表空间名称与其文件名称要求对应 表空间下的文件最大为４g[@more@]
                                              ...]]></description><category></category></item><item><title><![CDATA[Oracle 体系结构介绍]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395242</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395242</guid><author>cuichen9967</author><pubDate>Thu, 07 Jun 2007 09:36:15 +0800</pubDate><description><![CDATA[在本章里你可以了解以下内容 1、 ORACLE 实例——包括内存结构与后台进程 2、 ORACLE 数据库——物理操作系统文件的集合 3、 了解内存结构的组成 4、 了解后台进程的作用 5、 了解数据库的物理文件 6、 解释各种...]]></description><category></category></item><item><title><![CDATA[oracle 段,区间，块之间的关系]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395245</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395245</guid><author>cuichen9967</author><pubDate>Thu, 07 Jun 2007 09:25:42 +0800</pubDate><description><![CDATA[Oracle.段、区间和数据块数据库的段是由若干个区间组成的，区间中是一些连续的数据块。这三者是构成其他数据对象的基本单位数据库段:                   包括数据段、索引段、LOB段、溢出段、回滚段和临时段 区间...]]></description><category></category></item><item><title><![CDATA[经典的sql 语句]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395241</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395241</guid><author>cuichen9967</author><pubDate>Wed, 09 May 2007 14:34:57 +0800</pubDate><description><![CDATA[oracle常用经典SQL查询 常用SQL查询：1、查看表空间的名称及大小select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_sizefrom dba_tab...]]></description><category></category></item><item><title><![CDATA[模式对象]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395238</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395238</guid><author>cuichen9967</author><pubDate>Fri, 27 Apr 2007 14:22:59 +0800</pubDate><description><![CDATA[第三部分、模式对象*****************************************************************************************************一、管理...]]></description><category></category></item><item><title><![CDATA[exp/imp 详细介绍]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395239</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395239</guid><author>cuichen9967</author><pubDate>Fri, 27 Apr 2007 10:13:13 +0800</pubDate><description><![CDATA[命令详解： 　　　　　E:&gt;exp help=y　　　　通过输入 EXP 命令和用户名/口令，您可以　　在用户 / 口令之后的命令:　　　　实例: EXP SCOTT/TIGER　　　　或者，您也可以通过输入跟有各种参数的...]]></description><category></category></item><item><title><![CDATA[分析日志工具的步骤]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395236</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395236</guid><author>cuichen9967</author><pubDate>Thu, 26 Apr 2007 15:24:40 +0800</pubDate><description><![CDATA[一：要安装LogMiner工具，必须首先要以SYS用户身份运行下面两个脚本文件：（l）$Oracle_HOME/rdbms/admin/dbmslsm.sql用来创建DBMS_LOGMNR包，该包用来分析日志文件。（2）$Ora...]]></description><category></category></item><item><title><![CDATA[将查询的结果生成文本文件]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395235</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395235</guid><author>cuichen9967</author><pubDate>Thu, 26 Apr 2007 11:09:01 +0800</pubDate><description><![CDATA[spool   c:a.txt     select   *   from   tbname;     spool   off;[@more@]
                                         ...]]></description><category></category></item><item><title><![CDATA[Oracle专家调优秘密]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395240</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395240</guid><author>cuichen9967</author><pubDate>Thu, 19 Apr 2007 10:18:01 +0800</pubDate><description><![CDATA[前言 　　 　　在过去的十年中， Oracle 已经成为世界上最专业的数据库之一。对于 IT 专家来说，就是要确保利用 Oracle 的强大特性来提高他们公司的生产力。最有效的方法之一是通过 Oracle 调优。它有大量的调整参...]]></description><category></category></item><item><title><![CDATA[Oracle诊断案例-Sql_trace之一]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395237</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395237</guid><author>cuichen9967</author><pubDate>Thu, 05 Apr 2007 16:24:01 +0800</pubDate><description><![CDATA[问题描述:这是帮助一个公司的诊断案例.应用是一个后台新闻发布系统.症状是,通过连接访问新闻页是极其缓慢通常需要十数秒才能返回.这种性能是用户不能忍受的.操作系统:SunOS 5.8数据库版本:8.1.71.检查并跟踪数据库进程 ...]]></description><category></category></item><item><title><![CDATA[修改字符集]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395233</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395233</guid><author>cuichen9967</author><pubDate>Thu, 29 Mar 2007 16:55:03 +0800</pubDate><description><![CDATA[1。察看字符集sql&gt;set wrap offsql&gt;select * from v$nls_parameters;[Q]怎么样查看数据库字符集 [A]数据库服务器字符集select * from nls_datab...]]></description><category></category></item><item><title><![CDATA[oracle维护常用sql语句]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395232</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395232</guid><author>cuichen9967</author><pubDate>Wed, 21 Mar 2007 10:00:00 +0800</pubDate><description><![CDATA[oracle维护常用sql语句1、查看表空间的名称及大小　　select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size　　from dba_tablespa...]]></description><category></category></item><item><title><![CDATA[logminer 的安装与用法]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395234</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395234</guid><author>cuichen9967</author><pubDate>Tue, 20 Mar 2007 16:42:09 +0800</pubDate><description><![CDATA[SQL&gt; conn sys/sys as sysdba已连接。SQL&gt; @C:oracleora92rdbmsadmindbmslmd.sql过程已创建。没有错误。授权成功。PL/SQL 过程已成功完成。程序包已创建...]]></description><category></category></item><item><title><![CDATA[oracle里常用命令]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395228</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395228</guid><author>cuichen9967</author><pubDate>Tue, 20 Mar 2007 14:38:35 +0800</pubDate><description><![CDATA[最近在弄ORACLE 数据库，急需资料，从网上整了一些资料。供同志们参考oracle里常用命令第一章：日志管理 1.forcing log switches sql&gt; alter system switch logfile...]]></description><category></category></item><item><title><![CDATA[spfile.ora 文件破坏的处理 出现ORA-00600: internal error code, arguments: [733], [337650736],...]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395230</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395230</guid><author>cuichen9967</author><pubDate>Wed, 21 Feb 2007 11:51:58 +0800</pubDate><description><![CDATA[1.将破坏的文件用写字板打开,将里面有用的内容复制成另外一个文件比如:inittest.ora2.以inittest.ora 启动startup pfile=e:oracleora92databaseinittest.ora 3...]]></description><category></category></item><item><title><![CDATA[rman 测试]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395226</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395226</guid><author>cuichen9967</author><pubDate>Thu, 15 Feb 2007 10:19:54 +0800</pubDate><description><![CDATA[rman作为oracle备份最为方便的工具，以下就总结几条常用的命令，希望能方便大家,也希望可以申请授权： 1、首先使用rman前，需要建一个目录数据库2、create tablespce rman datafile '/dat...]]></description><category></category></item><item><title><![CDATA[管理员需要定期的备份控制文件]]></title><link>https://blog.youkuaiyun.com/cuichen9967/article/details/100395231</link><guid>https://blog.youkuaiyun.com/cuichen9967/article/details/100395231</guid><author>cuichen9967</author><pubDate>Wed, 14 Feb 2007 10:54:43 +0800</pubDate><description><![CDATA[alter databasebackup controlfile to '/home/backup/control.bak';或者alter databasebackup controlfile to trace;这样，会在US...]]></description><category></category></item></channel></rss>