Home » RDBMS Server » Server Administration » ASSM with LMT (oracle9i)
ASSM with LMT [message #330297] Sun, 29 June 2008 00:12 Go to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member

When we use ASSM set to AUTO, tablespace is LMT, then we do not need to worry about the below parameters.

1. PCTFREE
2. FREELISTS
3. FREELIST GROUPS
4. INITIAL
5. NEXT
5. PCTINCREASE
6. MINEXTENTS
7. MAXEXTENTS.


My question is, when the tablespace is ASSM set to AUTO & LMT, then do we need to worry about PCTUSED parameter?

Please advise.

Thanks

Report message to a moderator

Re: ASSM with LMT [message #330298 is a reply to message #330297] Sun, 29 June 2008 00:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Are you incapable or unwilling to RTFM found at http://tahiti.oracle.com?

PLEASE place this in context to the business problem that needs to be solve.

[Updated on: Sun, 29 June 2008 00:39] by Moderator

Report message to a moderator

Re: ASSM with LMT [message #330300 is a reply to message #330297] Sun, 29 June 2008 02:17 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
My question is, when the tablespace is ASSM set to AUTO & LMT, then do we need to worry about PCTUSED parameter?

No.

Database SQL Reference
CREATE TABLESPACE page
Paragraph segment_management_clause

Regards
Michel

Report message to a moderator

Previous Topic: PFILE and SPFILE
Next Topic: Multiple FREELIST
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 00:51:53 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.