<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[士不可不弘毅]]></title><description><![CDATA[半个世界和三百年的优势，任重而道远]]></description><link>https://blog.youkuaiyun.com/whyce</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; whyce]]></copyright><item><title><![CDATA[Oracle I/O优化小技巧]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4964153</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4964153</guid><author>whyce</author><pubDate>Tue, 08 Dec 2009 14:24:00 +0800</pubDate><description><![CDATA[重做日志文件与归档日志文件放到不同硬盘.数据文件与重做日志文件放到不同硬盘.不同的重做日志文件、控制文件、归档日志文件最好放到不同硬盘控制文件、重做日志文件放到高速硬盘。不行就放到同一硬盘高速区，即柱面号低的硬盘外部半圈。归档日志可以放在低速硬盘或分区单纯增加硬盘大小不太管用。最好增加硬盘物理数量和控制器数量。SYSTEM表空间只存放系统表和数据.还原表空间]]></description><category></category></item><item><title><![CDATA[Oracle系统常用字符界面命令]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4963014</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4963014</guid><author>whyce</author><pubDate>Tue, 08 Dec 2009 12:01:00 +0800</pubDate><description><![CDATA[命令都位于$ORACLE_HOME/BIN/目录下emctl status dbconsole查询企业管理器控制程序状态.可能需要定义ORACLE_SID系统变量SET ORACLE_SID=orcl2;   REM 或你的SIDemctl start dbconsole启动企业管理器控制程序lsnrctl start 启动TNS监听.还可用参数stop, stat]]></description><category></category></item><item><title><![CDATA[Oracle简易优化技巧]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4962987</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4962987</guid><author>whyce</author><pubDate>Tue, 08 Dec 2009 11:58:00 +0800</pubDate><description><![CDATA[在数据仓库上使用位图索引在联机事务处理系统上面设定CURSOR_SHARING = SIMILAR, 数据仓库上面为EXACT.如:ALTER SYSTEM SET CURSOR_SHARING = SIMILAR;联机系统倾向于小的数据块(DB_BLOCK_SIZE),推荐8K. 数据仓库倾向于大的数据块加大一次同时输入输出的数据块数量.ALTER SYSTEM SE]]></description><category></category></item><item><title><![CDATA[Oracle常用闪回操作]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4935837</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4935837</guid><author>whyce</author><pubDate>Thu, 03 Dec 2009 22:23:00 +0800</pubDate><description><![CDATA[   确认闪回启用中     SHOW PARAMETER RECYCLEBIN;    启用闪回     ALTER SYSTEM SET RECYCLEBIN = ON;    闪回DROP的表     FLASHBACK TABLE xxx TO BEFORE DROP;    彻底清除DROP的表,将不能再闪回.     PURGE TABLE xxx;    直接彻底DROP掉表    ]]></description><category></category></item><item><title><![CDATA[Oracle简单数据移动]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4935651</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4935651</guid><author>whyce</author><pubDate>Thu, 03 Dec 2009 21:54:00 +0800</pubDate><description><![CDATA[   导出. 想要导出其他用户的对象需要有EXP_FULL_DATABASE角色     exp 用户名/密码 file=路径 tables=(表名1,表名2,...)    导入. 想要导入其他用户的对象需要有IMP_FULL_DATABASE角色     imp 用户名/密码 file=路径    数据泵导出     a.) 只能导出到Oracle管控目录. 可以使用默认的DATA_PUMP_]]></description><category></category></item><item><title><![CDATA[Oracle创建外部管理表]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4935501</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4935501</guid><author>whyce</author><pubDate>Thu, 03 Dec 2009 21:26:00 +0800</pubDate><description><![CDATA[   以system或其他管理员登录    创建Oracle管控目录     CREATE DIRECTORY hc_name_data_dir AS c:/ora/external/hc_name/;      CREATE DIRECTORY hc_name_log_dir AS c:/ora/external/hc_name/;    确认     SELECT * FROM dba]]></description><category></category></item><item><title><![CDATA[Oracle常用备份与恢复操作]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4933218</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4933218</guid><author>whyce</author><pubDate>Thu, 03 Dec 2009 15:31:00 +0800</pubDate><description><![CDATA[   查看归档模式状态     ARCHIVE LOG LIST    冷备份.     a.) 查询v$controlfile获取控制文件信息      b.) 查询v$logfile获取重做日志信息      c.) 查询dba_data_files, v$datafile, v$tablespace获取数据文件与表空间对应关系,和文件信息.      d.) 使用show parameter]]></description><category></category></item><item><title><![CDATA[Oracle用户、角色、权限和系统资源管理常用操作]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4915288</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4915288</guid><author>whyce</author><pubDate>Tue, 01 Dec 2009 16:09:00 +0800</pubDate><description><![CDATA[   查询用户信息      SELECT USERNAME,DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE, PROFILE, ACCOUNT_STATUS, CREATED FROM dba_users;     查询用户空间使用和上限情况      SELECT username, tablespace_name, bytes/1024/1024 space]]></description><category></category></item><item><title><![CDATA[Oracle数据完整性约束常用操作]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4872701</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4872701</guid><author>whyce</author><pubDate>Wed, 25 Nov 2009 17:55:00 +0800</pubDate><description><![CDATA[   信息查询     SELECT * FROM dba_cons_columns;      和      SELECT constraint_name, table_name, constraint_type, status, deferrable, deferred, validated FROM dba_constraints;    变更约束执行时间(是否延缓执行,只对可延缓约束有效)]]></description><category></category></item><item><title><![CDATA[Oracle索引管理常用操作]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4858854</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4858854</guid><author>whyce</author><pubDate>Mon, 23 Nov 2009 20:23:00 +0800</pubDate><description><![CDATA[   通过调整CREATE_BITMAP_AREA_SIZE来定义位图缓存内存区大小.当这个缓存足够大时,可以有效的加快位图索引的操作速度,因为操作是在内存中进行.    普通索引更适用OLTP类型的操作,即数据变化频繁.BITMAP更适合DSS类型的操作,即查询多,量大.但是所有的索引在执行DML类型操作时,消耗都比较大.  要慎用索引.    尽量使用统一的EXTENT尺寸,数据块大小的5倍或]]></description><category></category></item><item><title><![CDATA[无题]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4858586</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4858586</guid><author>whyce</author><pubDate>Mon, 23 Nov 2009 19:38:00 +0800</pubDate><description><![CDATA[专心用心才能安心,心安神定必能看清.]]></description><category></category></item><item><title><![CDATA[无题]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4858583</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4858583</guid><author>whyce</author><pubDate>Mon, 23 Nov 2009 19:37:00 +0800</pubDate><description><![CDATA[过去心是迷乱心,未来心是妄想心.把握当下,恒持刹那.]]></description><category></category></item><item><title><![CDATA[无题]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4858575</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4858575</guid><author>whyce</author><pubDate>Mon, 23 Nov 2009 19:35:00 +0800</pubDate><description><![CDATA[如世人欺我、辱我、笑我、轻我、贱我，如何处之?   一切有为法，如梦幻泡影，如露亦如电，应作如是观。只要忍他、让他、避他、由他、耐他、不要理他，再过几年，你且看他！]]></description><category></category></item><item><title><![CDATA[Oracle常用表管理操作]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4858570</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4858570</guid><author>whyce</author><pubDate>Mon, 23 Nov 2009 19:34:00 +0800</pubDate><description><![CDATA[   创建表. 基本与标准SQL相同,不过要加上指定表空间的子语句如: TABLESPACE abc    查询表信息     SELECT table_name, owner, tablespace_name, temporary FROM dba_tables;      和      SELECT segment_name, owner, tablespace_name, extents, ]]></description><category></category></item><item><title><![CDATA[Oracle还原数据段常用管理操作]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4857758</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4857758</guid><author>whyce</author><pubDate>Mon, 23 Nov 2009 17:09:00 +0800</pubDate><description><![CDATA[   参数     UNDO_MANAGEMENT = AUTO      --管理模式,可为AUTO或MANUAL.只能在启始参数文件里面修改      UNDO_TABLESPACE = undo             --制定存储还原数据的表空间,亦可用ALTER SYSTEM SET undo_tablespace = abc来更改      UNDO_RETENTION = 180]]></description><category></category></item><item><title><![CDATA[Oracle表空间和数据文件的常用操作]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4836051</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4836051</guid><author>whyce</author><pubDate>Thu, 19 Nov 2009 16:24:00 +0800</pubDate><description><![CDATA[        表空间资料查询        SELECT tablespace_name, block_size, extent_management, segment_space_management FROM dba_tablespaces;         配和         SELECT tablespace_name, initial_extent, next_extent, max]]></description><category></category></item><item><title><![CDATA[Oracle重做日志文件常用操作]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4833363</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4833363</guid><author>whyce</author><pubDate>Thu, 19 Nov 2009 10:25:00 +0800</pubDate><description><![CDATA[   强制切换重做日志     ALTER SYSTEM SWITCH LOGFILE;    强制产生检查点     ALTER SYSTEM CHECKPOINT;    间接产生检查点(设定实例恢复时间不超过mm秒,亦即执行检查点之后运行超过这个时间就再次执行检查点)     ALTER SYSTEM SET FAST_START_MTTR_TARGET = 秒数;    获取重做日志文件信]]></description><category></category></item><item><title><![CDATA[Oracle控制文件常用操作]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4833004</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4833004</guid><author>whyce</author><pubDate>Thu, 19 Nov 2009 09:41:00 +0800</pubDate><description><![CDATA[   限制控制文件的大小      a.)查询可复用部分的保存天数(不能直接控制大小,保存天数越大数据越多)       SELECT name,value FROM v$parameter WHERE name = control_file_record_keep_time;             b.)设置可复用部分保存时间       ALTER SYSTEM SET CONTROL_]]></description><category></category></item><item><title><![CDATA[Oracle系统管理和系统资料获取的一些基本命令]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4822082</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4822082</guid><author>whyce</author><pubDate>Tue, 17 Nov 2009 15:13:00 +0800</pubDate><description><![CDATA[资料获取自学习何明著作>第二版之时.其中dba_开头的表需要有sysdba权限才能访问.1. 获取数据库名字,创建日期,当前模式,日志模式等等:     SELECT name,created,log_mode,open_mode FROM v$database;2. 获取运行实例的主机名,实例名,版本:     SELECT host_name,instance_name,v]]></description><category></category></item><item><title><![CDATA[PHP连接Oracle并分页访问(OCI版)]]></title><link>https://blog.youkuaiyun.com/whyce/article/details/4819942</link><guid>https://blog.youkuaiyun.com/whyce/article/details/4819942</guid><author>whyce</author><pubDate>Tue, 17 Nov 2009 10:07:00 +0800</pubDate><description><![CDATA[虽然本人没有验证过,不过据说通过ADODB访问Oracle对性能影响很小.而且ADODB比OCI8也要方便很多,毕竟许多东西都再次封装过.不过不管怎么说这都在中间又加上了一层,理论上来说出现问题的几率和解决问题的难度都变大了.而Oracle又经常用在不能随便出问题的环境,所以想必想要直接使用OCI的情况也不少.以下就是我的例子:<?php$conn = oci_connect("usern]]></description><category></category></item></channel></rss>