Re: Looking for a Script to list tables,its indexes and sizing info

  • From: Paul Drake <bdbafh@xxxxxxxxx>
  • To: bnsarma@xxxxxxxxx
  • Date: Sat, 28 Jan 2006 01:00:09 -0500

On 1/27/06, BN <bnsarma@xxxxxxxxx> wrote:
>
> 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
>

I dunno - trace the OEM session?

If you want it pretty,
SQL> set html markup on

its issuing SQL against a database instance via a session, right?
I don't think that's in violation of the DMCA yet ... just don't look at the
active session history views.

Paul




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_AK3
> I 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@xxxxxxxxxxxxxxx> 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*
> > *Pro Quest Information & Learning*
> >
> > "There are 10 types of people in the world:  Those who understand
> > binary, and those who don't."
> >
> >
> >  ------------------------------
> > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> > *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@xxxxxxxxxxxxxx > wrote:
> > >
> > > Look at dba_extents.
> > >
> > >  ------------------------------
> > > *From:* oracle-l-bounce@xxxxxxxxxxxxx 
> > > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> > > *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




--
#/etc/init.d/init.cssd stop
-- play a Sony CD, install a rootkit today

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2006