Home » RDBMS Server » Server Administration » Extent Allocation
Extent Allocation [message #284780] Sat, 01 December 2007 01:21 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All,

will it be possible to know when the last extent was allocated to a segment (EMP)?
for example we a table segment EMP
I want to know latest extent allocated to the table segment EMP with time/date of allocation.

Regards,
M.Shakeel Azeem

Report message to a moderator

Re: Extent Allocation [message #284794 is a reply to message #284780] Sat, 01 December 2007 03:19 Go to previous message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No it is not possible unless you mine your (archived) logs and are an expert in reading sys table updates.

Regards
Michel

[Updated on: Sat, 01 December 2007 03:19]

Report message to a moderator

Previous Topic: Java Exceptions while installing Oracle
Next Topic: Altering a Table Partition
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 14:26:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.