RE: DBA_FREE_SPACE - Problem gone

We didn't restart the database but we did increase the size of one of the datafiles again by a few more meg at which point the entire amount (from all 3) showed up.

-----Original Message-----
Sent: Thursday, April 26, 2001 3:36 AM
To: Multiple recipients of list ORACLE-L

Did you shut down the data base and restarted ? or problem gone itself without doing anything.
A really weired situation.
Azhar              

                    "Miller, Jay"

                    <JayMiller_at_TDWater        To:     Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                    house.com>                cc:

                    Sent by:                  Subject:     RE:
DBA_FREE_SPACE - Problem gone                                         
                    root_at_fatcity.com

 

 

                    04/25/2001 08:03

                    PM

                    Please respond to

                    ORACLE-L

 

 

Well, this makes me really uncomfortable but the problem went away by itself. Dba_free_space is now showing the correct free space.

-----Original Message-----
Sent: Monday, April 23, 2001 5:19 PM
To: Multiple recipients of list ORACLE-L

One of the other DBAs here called me over to look at a weird situation.

We resized some datafiles, the size of the datafiles increased on the OS and
in dba_data_files but there are no entries for that tablespace in dba_free_space. Currently:

DBA_DATA_FILES - 11451M total size of datafiles (this agrees with OS)
DBA_SEGMENTS & DBA_EXTENTS - 10752M total size of extents/segments
DBA_FREE_SPACE - no entries

Oracle 8.1.5.1.0
Solaris 2.6

Any idea what might cause this?

Thanks,
Jay Miller

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: azhar_at_mathtech-pk.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.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).