Data Block Address (DBA)各种形式间的转换
来源:互联网 发布:网络订餐 编辑:程序博客网 时间:2024/04/29 13:28
Data block address
A Data Block Address (DBA) is the address of an Oracledata block for access purposes.
Find the DBA for a given row
Start by getting the file and block number of the row. Example:
SQL> SELECT 2 dbms_rowid.rowid_relative_fno(rowid) REL_FNO, 3 dbms_rowid.rowid_block_number(rowid) BLOCKNO, 4 empno, ename 5 FROM emp WHERE empno = 7369; REL_FNO BLOCKNO EMPNO ENAME---------- ---------- ---------- ---------- 4 20 7369 SMITH
Now, convert the file and block numbers to a DBA address:
SQL> variable dba varchar2(30)SQL> exec :dba := dbms_utility.make_data_block_address(4, 20);PL/SQL procedure successfully completed.SQL> print dbaDBA--------------------------------16777236
Convert a DBA back to file and block numbers
Example:
SQL> SELECT dbms_utility.data_block_address_block(16777236) "BLOCK", 2 dbms_utility.data_block_address_file(16777236) "FILE" 3 FROM dual; BLOCK FILE---------- ---------- 20 4
Also see
- Data block
Category:
- Database
0 0
- Data Block Address (DBA)各种形式间的转换
- Data Block Address (DBA)各种形式间的转换
- DBA- data block address
- data block address
- MFC CString 用法及跟其他各种形式的转换
- 指针的各种形式
- 输出各种形式的分数
- 卷积的各种形式
- 将dba转换成file号block号
- Javascript获得日期的各种形式
- 获取各种形式的系统时间
- 各种形式的Android Dialog实例
- 二叉树各种形式的创建
- Python3函数参数的各种形式
- rowid的理解及block转储(dump)、ITL、UBA、DBA
- address的网络字节的转换接口
- IP address 与 bigint 之间的转换
- 有关oracle data block的英文解读
- UrlRewrite伪静态
- C#篇之---数据类型
- 各种排序算法的总结和比较
- Java如何等待子线程执行结束
- 二分法查找
- Data Block Address (DBA)各种形式间的转换
- Android中资源文件夹res/raw和assets的区别和使用
- 如何成为一名研发主管--关于个人、过程、工具和团队之二
- JavaScript对函数的扫描过程
- 软件设计原则
- linux下svn命令使用大全(share)
- activity 过场动画
- 查询页1223
- CocoaAsyncSocket的readDataToLength方法的理解