dba_segments

From: Joe B <Joeba_at_SeeMySigForMyRealAddress.com>
Date: Sat, 10 Apr 1999 23:51:58 GMT
Message-ID: <370fe363.34112147_at_news.ntplx.net>

Hello
I am new to Oracle so please excuse me if this question is something I should know...

What does the dba_segments table contain and if someone gave me a query like this ...

select segment_name, sum(bytes)/1024/1024 from dba_segments where segmnet_name in ('AAA', 'BBB', 'CCC') group by segment_name;

what bit of information were they trying to extract?

TIA

---

Reply to: joeba AT ntplx.net Received on Sun Apr 11 1999 - 01:51:58 CEST