<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[masya的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/masyamasya</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; masyamasya]]></copyright><item><title><![CDATA[浅谈Oracle数据库SCN号]]></title><link>https://blog.youkuaiyun.com/masyamasya/article/details/5259809</link><guid>https://blog.youkuaiyun.com/masyamasya/article/details/5259809</guid><author>masyamasya</author><pubDate>Tue, 26 Jan 2010 23:44:00 +0800</pubDate><description><![CDATA[Oracle数据库SCN号详解: 　　系统检查点scn(v$database(checkpoint_change#))　　数据文件检查点(v$datafile(checkpoint_change#))　　数据文件终止scn(v$datafile(last_change#))　　数据文件中存放的检查点　　启动scn (v$datafile_header(checkpoint_ch]]></description><category></category></item><item><title><![CDATA[数据块dump ]]></title><link>https://blog.youkuaiyun.com/masyamasya/article/details/5251820</link><guid>https://blog.youkuaiyun.com/masyamasya/article/details/5251820</guid><author>masyamasya</author><pubDate>Sun, 24 Jan 2010 21:56:00 +0800</pubDate><description><![CDATA[首先在确定要dump的block在哪个数据文件上，是block_id是多少。可以通过dba_extents视图或rowid等信息得到。Restricted Rowid   ----------------------------------------  | BBBBBBBB . RRRR . FFFF |  ------------------------]]></description><category></category></item><item><title><![CDATA[本文详细介绍从Undo, Redo, DataFile看Oracle中的事务过程 ]]></title><link>https://blog.youkuaiyun.com/masyamasya/article/details/5251680</link><guid>https://blog.youkuaiyun.com/masyamasya/article/details/5251680</guid><author>masyamasya</author><pubDate>Sun, 24 Jan 2010 21:08:00 +0800</pubDate><description><![CDATA[这篇文章中，我们将通过Undo, Redo, DataFile的dump来看看Oracle中一个transaction过程。　　1：提交当前session中的pending transaction,SQL> show autocommit;autocommit OFFSQL> commit;Commit complete.　　2：确定transaction前的scn，SQL> co]]></description><category></category></item><item><title><![CDATA[oracle中dump函数 ]]></title><link>https://blog.youkuaiyun.com/masyamasya/article/details/5251584</link><guid>https://blog.youkuaiyun.com/masyamasya/article/details/5251584</guid><author>masyamasya</author><pubDate>Sun, 24 Jan 2010 20:25:00 +0800</pubDate><description><![CDATA[问题：1. oracle中number，char/varchar，date等数据类型是怎么存储的？字节流是什么样的？2. 各种数据类型占用的字节长度是多大？SELECT dump(1), DUMP(123456), DUMP(-123456), DUMP(1234567890123456) -- 整数--SELECT DUMP(123456.789), DUMP(-123456.789), d]]></description><category></category></item><item><title><![CDATA[Dump File]]></title><link>https://blog.youkuaiyun.com/masyamasya/article/details/5251581</link><guid>https://blog.youkuaiyun.com/masyamasya/article/details/5251581</guid><author>masyamasya</author><pubDate>Sun, 24 Jan 2010 20:24:00 +0800</pubDate><description><![CDATA[Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0Connected as nod32 SQL> Drop Table A ; Table dropped SQL> Create Table A (A Number(8)) ; Table created SQL> Create Index Idx_A On ]]></description><category></category></item><item><title><![CDATA[ASCII码对照表]]></title><link>https://blog.youkuaiyun.com/masyamasya/article/details/5251498</link><guid>https://blog.youkuaiyun.com/masyamasya/article/details/5251498</guid><author>masyamasya</author><pubDate>Sun, 24 Jan 2010 19:44:00 +0800</pubDate><description><![CDATA[ASCII码对照表下表列出了字符集中的 0 - 127。 代码字符代码字符代码字符代码字符0  32[空格]64@96`1 33!65A97a2 34"66B98b3 35#67C99c4 36$]]></description><category></category></item><item><title><![CDATA[Cache Layer Block Types]]></title><link>https://blog.youkuaiyun.com/masyamasya/article/details/5251481</link><guid>https://blog.youkuaiyun.com/masyamasya/article/details/5251481</guid><author>masyamasya</author><pubDate>Sun, 24 Jan 2010 19:38:00 +0800</pubDate><description><![CDATA[Oracle Internals NotesCache Layer Block TypesThis is a list of the block type numbers found in cache layer block headers. CodeBlock TypeVersions1Undo header block (limited exte]]></description><category></category></item><item><title><![CDATA[block格式]]></title><link>https://blog.youkuaiyun.com/masyamasya/article/details/5251477</link><guid>https://blog.youkuaiyun.com/masyamasya/article/details/5251477</guid><author>masyamasya</author><pubDate>Sun, 24 Jan 2010 19:35:00 +0800</pubDate><description><![CDATA[oracle 8.1.7         8k block          windows XP    create table t(n number);insert into t values(1);   --- 从 dbms_rowid 中看出table t 的数据在datafile 4 的第3个 block 上alter system dump datafile 4 block 3;下面是]]></description><category></category></item></channel></rss>