Home » RDBMS Server » Server Administration » "Oracle tablespace management", "extent management" and "segment space mana (Oracle 10g)
"Oracle tablespace management", "extent management" and "segment space mana [message #522077] Tue, 06 September 2011 06:36 Go to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
Hi,

Can you please clear my confusion about "Oracle tablespace management", "extent management" and "segment space management".

I believe "tablespace management" internally means "extent management"--am i correct?
My understanding about tablespace management is - how the space is managed in the tablespace, it could be dictionary or local, I assume the same defination for extent management--both imply the same.

Is there any difference between tablespace management and extent management.

"Segment space management" is "block management" i.e. how the blocks are managed which deals with pctfree, pctused,
freelists and free list groups.

Thanks

Regads,
Pointers
Re: "Oracle tablespace management", "extent management" and "segment space [message #522078 is a reply to message #522077] Tue, 06 September 2011 06:41 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
I don't know the term Quote:
"Oracle tablespace management"
You had better ignore it.
Re: "Oracle tablespace management", "extent management" and "segment space [message #522088 is a reply to message #522078] Tue, 06 September 2011 07:12 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...as well as "block management".

Regards
Michel

[Updated on: Tue, 06 September 2011 07:12]

Report message to a moderator

Previous Topic: table analyze issue
Next Topic: Oracle sysnoyms internal
Goto Forum:
  


Current Time: Thu Apr 18 15:16:13 CDT 2024