Home » RDBMS Server » Server Administration » system tablespace defragmentation
system tablespace defragmentation [message #62441] Thu, 22 July 2004 02:40 Go to next message
shyam
Messages: 25
Registered: January 2001
Junior Member
i am using 8.1.6 in solaris In My databse The system and rollback get
fragmented.IF i issue alter tablespace system coalesce is there any problems or whther its have any problems to the system,rollback segments
with regards
shyam

Report message to a moderator

Re: system tablespace defragmentation [message #62443 is a reply to message #62441] Thu, 22 July 2004 03:23 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please go through this

http://otn.oracle.com/deploy/availability/pdf/defrag.pdf

Report message to a moderator

Previous Topic: urgent: can i see rows_processed by pl/sql block
Next Topic: urgent :: pl/sql block taking so long time
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 03:59:24 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.