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.
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
Previous Topic: SGA Size
Next Topic: loadjava axis on Oracle9i jdk 1.3.1_01
Goto Forum:
  


Current Time: Fri Dec 02 20:46:37 CST 2016

Total time taken to generate the page: 0.14431 seconds