各位老大.我数据库是9.2.0.7 平台是WindowS TMEP表空间满了.重启后不自动释放,增加TEMP表空间后也不在新表空间内扩展.
日志:
Mon Dec 11 17:33:38 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
processes
= 400
sessions
= 445
timed_statistics = TRUE
shared_pool_size = 318767104
sga_max_size
= 1158752180
large_pool_size
= 67108864
java_pool_size = 67108864
control_files
= G:\oracle\oradata\ora92\CONTROL01.CTL, G:\oracle\oradata\ora92\CONTROL02.CTL, G:\oracle\oradata\ora92\CONTROL03.CTL
db_block_size
= 8192
db_cache_size
= 528482304
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
rollback_segments= 30
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
=
instance_name
= ora92
dispatchers
= (PROTOCOL=TCP) (SERVICE=ora92XDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = G:\oracle\admin\ora92\bdump
user_dump_dest = G:\oracle\admin\ora92\udump
core_dump_dest = G:\oracle\admin\ora92\cdump
sort_area_size = 524288
db_name
= ora92
open_cursors
= 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 134217728
aq_tm_processes
= 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Mon Dec 11 17:33:43 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Dec 11 17:33:45 2006
ALTER DATABASE MOUNT
Mon Dec 11 17:33:49 2006
Successful mount of redo thread 1, with mount id 1920911737
Mon Dec 11 17:33:49 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Dec 11 17:33:50 2006
ALTER DATABASE OPEN
Mon Dec 11 17:33:52 2006
Beginning crash recovery of 1 threads
Mon Dec 11 17:33:52 2006
Started redo scan
Mon Dec 11 17:33:55 2006
Completed redo scan
181638 redo blocks read, 525 data blocks need recovery
Mon Dec 11 17:33:55 2006
Started recovery at
Thread 1: logseq 4119, block 66112, scn 0.0
Mon Dec 11 17:33:56 2006
Recovery of Online Redo Log: Thread 1 Group 2 Seq 4119 Reading mem 0
Mem# 0 errs 0: G:\ORACLE\ORADATA\ORA92\REDO02.LOG
Mon Dec 11 17:33:57 2006
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4120 Reading mem 0
Mem# 0 errs 0: G:\ORACLE\ORADATA\ORA92\REDO03.LOG
Mon Dec 11 17:33:59 2006
Completed redo application
Mon Dec 11 17:33:59 2006
Ended recovery at
Thread 1: logseq 4120, block 42953, scn 4.4251122100
525 data blocks read, 525 data blocks written, 181638 redo blocks read
Crash recovery completed successfully
Mon Dec 11 17:33:59 2006
Thread 1 advanced to log sequence 4121
Thread 1 opened at log sequence 4121
Current log# 1 seq# 4121 mem# 0: G:\ORACLE\ORADATA\ORA92\REDO01.LOG
Successful open of redo thread 1
Mon Dec 11 17:34:01 2006
SMON: enabling cache recovery
Mon Dec 11 17:34:04 2006
Successfully onlined Undo Tablespace 1.
Mon Dec 11 17:34:04 2006
SMON: enabling tx recovery
Mon Dec 11 17:34:04 2006
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Mon Dec 11 17:35:27 2006
/* OracleOEM */ ALTER TABLESPACE "TEMP" ADD TEMPFILE 'G:\ORACLE\ORADATA\ORA92\TEMP03.DBF' SIZE 2000M
Mon Dec 11 17:35:28 2006
Completed: /* OracleOEM */ ALTER TABLESPACE "TEMP" ADD TEMPFI
|