| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Looking for a Script to list tables,its indexes and sizing info
Greetings Mark,
No, I dont think your script lists the tables and its indexes with sizing info.. together,s oem thing like this with sizing info
OWNER TBS TABLE_NAME INDEX_NAME -------- ------------ ------------------------------ ------------------------------ XXXX TS_XXXXDATA2 XBO_ET_EQUIP XBO_ET_EQUIP_AK1 XXXX TS_XXXXDATA2 XBO_ET_EQUIP_AK2 XXXX TS_XXXXDATA2 XBO_ET_EQUIP_AK3I am linking dba_tables, dba_segments_dba_indexes, but dont know to get bytes, extents and inital_extent info along with the above info
I am planning to do alter table move for the tables to its new LMTS
tablespace and
rebuild indexes in their own lmts.
Regrds & Thanks
On 1/27/06, Bobak, Mark <Mark.Bobak_at_il.proquest.com> wrote:
>
> Based on your original question, I think this ought to do it:
>
> select owner, segment_type type, tablespace_name tablespace, segment_name,
> initial_extent/1024 iext_kb, extents, bytes/1048576 mb from dba_segments;
>
> It's pretty straightforward, really. Add where clause to filter out what
> you don't want, as appropriate.
>
> -Mark
>
> *--*
> *Mark J. Bobak*
> *Senior Oracle Architect*
> *ProQuest Information & Learning*
>
> "There are 10 types of people in the world: Those who understand binary,
> and those who don't."
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *BN
> *Sent:* Friday, January 27, 2006 2:42 PM
> *To:* Igor Neyman
> *Cc:* Oracle-L Freelists
> *Subject:* Re: Looking for a Script to list tables,its indexes and sizing
> info
>
>
> Greetings,
>
> This is not a Home work Question, I am trying to group tables based on
> their activty(high dml, hihg read, etc.,) and put them in New LMTS
> tablespaces with proper sizes and settings yo avoid hot disk issues.
>
> I have a script to list the tables and its indexes, I couldn't figure out
> a way to get the sizing details, so that I can do a sum for each group to
> create the right Tablespaces with right size
>
>
>
> On 1/27/06, Igor Neyman <ineyman_at_perceptron.com> wrote:
> >
> > Look at dba_extents.
> >
> > ------------------------------
> > *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> > *On Behalf Of *BN
> > *Sent:* Friday, January 27, 2006 2:04 PM
> > *To:* Oracle-L Freelists
> > *Subject:* Looking for a Script to list tables,its indexes and sizing
> > info
> >
> >
> > Greetings,
> >
> > Oracle 9iRel2:
> >
> > I am looking for a script to report the following info for the (given)
> > table and its indexes
> >
> > OWNER TYPE TABLESPACE SEGMENT_NAME
> > IEXT_KB EXTENTS MB
> > -------- -------- ------------------ ---------------------------
> > ---------- ---------- ----------
> > ABC Table TBS1 Table1
> > NNNN NNN NNNNNNN
> > Index TBS2 Index1
> > nnnn nn nnnnnnn
> > TBS2 Index2
> > nnnn nnnn nnnnnnnn
> > ......
> >
> > Table TBS3 Table2
> > nnnn nnnn nnnnnnn
> > Index TBS4 Index1
> > nnnn nnnn nnnnnnnn
> > ..........
> >
> > Thank you inadvance
> >
> > Regards & Thanks
> > BN
> >
>
>
>
> --
> Regards & Thanks
> BN
>
>
-- Regards & Thanks BN -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 27 2006 - 13:59:13 CST
 |
 |