GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  Oracle

 Print  |  
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.

Thanks in advance.

     

 

Back To Question