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)
To dump single block use following command:
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, blocks
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;
Wait and watch, I will update this blog to have more example on how to investigate the dump of block.
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.
分享到:
相关推荐
How to Dump Frames for Camera Tuning And Debugging
Data Dump Export 1.打开Toad for Oracle 2.进入 View|Toad Options...|Options窗口 3.在这边点击 Executables,在Export Dump:和Import Dump:中分别输入Oracle安装路径\product\10.1.0\db_3\BIN\expdp.exe,Oracle...
Oracle常用dump命令介绍
Oracle 11g 是一种关系型数据库管理系统, EXPDP 是 Oracle 11g 中的一种数据导出工具,用于将数据库中的数据导出到一个 dump 文件中,而后可以将该文件导入到另一个数据库中。 在 Windows 下使用 EXPDP 工具导出 ...
Dbmover for Mysql to Oracle 是高效的将Mysql导入到Oracle数据库的工具。 使用DBMover可以灵活定义Mysql和Oracle之间表和字段的对照关系,也可以在DBMover创建一个查询,把查询结果当作源表转入到Oracle中。 ...
SUPTOOL CONV - Convert HEX DUMP or BLOCKDUMP to readable form (Doc ID 47419.1)
当使用DataGrip导出myusqldump文件备份数据库的时候会让选择本地exe,这个时候下载使用即可适用于mysql5.7其他版本可能也可以
用c语言开发,读取计算机cmos data,供学习使用
批处理导出oracle数据库为dump文件,之后可以正常导入
展讯6531抓取 Assert Memory dump方法,详细介绍了展讯6531平台Assert 死机时,如何抓取Memory dump方法。
dumping oracle block,including data block,index block and control file block..
ESXI用U盘启动ESXI用U盘启动ESXI用U盘启动
修改oracle的dmp文件版本,可以把高版本导出的dmp文件修改为低版本,从而导入到低版本的oracle数据库.
Advanced Windows Memory Dump Analysis with Data Structures(3rd) 英文无水印pdf 第3版 pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn删除 ...
can i get an amen we are about see greatness in this one
z/os取得sa dump How_to_take_a_Standalone_dump
从oracledatabase 10g开始引入了data pump(数据泵)工具,它提供了一种基于服务器的数据导出导入使用程序。 所有的data pump都作为一个服务器进程,数据...Data Pump工具的导出和导入实现Oracle数据库之间数据的传输。
Oracle常用dump命令.pdf
# By default, 'ass' attempts to dump as much information as possible and # assumes that the output is to be printed to screen. This means that 'ass' # runs in its slowest mode. Ass can be changed/...
迅速教会你使用STM8的C编程,详细教程