DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Freelist Groups? BUFFER_POOL

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    My developer's table creation scripts have some CREATE TABLE options I've never come across before. He's using some tool to generate scripts and they've added vanilla storage clauses (all identical - initial extent 100K , next extent 100K etc) to every table regardless of use etc.

    At the end every table has 3 other clauses:

    FREELISTS 1
    FREELIST GROUPS 1
    BUFFER_POOL DEFAULT

    what do they mean in this CREATE TABLE context?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    do you know what's a freelist? check cocnept guide about them if not

    in 8i you can define 3 buffer pools, recycle keep and default, in that create table satement it's saying "put me this table in default pool"

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    I think the tool will have default storage parameters . which have to be altered while generating the database scripts .
    could i know which tool they are using ? ( ex Rational Rose , Designer/2000, some UML tools )
    siva prakash
    DBA

  4. #4
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    YEs, I know what the freelist is, but why define this at CREATE TABLE level?

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    uh freelists is define at segment level

  6. #6
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    So what does the DEFAULT pool mean? I can see why you'd keep a table in the KEEP pool or RECYCLE pool, so what's DEFAULT - can you set default in the ini.ora to be Keep or Recycle?

    I get the feeling this dev tool has created scripts and explicitly stated all the defaults just to look good.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well if you have only one pool then it's called default

    many tools generate those kind of scripts, nothing special

  8. #8
    Join Date
    Sep 2002
    Posts
    20
    Those options in the create table script is just oracle default settings in a single Oracle database environment.
    So if you don't mention these 3 lines in your create table script Oracle will asume that this is the settings for the table.

    So, if you know what freelists are, then freelists groups is for OPS/RAC(Parallel server)and because your environment is a single instance the freelists groups=1, the buffer_pool default setting is as mentioned earlier!

    /Beppo

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