Home » RDBMS Server » Server Administration » Regarding Extent Allocation
Regarding Extent Allocation [message #183016] Wed, 19 July 2006 03:15 Go to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Hi All,
How can we know when an extent is allocated for a particular segmennt.

Thanks And Regards
Dinesh
Re: Regarding Extent Allocation [message #183026 is a reply to message #183016] Wed, 19 July 2006 04:02 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
There are no direct mark of date of creation of extent, because they are not objects(only part of objects - segments). Also you can see indirectly how much are grows segment, monitoring periodically size of them from dba_extents view.
Previous Topic: How can I find session which had started(submited) job ?
Next Topic: How to retrieve the dropped table
Goto Forum:
  


Current Time: Fri Sep 20 09:29:31 CDT 2024