-
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
-
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.
-
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..
-
select n.name, s.optsize
from v$rollname, v$rollstat
where n.usn = s.usn
order by n.name
