Re: Temp tablespace high watermark

Emrynsoft wrote:

> Hi,
>
> Is there any way to find out the high watermark i.e what wwas the maximum space
> that was allocated at any time since the instance was up for a temporary
> tablespace.
>
> I am running 7.3 with tablespace defined as temporary.
>
> Thanks for any help,
> Abhijit

also found this at
http://www.orafaq.org

There is no system table which containts the high water mark (HWM) information. You can calculate the HWM using the results from the following SQL statements:

        SELECT BLOCKS
        FROM   DBA_SEGMENTS
        WHERE  OWNER=UPPER(owner) AND SEGMENT_NAME = UPPER(table)

        ANALYZE TABLE owner.table ESTIMATE STATISTICS

        SELECT EMPTY_BLOCKS
        FROM   DBA_TABLES
        WHERE  OWNER=UPPER(owner) AND SEGMENT_NAME = UPPER(table)

Thus, the tables' HWM = (query result 1) - (query result 2) - 1

--

Hope this helps !

Regards,
Srini

(to reply via email, please change "nospam" to "chavali" in my email address -
:-)  )