On 1/27/06, BN <bnsarma_at_gmail.com> 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_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*
> > *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_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
--
#/etc/init.d/init.cssd stop
-- play a Sony CD, install a rootkit today
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jan 28 2006 - 00:00:09 CST
