RBS datafiles
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RBS datafiles

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    My RBS datafiles show less % available..
    What should I do now.. How much should I worry.. Thx..


    DBFILE TOTALMB MBFREE PctFree
    ---------------------------------------- ---------- ---------- ----------
    /u03/oradata/nbs/reptx01.dbf 50 49 98
    /u03/oradata/nbs/acctmgmt01.dbf 1000 990 99
    /u04/oradata/nbs/acctmgmtx01.dbf 50 49 98
    /u04/oradata/nbs/nbsrbs01.dbf 100 1 1
    /u04/oradata/nbs/nbsrbs01.dbf 100 2 2
    /u04/oradata/nbs/nbsrbs01.dbf 100 1 1
    /u04/oradata/nbs/nbsrbs01.dbf 100 1 1
    /u04/oradata/nbs/nbsrbs01.dbf 100 1 1
    /u04/oradata/nbs/nbsrbs01.dbf 100 24 24
    /u04/oradata/nbs/nbsrbs01.dbf 100 6 6
    /u04/oradata/nbs/nbsrbs01.dbf 100 38 38

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I don't really get why /u04/oradata/nbs/nbsrbs01.dbf is listed so many times, but...

    Unless you have specified an OPTIMAL storage parameter, your RBS will not shrink automatically. During typical database operation, your RBS will grow to a certain size because you have a transaction that is that big. You can shrink it down, but the odds are that it will grow that large again. If you are getting "snapshot too old" messages or you can not complete some of the transactions, you probably need more RBS space. If not, leave it alone.
    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
    Oct 2000
    Posts
    449
    You are right. We are importing lots of data into tables. As of now I am not getting any errors. I would have a large job to runonce again this evening. How do I know if I have an OPTIMAL mentioned or not for shrink. I recently started here.
    Thx..

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    select n.name, s.optsize
    from v$rollname, v$rollstat
    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