extent management local
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: extent management local

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    could someone explain to me what is

    'EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K'


    how should we size the extents ??? and what value to be efficient ??? what happen if your extent is too big ???

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    This topic has been discussed several times on this forum. Use http://www.dbasupport.com/forums/search.php and search for LMT
    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."

  3. #3
    Join Date
    Feb 2001
    Posts
    290
    You may have a LOCALLY MANAGED TABLESPACE.

    that means , Oracle manages the space requirements for that tablespace locally and eleiminates the burden on data dictionary , and its a good deal for performance, coz oracle doesnt need to write/update the dictionary.

    'EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K'

    In the above syntax .. extents will be allocated to the objects in 1MB each time a request is generated.

    Thanks,
    Madhu




  4. #4
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    If your extent is too big, your tablespace get extended less frequently. But your disk may not be used efficiently because you have more unused space in your tablespace.

  5. #5
    Join Date
    Jan 2002
    Posts
    474
    how do you check to see for the unused space on your tablespace ???

    Thanks

  6. #6
    Join Date
    Feb 2001
    Posts
    290
    Since this is a LOCALLY Managed tablespace , you can not check the DBA_FREE_SPACE for the un used space.

    Well here we have some views :

    select bytes_used,bytes_cached from v$temp_extent_pool;

    another views to look at are
    v$temp_space_header
    v$temp_extent_map

    V$sort_usage
    v$sort_segment

    You have to fight with the above view ...

    Madhu

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by mrvajrala
    Since this is a LOCALLY Managed tablespace , you can not check the DBA_FREE_SPACE for the un used space.
    joking? or you really mean locally managed TEMPORARY Tablespace with TEMPFILE?


  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by mrvajrala
    Since this is a LOCALLY Managed tablespace , you can not check the DBA_FREE_SPACE for the un used space.
    ....SNIP.....
    That's not true, I think you've confused that with localy managed temporary tablespace! For other permanent localy managed tablespaces DBA_FREE_SPACE still works the same way as in the old days.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Feb 2001
    Posts
    290
    Yep , I really Joked ...

    Its Locally Managed Temporary tablespace....

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