×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

@Sacramento

one more sample

mark80(longwalking)
本文发表在 rolia.net 枫下论坛Previous example is for create tablespace

example for create table
CREATE TABLE divisions
(div_no NUMBER(2),
div_name VARCHAR2(14),
location VARCHAR2(13) )
STORAGE ( INITIAL 100K NEXT 50K
MINEXTENTS 1 MAXEXTENTS 50 PCTINCREASE 5);

Oracle allocates space for the table based on the STORAGE parameter values as follows:
· The MINEXTENTS value is 1, so Oracle allocates 1 extent for the table upon creation.
· The INITIAL value is 100K, so the first extent's size is 100 kilobytes.
· If the table data grows to exceed the first extent, then Oracle allocates a second extent. The NEXT value is 50K, so the second extent's size would be 50 kilobytes.
· If the table data subsequently grows to exceed the first two extents, then Oracle allocates a third extent. The PCTINCREASE value is 5, so the calculated size of the third extent is 5% larger than the second extent, or 52.5 kilobytes. If the data block size is 2 kilobytes, then Oracle rounds this value to 52 kilobytes.
If the table data continues to grow, then Oracle allocates more extents, each 5% larger than the previous one.
· The MAXEXTENTS value is 50, so Oracle can allocate as many as 50 extents for the table.
So the extent size for this table is grow every time. The table storage extent will be set as
100k, 50k, 52.5, … 50(1+5%)**50). Oracle rounds the calculated size of each new extent to the nearest multiple of the data block size.

