OraFAQ Forum: Server Administration » Tablespace RBS is used in 99%

Home » RDBMS Server » Server Administration » Tablespace RBS is used in 99%

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tablespace RBS is used in 99% [message #52064]

Mon, 01 July 2002 05:08

Piotr K
Messages: 2
Registered: July 2002

Junior Member

problem is that 99,% space is always used even when there is no user connected, no transaction. Is it normal? I always thought that rollback segments used were automatically freed when transactions end. Can someone explain me why 99% of the rbs tablespace remain used all the time ?
Thank you for all

Piotr

Report message to a moderator

Re: Tablespace RBS is used in 99% [message #52065 is a reply to message #52064]

Mon, 01 July 2002 05:56

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

hi,
try to set the optimal size to the rollback segments..so that they wont exceed more than that limit..also keep shrinking them at regular intervals..

if rollback segments are used till 99% also, there will not be any problem..except at some cases u r query performance will go down..

sai

Report message to a moderator

Explanation ! [message #52090 is a reply to message #52064]

Tue, 02 July 2002 06:08

B
Messages: 327
Registered: August 1999

Senior Member

Hi

1- Transaction begin
2- 1 RBS contains information extend itself if needed
3- Transaction finished
4- RBS is marked FREE ( but the allocated extents are still HERE, and can be use for another transaction )

To avoid this problem use the OPTIMAL CLAUSE
"create rbs NAME STORAGE ( INTIAL ... NEXT ... OPTIMAL OPTIMAL_SIZE ... )"
Or use "alter rbs NAME shrink to SHRINK_SIZE;" to force the RBS to shrink to SHRINK_SIZE

PS: Please excuse my poor english

Report message to a moderator