RE: High water mark in a datafile

*Datafile* Vikas!

;)

Jared

On Sun, 25 Jun 2000, Gurgaon, DBA (CAP, GECSI, CONTRACTOR) wrote:

> Hi Linda
>
> These Queries will help you in Knowing HWM.
>
> Analyze table scott.emp compute statistics;
>
> select t.blocks as hwm,t.empty_blocks,t.blocks,t.table_name,
> s.blocks from dba_tables t,dba_segments s
> where t.table_name='EMP' and t.owner='SCOTT'
> and t.table_name=s.segment_name;
>
> Vikas
>
> -----Original Message-----
> Sent: Friday, June 23, 2000 11:46 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello,
>
> Does someone have the query to determine the highest used block in a
> datafile?
>
> Someone posted it a week or so ago, and I can't find it now.
>
> Thanks,
>
> Linda
>
> --
> Author: Linda Hagedorn
> INET: Linda_at_pets.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Gurgaon, DBA (CAP, GECSI, CONTRACTOR)
> INET: DBA.Gurgaon_at_geind.GE.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Mon Jun 26 2000 - 14:28:19 CDT