Chinaunix首页 | 论坛 | 博客
  • 博客访问: 129582
  • 博文数量: 28
  • 博客积分: 610
  • 博客等级: 上士
  • 技术积分: 250
  • 用 户 组: 普通用户
  • 注册时间: 2011-05-10 10:12
文章分类

全部博文(28)

文章存档

2011年(28)

我的朋友

分类: Oracle

2011-09-13 11:25:00

============================
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)   

阅读(1554) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~