GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Oracle
Go To First  |  Previous Question  |  Next Question 
 Oracle  |  Question 11 of 244    Print  
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?

  
Total Answers and Comments: 3 Last Update: October 11, 2006     Asked by: durga4578 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
March 27, 2006 03:52:24   #1  
Guna Sagar Challa        

RE: i am creating one table in oracle. in database it...

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 <table 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 <table_name>;

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


 
Is this answer useful? Yes | No
March 29, 2006 01:25:00   #2  
S.Madhu        

storage prticulars of a table created in oracle database

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


 
Is this answer useful? Yes | No
October 11, 2006 11:43:34   #3  
dev        

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.

Thanks in advance.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape