| |
GeekInterview.com > Interview Questions > Oracle > Database Administration
| Print | |
Question: What is the view name where i can get the space in MB for tables or views?
Answer: select segment_name,sum(bytes) from dba_segmentswhere segment_name='TABLE_NAME' AND OWNER='OWNER of the table'group by segment_name |
| July 07, 2006 10:34:13 |
#1 |
| satish penugonda |
Member Since: Visitor Total Comments: N/A |
RE: What is the view name where i can get the space i...
|
| and adding to the previous...view are not physical entities like tables which occupy space in the database..they are logical and whenever you select, the query underlying the view gets fired and results are returned. Hence, you cannot get the space information for views |
| |
Back To Question | |
