- 浏览: 26002 次
- 性别:
- 来自: 北京
最新评论
SEGMENT EXTENTS ORACLEBLOCK
- 博客分类:
- oracle
1.SEGMENT:
allocated for a specific data structure
Oracle allocates space for segments in units of one extent.
A segment and all its extents are stored in one tablespace
segment can span datafiles
table,index,temporary,undo
2.EXTENTS:
An extent is a specific number of contiguous data blocks.
Oracle allocates space for segments in units of one extent.
each extent can contain data from only one datafile.
alter table t allocate extent(size 1m datafile '');
alter table t deallocate unused;
3.BLOCK:
Although you can allocate additional extents, the blocks themselves are allocated separately. If you allocate an extent to a specific instance, the blocks are immediately allocated to the free list. However, if the extent is not allocated to a specific instance, then the blocks themselves are allocated only when the high water mark moves. The high water mark is the boundary between used and unused space in a segment.
A data block is the smallest unit of data used by a database
Data Block Format:Header,Table Directory,Row Directory,Free Space,Row Data
Row Chaining and Migrating
In two circumstances, the data for a row in a table may be too large to fit into a single data block. In the first case, the row is too large to fit into one data block when it is first inserted. In this case, Oracle stores the data for the row in a chain of data blocks (one or more) reserved for that segment. Row chaining most often occurs with large rows, such as rows that contain a column of datatype LONG
or LONG
RAW
. Row chaining in these cases is unavoidable.
However, in the second case, a row that originally fit into one data block is updated so that the overall row length increases, and the block's free space is already completely filled. In this case, Oracle migrates the data for the entire row to a new data block, assuming the entire row can fit in a new block. Oracle preserves the original row piece of a migrated row to point to the new block containing the migrated row. The rowid of a migrated row does not change.
When a row is chained or migrated, I/O performance associated with this row decreases because Oracle must scan more than one data block to retrieve the information for the row.
PCTFREE,PCTUSE,initrans,maxtrans,freelists
4. STRUCTURE OF THE ROW
generally, a row of table sore in a block. null columns can not sore in block.
head: the numbers of columns in a row. chain information. lock status.
row data: column length. column value. the slot of the Row Directory in the block point to the begining of the row.
发表评论
-
from string get number data using pl/sql or sql
2012-02-16 17:32 853declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 6841.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7561.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 849thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7101.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 767Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 6591.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7181.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11221.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5361.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6181.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 708When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 557A schema is a collection of dat ... -
MANAGE UNDOTABS
2011-12-19 17:15 6551.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4131.select a.name,b.status from v ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5401. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6581.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 8691.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 626ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6101.utl_file_dir: indicate the di ...
相关推荐
sql学习 segment 及extents的体会.sql
在ORACLE中,我们可以通过file_id(file#)与block_id(block#)去定位一个数据库对象(object)。例如,我们在10046生成的trace文件中file#=4 block#=266 blocks=8,那么我可以通过下面两个SQL去定位对象 SQL 1:此...
Segment Routing 思科原厂培训PPT L3/L2 , Traffic Engineering (TE) / Fast Reroute (FRR) services are offered over the MPLS backbone Complex protocol stacks Complex troubleshooting & operation
进制转换 这是学汇编语言时的一些程序 对初学者很有帮助
3 digit counter using 7segment
Laravel开发-segment 为Laravel编写的segment.com包装
PI SEGMENT项目的源代码
什么是Segment Routing、背景、实现原理、优势及应用
使用IAR开发ADI的ADUC70XX系列单片机时,编译出现下面错误提示: Fatal Error[e72]: Segment FIQ_STACK must b
比MPLS TE更好的技术 MPLS -SR PPT
介绍了Segment Routing MPLS的基本原理,基于Segment Routing MPLS的配置过程和典型配置举例。 1 Segment Routing MPLS概述 2 Segment Routing MPLS支持的License和配置注意事项 3 配置IS-IS SR-BE隧道 4 配置OSPF ...
android 自定义segment 能运行的
Segment Routing学习笔记 Segment Routing是一种源路由机制,其基于转发平面分为两种:SR-MPLS、SR v6 SR-MPLS 产生背景 基本原理 SR隧道建立过程 业务应用 可靠性
思科公司 segment Routing 技术详细介绍 Cisco Segment Routing introduce
DATA SEGMENT GRADE DB 76,69,84,90,73,88,99,63,100,80 MES1 DB '60-69:$' MES2 DB '70-79:$' MES3 DB '80-89:$' MES4 DB '90-99:$' MES5 DB '100:$' C1 DB 0 C2 DB 0 C3 DB 0 C4 DB 0 C5 DB 0 CNT EQU 10 DATA ...
一个segment的小应用,希望各位大神多多指点
在iOS开发中 很多人会使用segment来控制滚动试图 然后滚动试图也同时控制segment的需求。下面就来简单说说segment控制滚动试图的代码和原理。
一文读懂网络界新贵Segment Routing技术化繁为简的奥秘231541.pdf
文章《EDPF: A Realtime Parameter-Free Edge Segment Detector with a False Detection Control》的实现,已成功运行!边缘提取效果不错~