444 out of 500 Extents: PLS RECOMMEND.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: 444 out of 500 Extents: PLS RECOMMEND.

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Lightbulb

    Hi
    this is my ddl for a specific object. what shall i make the new storage parameters as? I will need to change that parameter by 2 days.

    CREATE TABLE BUSOBJ.OBJ_X_DOCUMENTS
    (
    X_DOC_N_ID NUMBER(10) NOT NULL,
    X_DOC_N_BLOCKID NUMBER(10) NOT NULL,
    X_DOC_B_CONTENT LONG RAW NOT NULL
    )
    TABLESPACE BOTS
    LOGGING
    PCTFREE 10
    PCTUSED 40
    INITRANS 1
    MAXTRANS 255
    STORAGE(INITIAL 1M
    NEXT 2M
    MINEXTENTS 1
    MAXEXTENTS 505
    PCTINCREASE 0
    FREELISTS 1
    FREELIST GROUPS 1
    BUFFER_POOL DEFAULT)
    NOPARALLEL
    NOCACHE
    /
    COMMENT ON TABLE BUSOBJ.OBJ_X_DOCUMENTS IS
    'Document storage table'
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Mar 2001
    Posts
    314
    Convert the "X_DOC_B_CONTENT " col from LONG RAW TO CLOB for starters ??

    -amar

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Just change maxextents to unlimited and don't worry about it.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    change next equal to initial

    may be increase initrans if it's a busy table

  5. #5
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Marist,
    thankyou for your solution but its not good enough. I will eventually run out of extents and my tablespace will fill up quickly. I would appreciate if I can get a better solution. Also..what benefits would I have if i change from long raw to clob?

    "High Salaries = Happiness = Project Success."

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    If you change to maxextents unlimited, you will NEVER reach max extents. Sure, you might run out of space, but that has nothing to do with the number of extents you have.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Mar 2001
    Posts
    314
    Jigar,

    Regarding the advantages of converting from LONG RAW to BLOB please refer to the App Developers Guide - Large Objects and also Fundamentals.

    -amar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width