What's Inside Oracle Data Block?
5.9 هزار بار بازدید -
6 سال پیش
-
As we know that
As we know that #Oracle allocates logical #database space for all #data in a database. Data blocks are also called as logical or oracle blocks or pages.
And, oracle stores the data in data blocks to a specific number of #bytes of physical database space on #disk. Oracle data blocks are Logical storage space where Oracle Database stores data in data blocks at smallest unit.
00:00 What is the Data Block?
00:18 Data block default size
03:00 Internal format of the Block
03:08 Data Block Header
03:50 Table Directory
04:07 Row Directory
04:34 Free Space
04:46 Row Data
04:53 Data Block != OS Block
05:16 Row Format
06:17 Row Header
07:29 Column Data
08:14 How Row are inserted in the Data Block?
13:47 Inside Data Block
14:04 Varchar2 Datatype
19:18 Data Block Space Management
Website: https://www.dbagenesis.com/
Facebook: Facebook: dbagenesis
Instagram: Instagram: dbagenesis
Twitter: Twitter: DbaGenesis
And, oracle stores the data in data blocks to a specific number of #bytes of physical database space on #disk. Oracle data blocks are Logical storage space where Oracle Database stores data in data blocks at smallest unit.
00:00 What is the Data Block?
00:18 Data block default size
03:00 Internal format of the Block
03:08 Data Block Header
03:50 Table Directory
04:07 Row Directory
04:34 Free Space
04:46 Row Data
04:53 Data Block != OS Block
05:16 Row Format
06:17 Row Header
07:29 Column Data
08:14 How Row are inserted in the Data Block?
13:47 Inside Data Block
14:04 Varchar2 Datatype
19:18 Data Block Space Management
Website: https://www.dbagenesis.com/
Facebook: Facebook: dbagenesis
Instagram: Instagram: dbagenesis
Twitter: Twitter: DbaGenesis
6 سال پیش
در تاریخ 1397/12/15 منتشر شده
است.
5,995
بـار بازدید شده