Home » RDBMS Server » Server Administration » storage (pctincrease 1)-
storage (pctincrease 1)- [message #55660] Thu, 06 February 2003 20:54 Go to next message
KK
Messages: 24
Registered: March 2002
Junior Member
Hi All,

Can i alter the temporary tablespace storage parameter PCTINCREASE to 1, so as to enable smon to automatically coalesce the tablespace.

"ALTER TABLESPACE TEMP DEFAULT STORAGE (PCTINCREASE 1)"

Please let me know.

Thanks & Regards,
Kiran.

Report message to a moderator

Re: storage (pctincrease 1)- [message #55676 is a reply to message #55660] Fri, 07 February 2003 06:05 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
yes

Report message to a moderator

Previous Topic: sys.v_$session table AND oracle8 client
Next Topic: Number of Hits to Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:50:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.