Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

316

积分

0

好友

0

主题
1#
发表于 2012-2-17 16:28:11 | 查看: 3070| 回复: 1
select t.NAME,t.BLOCK1_OFFSET from v$datafile t
+DATA/aaa/datafile/system.262.735788807    4294967295
+DATA/aaa/datafile/undotbs1.263.735788811    4294967295
+DATA/aaa/datafile/sysaux.264.735788811    4294967295
+DATA/aaa/datafile/undotbs2.266.735788815    4294967295
+DATA/aaa/datafile/users.267.735788815    4294967295
+DATA/aaa/datafile/aaaaaa.273.735791083    4294967295
+DATA/aaa/datafile/aaa.389.735902487    4294967295
+DATA/aaa/datafile/aaaaaaa.776.768701343    4294967295
+FRA/aaa/datafile/aaaaaaa.824.769904049    4294967295
+FRA/aaa/datafile/undotbs1.1355.773922951    4294967295
+DATA/aaa/datafile/undotbs2.647.774624477    4294967295
+DATA/aaa/datafile/undotbs2.1174.774624577    4294967295
2#
发表于 2012-2-17 17:29:26
V$DATAFILE.BLOCK1_OFFSET do not make much sense for ASM. The value displayed is UB4MAXVAL (4-byte unsiged int max) for ASM when it cannot be computed.

2的32次方 - 1 = 4294967295

How an Oracle block# is mapped to a file offset (in bytes or OS blocks) [ID 761734.1]

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-15 01:54 , Processed in 0.049649 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569