Calculation of remaining space in LMT's...

From: Spendius <spendius_at_muchomail.com>
Date: 10 Aug 2006 05:22:01 -0700
Message-ID: <1155212521.003221.153850@i42g2000cwa.googlegroups.com>

Hi,
In 10g is there no other way to get info about remaining room in locally managed tablespaces (with a calculation *taking in account* the eventual AUTOEXTEND mode of datafiles) than using DBMS_SERVER_ALERT procedures and then SELECTs against DBA_ALERT_HISTORY ?

There are unfortunately no such views as V$TEMP_SPACE_HEADER and
V$TEMP_EXTENT_MAP (that underlyingly query X$KTFTHC and X$KTFTME structures) for regular tablespace datafiles...

By the way does running SELECTs against these views cause Oracle's reads in temp. files space/bitmap headers ?

Thanks. Received on Thu Aug 10 2006 - 07:22:01 CDT