Home » RDBMS Server » Server Administration » shrinking or tuning index and RBS segments
shrinking or tuning index and RBS segments [message #209403] Thu, 14 December 2006 11:05 Go to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member
The current size of our database is approximately 35GB. The version of DB is Oracle 8.1.7.

The Rollback segments is currently holding approximately 1.25GB data and INDEX segment is currently holding 2.73 GB data.

How to shrink or tune these segments? How can I know whether this much space is really required to occupy lookig at the application and database perspective?

How to dig a deep to shrink or tune these segments?

Thanks in advance.

Report message to a moderator

Re: shrinking or tuning index and RBS segments [message #209671 is a reply to message #209403] Sat, 16 December 2006 09:59 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
hi,

are you facing any problem due to rollback segments.
or if you have access on Metalink take a look
Metalink > 1011108.6 "general overview of rollback segments.
Metalink > 69464.1 "rollback segment configuration and tips.

http://martybugs.net/articles/oracleimport4.cgi


regards
Taj

Report message to a moderator

Previous Topic: SGA Size
Next Topic: loadjava axis on Oracle9i jdk 1.3.1_01
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:26:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.