| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> excessive SMON on openvms
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). Received on Mon Sep 23 2002 - 14:23:43 CDT
 |
 |