Home » SQL & PL/SQL » SQL & PL/SQL » how to find memory allocation of table
how to find memory allocation of table [message #340197] Mon, 11 August 2008 21:37 Go to next message
krishnareddy.ponugeti
Messages: 3
Registered: August 2008
Location: visakapatanam
Junior Member
please send the sql command
Re: how to find memory allocation of table [message #340198 is a reply to message #340197] Mon, 11 August 2008 22:02 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above
Re: how to find memory allocation of table [message #340238 is a reply to message #340197] Tue, 12 August 2008 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
desc user_segments.

Regards
Michel
Re: how to find memory allocation of table [message #340439 is a reply to message #340238] Tue, 12 August 2008 21:12 Go to previous messageGo to next message
krishnareddy.ponugeti
Messages: 3
Registered: August 2008
Location: visakapatanam
Junior Member
please send the sql command
Re: how to find memory allocation of table [message #340441 is a reply to message #340197] Tue, 12 August 2008 22:06 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
SELECT 42 FROM DUAL;

[Updated on: Tue, 12 August 2008 22:08] by Moderator

Report message to a moderator

Re: how to find memory allocation of table [message #340451 is a reply to message #340439] Wed, 13 August 2008 00:10 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or if you want the allocation map:
desc dba_extents

Regards
Michel
Previous Topic: External table does not allow nulls by default
Next Topic: Help with "What If" analysis
Goto Forum:
  


Current Time: Sat Dec 03 05:55:24 CST 2016

Total time taken to generate the page: 0.09444 seconds