You can find more details from SQL refrence.更多精彩文章及讨论，请光临枫下论坛 rolia.net
(#1204745@0)
Last Updated: 2003-5-25
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / 建立数据库中的表时候，这是什么意思？extent size 1024 next size 256 lock mode page -oceandeep(北极熊® Zzz Zzz); 2003-5-23 (#1201860@0)
    • you can find all the answer from oracle documents. check the sql reference -mark80(longwalking); 2003-5-24 (#1202758@0)
    • Is it the parameter of Create/Alter tablespace ? -ling7199(Michaell); 2003-5-24 {143} (#1203282@0)
      If yes, it is define when your database size extend your define size, how much space will be allocated by the database.( Will has min and max).
      • 我想是建表的EXTEND 的SIZE，但我不懂 NEXT SIZE是什么意思，而且如果我想直接建一个表，让它占个1G的空间，不知道如何操作 -oceandeep(北极熊® Zzz Zzz); 2003-5-24 (#1203293@0)
        • 你现在是DBA？ -henhen(哼哼,找工ing...); 2003-5-24 (#1203300@0)
          • 打杂的，从电线管到人脑：（ -oceandeep(北极熊® Zzz Zzz); 2003-5-24 (#1203302@0)
            • 人脑? 怎么管，拆开瞄瞄？ 你别吓偶。 -henhen(哼哼,找工ing...); 2003-5-24 (#1203336@0)
    • the answer is -zhao_e(zhao_e); 2003-5-24 {812} (#1203409@0)
      A segment is a database object (eg a
      table , an index). A segment is made up of extents. An extent is made up
      of database blocks. (blocks are fixed size eg 512, 1024, 2048, 4096, 8192
      bytes) When you create a database segment (eg a table) it occupies at least
      1 extent and at least 1 block. An extent is 1 or more database block in
      size (always an integral number, 1,2,3,4,5. never 2.5 database blocks).
      When you insert data into a table Oracle puts that data into an allocated
      extent provided there is room. (really a block that is part of an extent.)
      If all the extents are full then it grows bigger. It allocates X more
      blocks as the next extent. (eg 10 blocks could make up the next extent) You
      can control how large an extent is and how many there are when you define
      your database segment.
      • 哦，那第一个数字是初始化表的BLOCKS数字，NEXT后面的是满了后添加的BLOCK数字，对吗？ -oceandeep(北极熊® Zzz Zzz); 2003-5-24 (#1203438@0)
        • 不对，和满不满没有关系。extent size是数据库分配的第一个entent的大小。 -m30(m30); 2003-5-24 {260} (#1203525@0)
          如果你已知这个表的大小，由于一个entent内部的空间是连续的，你可以通过设置entent size把这个表当前所有的数据，放在一个连续的空间（查找速度就快）。然后你估计表可能增加的速度，来决定next size的大小。第一个数字一般很大（如果数据已经很多的话），第二个数字通常小很多。
          • 我觉得你的意思和我一样啊，而且大多数情况下，对于一个很大的表，分配不到连续的空间的，除非是全部重新建立数据库空间 -oceandeep(北极熊® Zzz Zzz); 2003-5-25 (#1204353@0)
    • 这是ORAcle吧. -rror(斧头帮黄金左脚系统支); 2003-5-24 (#1203420@0)
      • 不是，但我觉得所有中大型数据库这种方面应该是一样的 -oceandeep(北极熊® Zzz Zzz); 2003-5-24 (#1203439@0)
        • 对。 -henhen(哼哼,找工ing...); 2003-5-24 {20} (#1203442@0)
          要不要偶发本书给你？
          • 什么书？等你回土狼屯再说吧 -oceandeep(北极熊® Zzz Zzz); 2003-5-25 (#1204350@0)
    • Let us take an example -mark80(longwalking); 2003-5-24 {358} (#1203470@0)
      CREATE TABLESPACE tbs_AA
      DATAFILE 'tbsAA.dbf' SIZE 50M
      MINIMUM EXTENT 500K
      DEFAULT STORAGE (INITIAL 128K NEXT 128K).

      My understand is this tablespace will grow as unit of 500k. For example 1000k, 1500k,) as need. Any table using this tablespace will have default extent at 128k. It may depend on each table's specification.
      Hope its help.
      • 谢谢，但好象我那里建表的语法和你的不一样。按你的例子来说，那个NEXT 后面的128K是什么意思？好象也不是NEXT EXTENT 的SIZE -oceandeep(北极熊® Zzz Zzz); 2003-5-25 (#1204362@0)
        • 我觉得你的和我用过的很象阿，不过我都忘了:P -lizpan(九月的高跟鞋); 2003-5-25 (#1204370@0)
        • 你怎么不去doors open？偶念念不忘咱们去年看见的小火车，你待会要是去的话，给偶的小火车们问个好。 -henhen(哼哼,找工ing...); 2003-5-25 (#1204375@0)
          • 呵呵，不会再去了 -oceandeep(北极熊® Zzz Zzz); 2003-5-25 {30} (#1204382@0)
            我喜欢自然的东西，不喜欢人文的
            • 这年头，熊都很挑剔啊，显然有点歧视偶们人类的说。 ：（（（ -henhen(哼哼,找工ing...); 2003-5-25 (#1204749@0)
        • one more sample -mark80(longwalking); 2003-5-25 {1539} (#1204745@0)
          本文发表在 rolia.net 枫下论坛Previous example is for create tablespace

          example for create table
          CREATE TABLE divisions
          (div_no NUMBER(2),
          div_name VARCHAR2(14),
          location VARCHAR2(13) )
          STORAGE ( INITIAL 100K NEXT 50K
          MINEXTENTS 1 MAXEXTENTS 50 PCTINCREASE 5);

          Oracle allocates space for the table based on the STORAGE parameter values as follows:
          · The MINEXTENTS value is 1, so Oracle allocates 1 extent for the table upon creation.
          · The INITIAL value is 100K, so the first extent's size is 100 kilobytes.
          · If the table data grows to exceed the first extent, then Oracle allocates a second extent. The NEXT value is 50K, so the second extent's size would be 50 kilobytes.
          · If the table data subsequently grows to exceed the first two extents, then Oracle allocates a third extent. The PCTINCREASE value is 5, so the calculated size of the third extent is 5% larger than the second extent, or 52.5 kilobytes. If the data block size is 2 kilobytes, then Oracle rounds this value to 52 kilobytes.
          If the table data continues to grow, then Oracle allocates more extents, each 5% larger than the previous one.
          · The MAXEXTENTS value is 50, so Oracle can allocate as many as 50 extents for the table.
          So the extent size for this table is grow every time. The table storage extent will be set as
          100k, 50k, 52.5, … 50(1+5%)**50). Oracle rounds the calculated size of each new extent to the nearest multiple of the data block size.

          You can find more details from SQL refrence.更多精彩文章及讨论，请光临枫下论坛 rolia.net
          • 非常谢谢你，把ORACLE里面建表的方式搞懂了。 -oceandeep(北极熊® Zzz Zzz); 2003-5-25 {24} (#1204849@0)
            我那个问题应该也差不多的

More Topics

  • 哪位Excel大神帮忙解答一下，一个spreadsheet一表格connection到另外一个spreadsheet，原来的data是数字格式，但是connection以后变成text格式，这是为什么呢？这两天才出现的问题，之前好多年没有过这样的问题。谢谢先
  • 中国政府官方的行为，证明了，苹果手机是世界上最安全的手机。感谢乔布斯先生。感谢库克先生硬是顶住了美国政府的最强大的压力。
  • 老程序员第一次用copilot的一点点体会
  • 现在社区游泳池招救生员巡逻，过一会还要不停的点人头，这工作是否很快就被AI代替了，装一个摄像头后面是AI处理系统，这样只招一个等着救人就行了，人头沉下水一定时间立马强光照射，还可以分析水下人的状况来判断是否溺水等
  • 新冠疫苗引发心肌炎? 最新研究这样看
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论