Home » RDBMS Server » Server Administration » how to find no: of extents reached in a segment?
how to find no: of extents reached in a segment? [message #212284] Thu, 04 January 2007 09:07 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hi..
What is the query to to find no: of extents currently used within a segment?
and same way what is the query to find no: of extents used within a tablespace?and how many free extents?

Report message to a moderator

Re: how to find no: of extents reached in a segment? [message #212291 is a reply to message #212284] Thu, 04 January 2007 09:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> What is the query to to find no: of extents currently used within a segment?
check user_segments
and for the rest and more examples,
search this forum. Question is been answered a zillion times

Report message to a moderator

Re: how to find no: of extents reached in a segment? [message #212327 is a reply to message #212291] Thu, 04 January 2007 13:02 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Mahesh Rajendran wrote on Thu, 04 January 2007 10:32
>>
search this forum. Question is been answered a zillion times



Mahesh, I told you a billion times, don't exaggerate 1

---

1 "Young Ones" reference, circa 1987.

Report message to a moderator

Re: how to find no: of extents reached in a segment? [message #212328 is a reply to message #212327] Thu, 04 January 2007 13:10 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
Dictionary.com Unabridged (v 1.1) - Cite This Source
zil·lion /ˈzɪlyən/ Pronunciation Key - Show Spelled Pronunciation[zil-yuhn] Pronunciation Key - Show IPA Pronunciation noun, plural -lions, (as after a numeral) -lion, adjective Informal.
–noun
1. an extremely large, indeterminate number.

LOL Smile
I was about to invent my own abbreviation
STF= search the forum or something like that
Smile
Regards~

Report message to a moderator

Previous Topic: about MAX_EXTENTS
Next Topic: 10g Export error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:33:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.