Re: Truncate and free space

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Tue, 29 Aug 2006 15:20:05 GMT
Message-ID: <J4rMLJ.G@igsrsparc2.er.usgs.gov>

devjnr_at_gmail.com wrote:
> Mark D Powell ha scritto:
>

>> Via SQLPlus you should be able to query dba_segments and/or dba_extents
>> to immediately see the change.

>
>
> Can you tell me pls which is the exact query to do this?
>
> Thx.
>

Try any of the following:

SELECT segment_name,bytes,extents FROM dba_segments WHERE owner='SCOTT' AND segment_name='EMP';

or

SELECT segment_name,count(*) AS extents, SUM(bytes) AS bytes FROM dba_extents WHERE owner='SCOTT' AND segment_name='EMP' GROUP BY segment_name;

In the above, substitute the table owner and table name for SCOTT and EMP respectively.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Tue Aug 29 2006 - 10:20:05 CDT