Re: excessive SMON on openvms update...

List,
 To solve the snapshot to old problem I created a new rollback segment 10 M /10 M without maxextents and increased my rollback tablespace to 8 GIG from 4 GIG. I should be able to handle it now without failing after I offlined the other rollback segments. I am in the process of dropping the TEMP tablespace again and all is going well. The SELECT count(*) from dba_free_space where tablespace_name ='TEMP'; is decreasing from 24599 by about 1000 per minute. Maybe before the days is done I can recreate my TEMP space again and then figure out another method if creating indexes. I probabily will truncate the table, create the indexes, and load one weeks worth of data at a time with commits in the script. Let it run all night and it should finish by the time I come to work again.
Ron
ROR mª¿àm

>>> RROGERS_at_galottery.org 09/23/02 03:23PM >>>
List,
 I have a new server that I installed Oracle 8.1.7.3 with partitions and LMT. Some of the tables are quite large( in excess of 10 GIG) and I
was creating the indexes when the communication channel was lost. Of course the rollback occurred but it was calculated to take in excess of
8 hours to complete. This was determined by "SELECT count(*) from dba_extents where segment_name = 'TEMP'; the answer was 104313. 5 minutes later the answer was 103849.
I had thought that all would go as planned and went on vacatio--- for a
week as planned. This is a new development server that I am trying to set up before creating the database for our production server. Later during the rollback I got the "snapshot to old" message. I'll live with it for now but the next day I received "can't allocate bytes in shared memory" error and SMON went to 100 % CPU and stayed that way for 4 days. The sysadmin suspended the SMON process while I was away. I
returned today and shutdown the database with "shutdown abort", shutdown
immediate hung. I restarted the database and all appeared well. I have a script that sums values in dba_free_space by tablespace_name and that appeared to be hung( not responding). I selected * from dba_free_space and the tablespace_name ='TEMP' had thousands of extents. I decided to halt the database and STARTUP MOUNT and ALTER DATABASE DATAFILE '...' OFFLINE DROP the datafile containing the TEMP tablespace. No problem as the database is not in archivelog mode. Then I open the database and DROP the TABLESPACE TEMP INCLUDING CONTENTS. This should allow me to create a new TEMP datafile and tablespace. The DROP TABLESPACE TEMP has been running for 4 hours now.  I do not have exclusive use of the CPU as this server functions as a company production server for other processes besides Oracle.

My questions;
  About how long would you guess that the drop tablespace action should
take to complete?
  How do I check the progress and can I stop the progress and pick up where it stopped
( the production people are nervous that it will not be done when they need the server)

  Does any one have an Oracle Database and other production functions on the same server using OpenVMS?
Thanks,
Ron
ROR mô¿ôm

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).