Re: Space explanation

From: Powell, Mark <>
Date: Tue, 5 May 2020 16:56:55 +0000
Message-ID: <>

RAM, this is expected behavior. Once space is allocated to an object it generally takes DBA action to free the space whether at the table, index, or data file level.

Run a truncate on the table to free up the unneeded extents.

Mark Powell
Database Administration
(313) 592-5148

From: <> on behalf of Ram Raman <> Sent: Tuesday, May 5, 2020 12:21 PM
To: ORACLE-L <> Subject: Space explanation


I created a table for testing and inserting rows into it when the insert process failed as the tablespace reached maximum limit of 32G - that happened couple of days ago. However, there are no rows in the table, but space occupied shows as real high with the tablespace itself full. Does anyone have an idea? There are couple of other tables in the tablespace but they occupy just few 100 blocks. 12c

  1 select table_name, NUM_ROWS, last_analyzed, blocks from dba_tables   2* where table_name = upper('wvce')
11:14:17 SQL> /

TABLE_NAME                           NUM_ROWS LAST_ANAL     BLOCKS

------------------------ -------------------- --------- ----------
WVCE 0 03-MAY-20 3444463

Elapsed: 00:00:00.09
11:14:17 SQL>
11:14:28 SQL> select count(*) from WVCE ;



Elapsed: 00:00:00.00
11:14:35 SQL>


DXC Technology Company - Headquarters: 1775 Tysons Boulevard, Tysons, Virginia 22102, USA. DXC Technology Company -- This message is transmitted to you by or on behalf of DXC Technology Company or one of its affiliates. It is intended exclusively for the addressee. The substance of this message, along with any attachments, may contain proprietary, confidential or privileged information or information that is otherwise legally exempt from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate any part of this message. If you have received this message in error, please destroy and delete all copies and notify the sender by return e-mail. Regardless of content, this e-mail shall not operate to bind DXC Technology Company or any of its affiliates to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. --.

-- Received on Tue May 05 2020 - 18:56:55 CEST

Original text of this message