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?

Hi,

Using the below query u can find exactly how much space has been eaten up on the disk by your table:

select bytes from user_segments where segment_name =

or by using the following query to know actually how many bytes data is stored in the table

select sum(vsize(col1) + vsize(col2) + vsize(col3) +........+ vsize(coln)) from ;

eg: to find the number of bytes of data in dept table use the following query

SELECT SUM( VSIZE(deptno) + VSIZE(dname) + VSIZE(loc) ) FROM scott.dept;

Guna Sagar Challa

 I have created a table in oracle 9i database. How can i know the storage prticulars of  a table  created in oracle database ?

please give me the answer to my e-mail id.

thank u

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.

Thanks in advance.

Related Open Questions

• Window or object is not displayed issue with Oracle nca protocol
• Repository services not started
• Indexing on frequently updated table
• Testing technique
• For a scenario I need load runner to give me a report in a specific format.
• Certification on Oracle service modules
• Installing mercury quality center
• What is the use of command objects and what are the methods provided by the command object ?
• Estimate for database testing
• What is meant by class space and object space (with regards to memory) in c++?

Ads

Connect

Ads

Question Categories

Oracle DBA FAQ

Interview Question

 Ask Interview Question?

 

Latest Questions

• How do we insert blob datatype into table? How to insert image in table?
• Oracle doc command
• Massallocation jouranl entry
• Compare duplicate tables
• Passing record group from form to report in d2k
• Exceptions
• SQL commands to manipulate Oracle database structures
• Oracle inventory
• Group by performance
• Change lov dynamically
• Mutual table
• Partitioned table
• Improve Oracle performance
• Count last transaction records
• Autonomous transaction
• Debug Oracle PL/SQL package
• Select updated values
• Spliting
• Oracle migration
• Oracle data adapter

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.