sho parameter spfile
Цитата: NAME TYPE VALUE
---------------------------------------------------------------
spfile string %ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA
alert_lukoshko.log
Цитата: Sun Aug 22 10:54:06 2010
ALTER DATABASE CLOSE NORMAL
Sun Aug 22 10:54:06 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Sun Aug 22 10:54:06 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 3555
Successful close of redo thread 1
Sun Aug 22 10:54:06 2010
Completed: ALTER DATABASE CLOSE NORMAL
Sun Aug 22 10:54:06 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun Aug 22 10:54:43 2010
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.8.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 159383552
large_pool_size = 8388608
java_pool_size = 0
control_files = E:\Oradata\Lukoshko\control01.ctl, E:\Oradata\Lukoshko\control02.ctl, E:\Oradata\Lukoshko\control03.ctl
db_block_size = 8192
db_cache_size = 629145600
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = Lukoshko
job_queue_processes = 5
hash_join_enabled = TRUE
background_dump_dest = e:\oradata\Lukoshko\bdump
user_dump_dest = e:\oradata\Lukoshko\udump
core_dump_dest = e:\oradata\Lukoshko\cdump
sort_area_size = 4194304
db_name = Lukoshko
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 209715200
PMON started with pid=2, OS id=4392
DBW0 started with pid=3, OS id=5460
LGWR started with pid=4, OS id=4216
CKPT started with pid=5, OS id=5408
SMON started with pid=6, OS id=5612
RECO started with pid=7, OS id=4308
CJQ0 started with pid=8, OS id=2380
Sun Aug 22 10:54:46 2010
ALTER DATABASE MOUNT
Sun Aug 22 10:54:50 2010
Successful mount of redo thread 1, with mount id 2698419254
Sun Aug 22 10:54:50 2010
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sun Aug 22 10:54:51 2010
ALTER DATABASE OPEN
Sun Aug 22 10:54:51 2010
Thread 1 opened at log sequence 3555
Current log# 3 seq# 3555 mem# 0: E:\ORADATA\LUKOSHKO\REDO03.LOG
Successful open of redo thread 1
Sun Aug 22 10:54:51 2010
SMON: enabling cache recovery
Sun Aug 22 10:54:52 2010
Successfully onlined Undo Tablespace 1.
Sun Aug 22 10:54:52 2010
SMON: enabling tx recovery
Sun Aug 22 10:54:52 2010
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN