Newbie Tablespace Tuning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Newbie Tablespace Tuning

  1. #1
    Join Date
    Sep 2002
    Posts
    29

    Question

    I've been pseudo assigned the role of DBA. I'm taking Oracle classes and trying to get a handle on what's going on with my database (Oracle 8.1.6, Windows 2000). Here's the first of many questions to come. I'm looking at the size of my tablespaces and I'm not exactly sure what I'm looking at. I'm questioning my temporary tablespace. The initial extent is 1048576 and the next extent is 1048576. My max extet is 1. My percent increase is 0. My min extent is 1048576. The allocation is normal. Is it normal for the initial extent and next to be equal? What about the the min extent at the same size? Is this to prevent data fragmentation? Why wouldn't the percent increase be set higher? I know this questions may be basic to some but I'm not really sure what I'm viewing. Any help would be appreciated.


  2. #2
    Join Date
    Nov 2000
    Posts
    224
    Every thing looks good except min extents, Oracle will try to allocate atlease these no. of extents. I generally set it to 2.

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