Message-Id: <5EB1A7B30200000B00071F11@groupwise2014.gcrta.org>
Date: Tue, 05 May 2020 13:51:47 -0400
From: "Jeffrey Beckstrom" <jbeckstrom@gcrta.org>
To: "oracle-l-freelist" <oracle-l@freelists.org>,<veeeraman@gmail.com>
Subject: Re: [External]  Space explanation
References: 
 <CAHSa0M3D1GTdwajgBu3MNPRSgxwLtjhtq0vgNVFi8OB7EU4ccg@mail.gmail.com>
In-Reply-To: <CAHSa0M3D1GTdwajgBu3MNPRSgxwLtjhtq0vgNVFi8OB7EU4ccg@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/mixed; boundary="=__Part83BC61A3.0__="
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: jbeckstrom@gcrta.org
--=__Part83BC61A3.0__=
Content-Type: multipart/alternative; boundary="=__Part83BC61A3.1__="
--=__Part83BC61A3.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

The insert caused the table to allocate storage. When the insert failed, =
the rows were rolled back. However, the storage does not get released.=20
>>> Ram Raman <veeeraman@gmail.com> 5/5/20 12:21 PM >>>
Hi

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 =3D 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 ;

COUNT(*)
--------------------
0

Elapsed: 00:00:00.00
11:14:35 SQL>
--=20
Thanks
Ram

--=__Part83BC61A3.1__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<html><head>=0A=0A<meta name=3D"Generator" content=3D"Novell Groupwise =
Client (Version 14.2.3  Build: 129832)">=0A<meta http-equiv=3D"Content-Type=
" content=3D"text/html; charset=3Dutf-8"></head>=0A<body style=3D"font: =
10pt/normal Segoe UI; font-size-adjust: none; font-stretch: normal;"><div =
class=3D"GroupWiseMessageBody" id=3D"GroupWiseSection_1588701059000_jbeckst=
rom@gcrta.org_114824E002EF00009705AA006A008700_"><div>The insert caused =
the table to allocate storage. When the insert failed, the rows were =
rolled back. However, the storage does not get released. <br></div><div =
class=3D"GroupWiseMessageBody" id=3D"GroupWiseSection_1588701059000_jbeckst=
rom@gcrta.org_114824E002EF00009705AA006A008700_"><span class=3D"GroupwiseRe=
plyHeader">&gt;&gt;&gt; Ram Raman &lt;veeeraman@gmail.com&gt; 5/5/20 12:21 =
PM &gt;&gt;&gt;<br></span><div>=0A<div dir=3D"ltr"><div>Hi</div><div><br></=
div><div>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</div><div><br></div><di=
v>  1  select table_name, NUM_ROWS, last_analyzed, blocks from dba_tables<b=
r>  2* where table_name =3D upper('wvce')<br>11:14:17 SQL&gt; /<br><br>TABL=
E_NAME                           NUM_ROWS LAST_ANAL     BLOCKS<br>---------=
--------------- -------------------- --------- ----------<br>WVCE          =
                              0 03-MAY-20    3444463<br><br>Elapsed: =
00:00:00.09<br>11:14:17 SQL&gt;<br>11:14:28 SQL&gt; select count(*) from =
WVCE ;<br><br>            COUNT(*)<br>--------------------<br>             =
      0<br><br>Elapsed: 00:00:00.00<br>11:14:35 SQL&gt;<br></div>-- =
<br><div class=3D"gmail_signature" dir=3D"ltr" data-smartmail=3D"gmail_sign=
ature"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">=
<div> </div><div>Thanks</div><div>Ram</div></div></div></div></div></div></=
div>=0A</div></div></div></body></html>

--=__Part83BC61A3.1__=--

--=__Part83BC61A3.0__=--
--
http://www.freelists.org/webpage/oracle-l