How do i give optimal size to my RB segmennts
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How do i give optimal size to my RB segmennts

  1. #1
    Join Date
    Nov 1999
    Posts
    226
    Hi


    1 select n.name, s.optsize
    2 from v$rollname n, v$rollstat s
    3 where n.usn = s.usn
    4* order by n.name
    SQL> /

    NAME OPTSIZE
    ------------------------------ ---------
    R01
    R02
    R03
    R04
    R05
    R06
    RBIG
    SYSTEM

    This is what I get and I want to give an optimal size to these segments . Please let me know how do I give that

    Regards

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Set TIMED_STATISTICS=TRUE, and then run this query.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    TIMED_STATISTICS won't help here, you're looking at the optimal size of your rollback segments. The optsize field will show up regardless of whether you have TIMED_STATISTICS on or off.

    To set the optimal size of a rollback segment, issue:
    alter rollback segment r01 storage (optimal 8M);
    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
    Nov 1999
    Posts
    226

    Thanks ! one more thing

    How do I find out the current size of my rollback segments !!!

    regards

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    select n.name, s.rssize/1024/1024 rollback_mb, s.optsize, s.extents, s.xacts current_transactions, s.waits, s.gets, s.status, s.extends no_times_extended, s.shrinks no_times_shrunk
    from v$rollname n, v$rollstat s
    where n.usn = s.usn
    order by n.name
    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."

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