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: 266
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

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: 25033
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: 64102
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: PFILE and SPFILE
Next Topic: Multiple FREELIST
Goto Forum:
  


Current Time: Fri Dec 02 22:40:03 CST 2016

Total time taken to generate the page: 0.08435 seconds