免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 918 | 回复: 0
打印 上一主题 下一主题

objd, dba, slot [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2011-12-23 01:02 |只看该作者 |倒序浏览
============================
objd:
    Is assigned to each data object, such as table or index when it is created, and it is unique within the database.

objd:
    刚开始的时候表的objn和objd是一样,每次truncate table后objd的值将会逐渐增加。视图的objd值为0。

-----------
data block address (DBA):

The DBA (here: not the database administrator but the data block address) uniquely identifies a database block in the database.
Behind such a database block address is a datafile number and the block number within that database file.
The datafile number can be found with dbms_utility.data_block_address_file. The block number within this file can be found with dbms_utility.data_block_address_block. A database block address can be constructed from a datafile number and a block number with make_data_block_address.

-----------
slot:
    DBMS_ROWID can be used to convert ROWIDs into a
        File id (rowid_relative_fno)
        Block number (rowid_block_number)
        Slot number in block (rowid_row_number)   

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

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP