Question: i am creating one table in oracle. in database it is allocated some memory for that table. how can i know how much memory that table is holding in that database?
October 10, 2006 11:43:34
#3
dev
Member Since: Visitor Total Comments: N/A
RE: i am creating one table in oracle. in database it...
Hi,
for every table it is giving the same answer like:
SQL> select bytes from user_segments where segment_name='DEPT';
BYTES ---------- 65536
why? I did compress on one table. eventhough it's giving same answer.