How to dump Oracle Data Block?
来源:互联网 发布:客户时间提醒软件 编辑:程序博客网 时间:2024/06/11 05:19
Often while doing instance tuning or sql tuning, Internal structure of a Oracle Data block is important to know. Moreover when system does not show a significant direction to do troubleshooting. In this blog, I am explaining to how to extract dump of a oracle data block.
dump shows following details which may be significant to find the rationale of problem of state of block:
- contents of the block for the given datafile number and the block number
- how the data is stored internally
- list the contents of rows(Table Block) or index keys( Index Block)
- extent map in segment header block
- free extent pool in the undo segments header blocks
- the SCN of the block (useful in complex recovery scenario)
alter system dump datafile block ;
To dump multiple block use following command:
alter system dump datafile block min block max ;
To dump the segment header block and the data block of a given segment:
select file_id, block_id, blocksWait and watch, I will update this blog to have more example on how to investigate the dump of block.
from dba_extents
where segment_name = 'TEST';
FILE_ID BLOCK_ID BLOCKS
---------- ---------- ----------
1 29081 8
To dump the segment header block
alter system dump datafile 1 block 29081;
To dump the data block next to the segment header
alter system dump datafile 1 block 29082
To dump both the blocks at the same time
alter system dump datafile 1 block min 29081 block max 29082;
With above method, Oracle will dump all info in a file in USER_DUMP_DIRECTORY, one can find the file with instance name and OSPID.
Enjoy!!
- How to dump Oracle Data Block?
- how to dump oracle block
- how to dump undo header and block
- Data Block Dump
- How to use Oracle Dump Function
- 如何阅读oracle数据块data block dump文件
- How to analyze dump
- [c#] How to use Data Access Application Block?
- How to import an oracle dump into a different tablespace
- oracle data dump
- oracle data dump
- How to move Oracle data from one machine to another
- How to analyze Thread Dump
- NDISLWF how to block stream
- iOS: How to use "Block"
- Oracle 索引的 dump leaf block
- How to Export/import database dump correctly
- How to Create Dump File for Applications
- 8088/8086中断向量表【转】
- git 远程仓库搭建;kernel 2.6.27分支
- 一个完整的新浪微博客户端android版OAuth认证示例
- linux 任务管理-后台运行与终止
- 远程协助 及 vmware网络设置的几种模式
- How to dump Oracle Data Block?
- c中最基本的
- 一个幸福家庭必备的五个基本要素
- MFC编辑框改变背景、颜色
- 在jsp页面中嵌入文档【已验证】
- Android核心分析 之一--------分析方法论探讨之设计意图
- 24点之2 2 2 2
- 要成大事,我就要学会九种手段,九种能力,九种心态
- Android核心分析 之二 -------方法论探讨之概念空间篇