Notes

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Fri Aug 08 16:46:52 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:541M/1013M, Ph+PgF:2233M/2440M, VA:1945M/2047M
Fri Aug 08 16:46:52 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
MMAN started with pid=4, OS id=3496
DBW0 started with pid=5, OS id=3500
LGWR started with pid=6, OS id=3504
CKPT started with pid=7, OS id=3508
SMON started with pid=8, OS id=3528
RECO started with pid=9, OS id=3532
CJQ0 started with pid=10, OS id=3536
MMON started with pid=11, OS id=3540
MMNL started with pid=12, OS id=3544
Fri Aug 08 16:46:53 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
PSP0 started with pid=3, OS id=3492
The input backup piece C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERCONFIGSEEDDBEXPRESS.DFB is in compressed format.
PMON started with pid=2, OS id=3488
Fri Aug 08 16:47:08 2014
Full restore complete of datafile 4 to datafile copy C:ORACLEXEORADATAXEUSERS.DBF. Elapsed time: 0:00:13
checkpoint is 193065
Full restore complete of datafile 2 to datafile copy C:ORACLEXEORADATAXEUNDO.DBF. Elapsed time: 0:00:13
checkpoint is 193065
Full restore complete of datafile 3 to datafile copy C:ORACLEXEORADATAXESYSAUX.DBF. Elapsed time: 0:00:21
checkpoint is 193065
Fri Aug 08 16:47:20 2014
Full restore complete of datafile 1 to datafile copy C:ORACLEXEORADATAXESYSTEM.DBF. Elapsed time: 0:00:25
checkpoint is 193065
Fri Aug 08 16:47:20 2014
Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:oraclexeoradataXEsystem.dbf',
'C:oraclexeoradataXEundo.dbf',
'C:oraclexeoradataXEsysaux.dbf',
'C:oraclexeoradataXEusers.dbf'
LOGFILE
GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K,
RESETLOGS
Fri Aug 08 16:47:20 2014
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Fri Aug 08 16:47:20 2014
Successful mount of redo thread 1, with mount id 2736173272
Fri Aug 08 16:47:20 2014
Completed: Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:oraclexeoradataXEsystem.dbf',
'C:oraclexeoradataXEundo.dbf',
'C:oraclexeoradataXEsysaux.dbf',
'C:oraclexeoradataXEusers.dbf'
LOGFILE
GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K,
RESETLOGS
Shutting down instance: further logons disabled
Fri Aug 08 16:47:21 2014
Stopping background process CJQ0
Fri Aug 08 16:47:21 2014
Stopping background process MMNL
Fri Aug 08 16:47:22 2014
Stopping background process MMON
Fri Aug 08 16:47:23 2014
Shutting down instance (immediate)
License high water mark = 1
Fri Aug 08 16:47:23 2014
Stopping Job queue slave processes
Fri Aug 08 16:47:23 2014
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Aug 08 16:47:25 2014
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Aug 08 16:47:25 2014
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Aug 08 16:47:27 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=180
PSP0 started with pid=3, OS id=192
MMAN started with pid=4, OS id=196
DBW0 started with pid=5, OS id=200
LGWR started with pid=6, OS id=204
CKPT started with pid=7, OS id=220
SMON started with pid=8, OS id=1364
RECO started with pid=9, OS id=224
MMON started with pid=10, OS id=1212
MMNL started with pid=11, OS id=608
Fri Aug 08 16:47:27 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri Aug 08 16:47:27 2014
Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:oraclexeoradataXEsystem.dbf',
'C:oraclexeoradataXEundo.dbf',
'C:oraclexeoradataXEsysaux.dbf',
'C:oraclexeoradataXEusers.dbf'
LOGFILE
GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K,
RESETLOGS
Fri Aug 08 16:47:27 2014
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Fri Aug 08 16:47:27 2014
Successful mount of redo thread 1, with mount id 2736190687
Fri Aug 08 16:47:27 2014
Completed: Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:oraclexeoradataXEsystem.dbf',
'C:oraclexeoradataXEundo.dbf',
'C:oraclexeoradataXEsysaux.dbf',
'C:oraclexeoradataXEusers.dbf'
LOGFILE
GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K,
RESETLOGS
Fri Aug 08 16:47:27 2014
Stopping background process MMNL
Fri Aug 08 16:47:28 2014
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
MMON started with pid=10, OS id=432
Fri Aug 08 16:47:29 2014
ALTER SYSTEM enable restricted session;
MMNL started with pid=11, OS id=436
Fri Aug 08 16:47:29 2014
alter database "XE" open resetlogs
Fri Aug 08 16:47:29 2014
RESETLOGS after incomplete recovery UNTIL CHANGE 193065
Fri Aug 08 16:47:29 2014
Errors in file c:oraclexeapporacleadminxeudumpxe_ora_232.trc:
ORA-00313: open failed for members of log group 1 of thread 1

db_recovery_file_dest_size of 10240 MB is 0.49% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Aug 08 16:47:30 2014
Errors in file c:oraclexeapporacleadminxeudumpxe_ora_232.trc:
ORA-00313: open failed for members of log group 2 of thread 1

Fri Aug 08 16:47:31 2014
Errors in file c:oraclexeapporacleadminxeudumpxe_ora_232.trc:
ORA-00313: open failed for members of log group 3 of thread 1

Fri Aug 08 16:47:32 2014
Setting recovery target incarnation to 2
Fri Aug 08 16:47:32 2014
Assigning activation ID 2736190687 (0xa316f4df)
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_3_9Y9DGC3F_.LOG
Successful open of redo thread 1
Fri Aug 08 16:47:32 2014
SMON: enabling cache recovery
Fri Aug 08 16:47:34 2014
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Fri Aug 08 16:47:34 2014
SMON: enabling tx recovery
Fri Aug 08 16:47:34 2014
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:

ALTER TABLESPACE <tablespace_name> ADD TEMPFILE

Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Updating character set in controlfile to WE8MSWIN1252
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=1100
Fri Aug 08 16:47:36 2014
LOGSTDBY: Validating controlfile with logical metadata
Fri Aug 08 16:47:36 2014
LOGSTDBY: Validation complete
Global Name changed to XE
Completed: alter database "XE" open resetlogs
Fri Aug 08 16:47:38 2014
alter database rename global_name to "XE"
Completed: alter database rename global_name to "XE"
Fri Aug 08 16:47:38 2014
Thread 1 advanced to log sequence 2
Current log# 1 seq# 2 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Fri Aug 08 16:47:38 2014
alter database drop logfile group 3
Fri Aug 08 16:47:38 2014
Deleted Oracle managed file C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_3_9Y9DGC3F_.LOG
Completed: alter database drop logfile group 3
Fri Aug 08 16:47:38 2014
ALTER TABLESPACE TEMP ADD TEMPFILE 'C:oraclexeoradataXEtemp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'C:oraclexeoradataXEtemp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Fri Aug 08 16:47:40 2014
ALTER SYSTEM disable restricted session;
Fri Aug 08 16:47:42 2014
Starting background process CJQ0
CJQ0 started with pid=21, OS id=2088
Fri Aug 08 16:47:47 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2207K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Fri Aug 08 16:47:48 2014
Shutting down instance: further logons disabled
Fri Aug 08 16:47:49 2014
Stopping background process QMNC
Fri Aug 08 16:47:49 2014
Stopping background process CJQ0
Fri Aug 08 16:47:52 2014
Stopping background process MMNL
Fri Aug 08 16:47:53 2014
Stopping background process MMON
Fri Aug 08 16:47:54 2014
Shutting down instance (immediate)
License high water mark = 1
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Aug 08 16:47:56 2014
ALTER DATABASE CLOSE NORMAL
Fri Aug 08 16:47:56 2014
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Aug 08 16:47:56 2014
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 2
Successful close of redo thread 1
Fri Aug 08 16:47:56 2014
Completed: ALTER DATABASE CLOSE NORMAL
Fri Aug 08 16:47:56 2014
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Aug 08 16:47:58 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=2416
PSP0 started with pid=3, OS id=2424
MMAN started with pid=4, OS id=2420
DBW0 started with pid=5, OS id=1936
LGWR started with pid=6, OS id=2436
CKPT started with pid=7, OS id=2432
SMON started with pid=8, OS id=2464
RECO started with pid=9, OS id=2440
CJQ0 started with pid=10, OS id=2472
MMON started with pid=11, OS id=2468
MMNL started with pid=12, OS id=444
Fri Aug 08 16:47:59 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri Aug 08 16:47:59 2014
ALTER DATABASE MOUNT
Fri Aug 08 16:48:03 2014
Setting recovery target incarnation to 2
Fri Aug 08 16:48:03 2014
Successful mount of redo thread 1, with mount id 2736230911
Fri Aug 08 16:48:03 2014
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Aug 08 16:48:03 2014
ALTER DATABASE OPEN
Fri Aug 08 16:48:03 2014
Thread 1 opened at log sequence 2
Current log# 1 seq# 2 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Fri Aug 08 16:48:03 2014
SMON: enabling cache recovery
Fri Aug 08 16:48:04 2014
Successfully onlined Undo Tablespace 1.
Fri Aug 08 16:48:04 2014
SMON: enabling tx recovery
Fri Aug 08 16:48:04 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=2608
Fri Aug 08 16:48:06 2014
Completed: ALTER DATABASE OPEN
Fri Aug 08 16:48:07 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Aug 08 16:48:21 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Mon Aug 11 12:51:12 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:754M/1013M, Ph+PgF:2278M/2440M, VA:1945M/2047M
Mon Aug 11 12:51:12 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
MMAN started with pid=4, OS id=436
PSP0 started with pid=3, OS id=432
DBW0 started with pid=5, OS id=440
LGWR started with pid=6, OS id=444
CKPT started with pid=7, OS id=1780
SMON started with pid=8, OS id=1776
RECO started with pid=9, OS id=1764
CJQ0 started with pid=10, OS id=448
MMON started with pid=11, OS id=452
MMNL started with pid=12, OS id=456
Mon Aug 11 12:51:13 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Aug 11 12:51:14 2014
alter database mount exclusive
PMON started with pid=2, OS id=428
Setting recovery target incarnation to 2
Mon Aug 11 12:51:18 2014
Successful mount of redo thread 1, with mount id 2736445186
Mon Aug 11 12:51:18 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Aug 11 12:51:18 2014
alter database open
Mon Aug 11 12:51:18 2014
Beginning crash recovery of 1 threads
Mon Aug 11 12:51:18 2014
Started redo scan
Mon Aug 11 12:51:19 2014
Completed redo scan
793 redo blocks read, 61 data blocks need recovery
Mon Aug 11 12:51:19 2014
Started redo application at
Thread 1: logseq 2, block 18350
Mon Aug 11 12:51:19 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Mon Aug 11 12:51:19 2014
Completed redo application
Mon Aug 11 12:51:19 2014
Completed crash recovery at
Thread 1: logseq 2, block 19143, scn 220697
61 data blocks read, 61 data blocks written, 793 redo blocks read
Mon Aug 11 12:51:19 2014
Thread 1 advanced to log sequence 3
Thread 1 opened at log sequence 3
Current log# 2 seq# 3 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Mon Aug 11 12:51:20 2014
SMON: enabling cache recovery
Mon Aug 11 12:51:24 2014
Successfully onlined Undo Tablespace 1.
Mon Aug 11 12:51:24 2014
SMON: enabling tx recovery
Mon Aug 11 12:51:24 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=1420
Mon Aug 11 12:51:30 2014
Completed: alter database open
Mon Aug 11 12:51:30 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Mon Aug 11 16:37:36 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:754M/1013M, Ph+PgF:2277M/2440M, VA:1945M/2047M
Mon Aug 11 16:37:36 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=440
PSP0 started with pid=3, OS id=444
MMAN started with pid=4, OS id=448
DBW0 started with pid=5, OS id=468
LGWR started with pid=6, OS id=472
CKPT started with pid=7, OS id=476
SMON started with pid=8, OS id=484
RECO started with pid=9, OS id=496
CJQ0 started with pid=10, OS id=500
MMON started with pid=11, OS id=508
MMNL started with pid=12, OS id=504
Mon Aug 11 16:37:39 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Aug 11 16:37:39 2014
alter database mount exclusive
Mon Aug 11 16:37:43 2014
Setting recovery target incarnation to 2
Mon Aug 11 16:37:43 2014
Successful mount of redo thread 1, with mount id 2736450835
Mon Aug 11 16:37:43 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Aug 11 16:37:43 2014
alter database open
Mon Aug 11 16:37:44 2014
Beginning crash recovery of 1 threads
Mon Aug 11 16:37:44 2014
Started redo scan
Mon Aug 11 16:37:44 2014
Completed redo scan
1142 redo blocks read, 276 data blocks need recovery
Mon Aug 11 16:37:44 2014
Started redo application at
Thread 1: logseq 3, block 29531
Mon Aug 11 16:37:44 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Mon Aug 11 16:37:45 2014
Completed redo application
Mon Aug 11 16:37:45 2014
Completed crash recovery at
Thread 1: logseq 3, block 30673, scn 246836
276 data blocks read, 276 data blocks written, 1142 redo blocks read
Mon Aug 11 16:37:46 2014
Thread 1 advanced to log sequence 4
Thread 1 opened at log sequence 4
Current log# 1 seq# 4 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Mon Aug 11 16:37:46 2014
SMON: enabling cache recovery
Mon Aug 11 13:08:08 2014
Successfully onlined Undo Tablespace 1.
Mon Aug 11 13:08:08 2014
SMON: enabling tx recovery
Mon Aug 11 13:08:09 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=128
Mon Aug 11 13:08:16 2014
Completed: alter database open
Mon Aug 11 13:08:17 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Aug 11 13:10:55 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Mon Aug 11 15:10:00 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:754M/1013M, Ph+PgF:2278M/2440M, VA:1945M/2047M
Mon Aug 11 15:10:00 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=348
PSP0 started with pid=3, OS id=356
MMAN started with pid=4, OS id=380
DBW0 started with pid=5, OS id=392
LGWR started with pid=6, OS id=1696
CKPT started with pid=7, OS id=1688
SMON started with pid=8, OS id=424
RECO started with pid=9, OS id=428
CJQ0 started with pid=10, OS id=432
MMON started with pid=11, OS id=436
MMNL started with pid=12, OS id=440
Mon Aug 11 15:10:00 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Aug 11 15:10:00 2014
alter database mount exclusive
Mon Aug 11 15:10:04 2014
Setting recovery target incarnation to 2
Mon Aug 11 15:10:04 2014
Successful mount of redo thread 1, with mount id 2736483976
Mon Aug 11 15:10:04 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Aug 11 15:10:04 2014
alter database open
Mon Aug 11 15:10:05 2014
Beginning crash recovery of 1 threads
Mon Aug 11 15:10:05 2014
Started redo scan
Mon Aug 11 15:10:05 2014
Completed redo scan
1528 redo blocks read, 300 data blocks need recovery
Mon Aug 11 15:10:05 2014
Started redo application at
Thread 1: logseq 4, block 1364
Mon Aug 11 15:10:05 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Mon Aug 11 15:10:06 2014
Completed redo application
Mon Aug 11 15:10:06 2014
Completed crash recovery at
Thread 1: logseq 4, block 2892, scn 270055
300 data blocks read, 300 data blocks written, 1528 redo blocks read
Mon Aug 11 15:10:06 2014
Thread 1 advanced to log sequence 5
Thread 1 opened at log sequence 5
Current log# 2 seq# 5 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Mon Aug 11 15:10:06 2014
SMON: enabling cache recovery
Mon Aug 11 15:10:07 2014
Successfully onlined Undo Tablespace 1.
Mon Aug 11 15:10:07 2014
SMON: enabling tx recovery
Mon Aug 11 15:10:07 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1528
Mon Aug 11 15:10:10 2014
Completed: alter database open
Mon Aug 11 15:10:11 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Aug 11 15:14:02 2014
Starting ORACLE instance (normal)
Mon Aug 11 15:15:29 2014
Starting ORACLE instance (normal)
Mon Aug 11 15:18:47 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2208K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Mon Aug 11 15:25:33 2014
Starting ORACLE instance (normal)
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Tue Aug 12 09:24:28 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:751M/1013M, Ph+PgF:2275M/2440M, VA:1945M/2047M
Tue Aug 12 09:24:28 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=368
PSP0 started with pid=3, OS id=376
MMAN started with pid=4, OS id=380
DBW0 started with pid=5, OS id=392
LGWR started with pid=6, OS id=452
CKPT started with pid=7, OS id=496
SMON started with pid=8, OS id=516
RECO started with pid=9, OS id=200
CJQ0 started with pid=10, OS id=1520
MMON started with pid=11, OS id=540
MMNL started with pid=12, OS id=564
Tue Aug 12 09:24:28 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Tue Aug 12 09:24:28 2014
alter database mount exclusive
Tue Aug 12 09:24:32 2014
Setting recovery target incarnation to 2
Tue Aug 12 09:24:32 2014
Successful mount of redo thread 1, with mount id 2736526092
Tue Aug 12 09:24:32 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Aug 12 09:24:33 2014
alter database open
Tue Aug 12 09:24:33 2014
Beginning crash recovery of 1 threads
Tue Aug 12 09:24:33 2014
Started redo scan
Tue Aug 12 09:24:33 2014
Completed redo scan
657 redo blocks read, 62 data blocks need recovery
Tue Aug 12 09:24:33 2014
Started redo application at
Thread 1: logseq 5, block 1247
Tue Aug 12 09:24:33 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 5 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Tue Aug 12 09:24:33 2014
Completed redo application
Tue Aug 12 09:24:33 2014
Completed crash recovery at
Thread 1: logseq 5, block 1904, scn 293769
62 data blocks read, 62 data blocks written, 657 redo blocks read
Tue Aug 12 09:24:34 2014
Thread 1 advanced to log sequence 6
Thread 1 opened at log sequence 6
Current log# 1 seq# 6 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Tue Aug 12 09:24:35 2014
SMON: enabling cache recovery
Tue Aug 12 09:24:39 2014
Successfully onlined Undo Tablespace 1.
Tue Aug 12 09:24:39 2014
SMON: enabling tx recovery
Tue Aug 12 09:24:39 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=976
Tue Aug 12 09:24:43 2014
Completed: alter database open
Tue Aug 12 09:24:43 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Tue Aug 12 10:30:53 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:750M/1013M, Ph+PgF:2275M/2440M, VA:1945M/2047M
Tue Aug 12 10:30:53 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=536
PSP0 started with pid=3, OS id=548
MMAN started with pid=4, OS id=556
DBW0 started with pid=5, OS id=560
LGWR started with pid=6, OS id=856
CKPT started with pid=7, OS id=1096
SMON started with pid=8, OS id=1364
RECO started with pid=9, OS id=1520
CJQ0 started with pid=10, OS id=1620
MMON started with pid=11, OS id=1184
MMNL started with pid=12, OS id=1148
Tue Aug 12 10:30:53 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Tue Aug 12 10:30:53 2014
alter database mount exclusive
Tue Aug 12 10:30:57 2014
Setting recovery target incarnation to 2
Tue Aug 12 10:30:57 2014
Successful mount of redo thread 1, with mount id 2736498589
Tue Aug 12 10:30:57 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Aug 12 10:30:57 2014
alter database open
Tue Aug 12 10:30:57 2014
Beginning crash recovery of 1 threads
Tue Aug 12 10:30:57 2014
Started redo scan
Tue Aug 12 10:30:58 2014
Completed redo scan
85 redo blocks read, 35 data blocks need recovery
Tue Aug 12 10:30:58 2014
Started redo application at
Thread 1: logseq 6, block 1526
Tue Aug 12 10:30:58 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 6 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Tue Aug 12 10:30:58 2014
Completed redo application
Tue Aug 12 10:30:58 2014
Completed crash recovery at
Thread 1: logseq 6, block 1611, scn 315640
35 data blocks read, 35 data blocks written, 85 redo blocks read
Tue Aug 12 10:30:59 2014
Thread 1 advanced to log sequence 7
Thread 1 opened at log sequence 7
Current log# 2 seq# 7 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Tue Aug 12 10:30:59 2014
SMON: enabling cache recovery
Tue Aug 12 10:31:00 2014
Successfully onlined Undo Tablespace 1.
Tue Aug 12 10:31:00 2014
SMON: enabling tx recovery
Tue Aug 12 10:31:00 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=248
Tue Aug 12 10:31:02 2014
Completed: alter database open
Tue Aug 12 10:31:03 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Tue Aug 12 10:46:17 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:753M/1013M, Ph+PgF:2274M/2440M, VA:1945M/2047M
Tue Aug 12 10:46:17 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=384
PSP0 started with pid=3, OS id=392
MMAN started with pid=4, OS id=512
DBW0 started with pid=5, OS id=536
LGWR started with pid=6, OS id=544
CKPT started with pid=7, OS id=556
SMON started with pid=8, OS id=976
RECO started with pid=9, OS id=980
CJQ0 started with pid=10, OS id=1012
MMON started with pid=11, OS id=1080
MMNL started with pid=12, OS id=1620
Tue Aug 12 10:46:18 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Tue Aug 12 10:46:18 2014
alter database mount exclusive
Tue Aug 12 10:46:22 2014
Setting recovery target incarnation to 2
Tue Aug 12 10:46:22 2014
Successful mount of redo thread 1, with mount id 2736514106
Tue Aug 12 10:46:22 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Aug 12 10:46:22 2014
alter database open
Tue Aug 12 10:46:22 2014
Beginning crash recovery of 1 threads
Tue Aug 12 10:46:22 2014
Started redo scan
Tue Aug 12 10:46:23 2014
Completed redo scan
968 redo blocks read, 257 data blocks need recovery
Tue Aug 12 10:46:23 2014
Started redo application at
Thread 1: logseq 7, block 3
Tue Aug 12 10:46:23 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 7 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Tue Aug 12 10:46:24 2014
Completed redo application
Tue Aug 12 10:46:24 2014
Completed crash recovery at
Thread 1: logseq 7, block 971, scn 336085
257 data blocks read, 257 data blocks written, 968 redo blocks read
Tue Aug 12 10:46:24 2014
Thread 1 advanced to log sequence 8
Thread 1 opened at log sequence 8
Current log# 1 seq# 8 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Tue Aug 12 10:46:24 2014
SMON: enabling cache recovery
Tue Aug 12 10:46:28 2014
Successfully onlined Undo Tablespace 1.
Tue Aug 12 10:46:28 2014
SMON: enabling tx recovery
Tue Aug 12 10:46:28 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2696
Tue Aug 12 10:46:34 2014
Completed: alter database open
Tue Aug 12 10:46:36 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Tue Aug 12 15:04:58 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:746M/1013M, Ph+PgF:2270M/2440M, VA:1945M/2047M
Tue Aug 12 15:04:58 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=588
PSP0 started with pid=3, OS id=1492
MMAN started with pid=4, OS id=616
DBW0 started with pid=5, OS id=1108
LGWR started with pid=6, OS id=1140
CKPT started with pid=7, OS id=1204
SMON started with pid=8, OS id=1232
RECO started with pid=9, OS id=1528
CJQ0 started with pid=10, OS id=1628
MMON started with pid=11, OS id=1840
MMNL started with pid=12, OS id=1404
Tue Aug 12 15:04:58 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Tue Aug 12 15:04:58 2014
alter database mount exclusive
Tue Aug 12 15:05:02 2014
Setting recovery target incarnation to 2
Tue Aug 12 15:05:02 2014
Successful mount of redo thread 1, with mount id 2736516570
Tue Aug 12 15:05:02 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Aug 12 15:05:02 2014
alter database open
Tue Aug 12 15:05:02 2014
Beginning crash recovery of 1 threads
Tue Aug 12 15:05:02 2014
Started redo scan
Tue Aug 12 15:05:02 2014
Completed redo scan
100 redo blocks read, 48 data blocks need recovery
Tue Aug 12 15:05:02 2014
Started redo application at
Thread 1: logseq 8, block 3
Tue Aug 12 15:05:03 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Tue Aug 12 15:05:03 2014
Completed redo application
Tue Aug 12 15:05:03 2014
Completed crash recovery at
Thread 1: logseq 8, block 103, scn 356204
48 data blocks read, 48 data blocks written, 100 redo blocks read
Tue Aug 12 15:05:04 2014
Thread 1 advanced to log sequence 9
Thread 1 opened at log sequence 9
Current log# 2 seq# 9 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Tue Aug 12 15:05:04 2014
SMON: enabling cache recovery
Tue Aug 12 15:05:06 2014
Successfully onlined Undo Tablespace 1.
Tue Aug 12 15:05:06 2014
SMON: enabling tx recovery
Tue Aug 12 15:05:07 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1592
Tue Aug 12 15:05:10 2014
Completed: alter database open
Tue Aug 12 15:05:11 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Aug 12 15:24:57 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Wed Aug 13 15:09:23 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:743M/1013M, Ph+PgF:2266M/2440M, VA:1945M/2047M
Wed Aug 13 15:09:23 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=1164
PSP0 started with pid=3, OS id=1088
MMAN started with pid=4, OS id=1224
DBW0 started with pid=5, OS id=1380
LGWR started with pid=6, OS id=1356
CKPT started with pid=7, OS id=1528
SMON started with pid=8, OS id=1616
RECO started with pid=9, OS id=1900
CJQ0 started with pid=10, OS id=1352
MMON started with pid=11, OS id=1560
MMNL started with pid=12, OS id=1588
Wed Aug 13 15:09:23 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Wed Aug 13 15:09:23 2014
alter database mount exclusive
Wed Aug 13 15:09:27 2014
Setting recovery target incarnation to 2
Wed Aug 13 15:09:27 2014
Successful mount of redo thread 1, with mount id 2736570211
Wed Aug 13 15:09:27 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Aug 13 15:09:27 2014
alter database open
Wed Aug 13 15:09:28 2014
Beginning crash recovery of 1 threads
Wed Aug 13 15:09:28 2014
Started redo scan
Wed Aug 13 15:09:28 2014
Completed redo scan
274 redo blocks read, 34 data blocks need recovery
Wed Aug 13 15:09:28 2014
Started redo application at
Thread 1: logseq 9, block 9085
Wed Aug 13 15:09:28 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 9 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Wed Aug 13 15:09:28 2014
Completed redo application
Wed Aug 13 15:09:28 2014
Completed crash recovery at
Thread 1: logseq 9, block 9359, scn 380441
34 data blocks read, 34 data blocks written, 274 redo blocks read
Wed Aug 13 15:09:28 2014
Thread 1 advanced to log sequence 10
Thread 1 opened at log sequence 10
Current log# 1 seq# 10 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Wed Aug 13 15:09:28 2014
SMON: enabling cache recovery
Wed Aug 13 15:09:29 2014
Successfully onlined Undo Tablespace 1.
Wed Aug 13 15:09:29 2014
SMON: enabling tx recovery
Wed Aug 13 15:09:29 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=380
Wed Aug 13 15:09:32 2014
Completed: alter database open
Wed Aug 13 15:09:32 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Aug 13 15:14:29 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Wed Aug 13 15:40:08 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:751M/1013M, Ph+PgF:2275M/2440M, VA:1945M/2047M
Wed Aug 13 15:40:08 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=536
PSP0 started with pid=3, OS id=556
MMAN started with pid=4, OS id=564
DBW0 started with pid=5, OS id=560
LGWR started with pid=6, OS id=1088
CKPT started with pid=7, OS id=1108
SMON started with pid=8, OS id=1200
RECO started with pid=9, OS id=1232
CJQ0 started with pid=10, OS id=1228
MMON started with pid=11, OS id=1212
MMNL started with pid=12, OS id=1160
Wed Aug 13 15:40:08 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Wed Aug 13 15:40:08 2014
alter database mount exclusive
Wed Aug 13 15:40:12 2014
Setting recovery target incarnation to 2
Wed Aug 13 15:40:12 2014
Successful mount of redo thread 1, with mount id 2736595352
Wed Aug 13 15:40:12 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Aug 13 15:40:12 2014
alter database open
Wed Aug 13 15:40:12 2014
Beginning crash recovery of 1 threads
Wed Aug 13 15:40:12 2014
Started redo scan
Wed Aug 13 15:40:12 2014
Completed redo scan
2158 redo blocks read, 364 data blocks need recovery
Wed Aug 13 15:40:12 2014
Started redo application at
Thread 1: logseq 10, block 3
Wed Aug 13 15:40:13 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Wed Aug 13 15:40:14 2014
Completed redo application
Wed Aug 13 15:40:14 2014
Completed crash recovery at
Thread 1: logseq 10, block 2161, scn 402000
364 data blocks read, 364 data blocks written, 2158 redo blocks read
Wed Aug 13 15:40:14 2014
Thread 1 advanced to log sequence 11
Thread 1 opened at log sequence 11
Current log# 2 seq# 11 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Wed Aug 13 15:40:14 2014
SMON: enabling cache recovery
Wed Aug 13 15:40:17 2014
Successfully onlined Undo Tablespace 1.
Wed Aug 13 15:40:17 2014
SMON: enabling tx recovery
Wed Aug 13 15:40:18 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2304
Wed Aug 13 15:40:23 2014
Completed: alter database open
Wed Aug 13 15:40:24 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Aug 13 15:40:37 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Wed Aug 13 15:42:30 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:756M/1013M, Ph+PgF:2275M/2440M, VA:1945M/2047M
Wed Aug 13 15:42:30 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=1668
PSP0 started with pid=3, OS id=1664
MMAN started with pid=4, OS id=1956
DBW0 started with pid=5, OS id=1952
LGWR started with pid=6, OS id=1736
CKPT started with pid=7, OS id=1732
SMON started with pid=8, OS id=1960
RECO started with pid=9, OS id=1976
CJQ0 started with pid=10, OS id=1988
MMON started with pid=11, OS id=1980
MMNL started with pid=12, OS id=2004
Wed Aug 13 15:42:31 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Wed Aug 13 15:42:34 2014
alter database mount exclusive
Wed Aug 13 15:42:38 2014
Setting recovery target incarnation to 2
Wed Aug 13 15:42:38 2014
Successful mount of redo thread 1, with mount id 2736582954
Wed Aug 13 15:42:38 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Aug 13 15:42:38 2014
alter database open
Wed Aug 13 15:42:38 2014
Beginning crash recovery of 1 threads
Wed Aug 13 15:42:38 2014
Started redo scan
Wed Aug 13 15:42:38 2014
Completed redo scan
118 redo blocks read, 79 data blocks need recovery
Wed Aug 13 15:42:38 2014
Started redo application at
Thread 1: logseq 11, block 3
Wed Aug 13 15:42:38 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Wed Aug 13 15:42:39 2014
Completed redo application
Wed Aug 13 15:42:39 2014
Completed crash recovery at
Thread 1: logseq 11, block 121, scn 422218
79 data blocks read, 79 data blocks written, 118 redo blocks read
Wed Aug 13 15:42:39 2014
Thread 1 advanced to log sequence 12
Thread 1 opened at log sequence 12
Current log# 1 seq# 12 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Wed Aug 13 15:42:39 2014
SMON: enabling cache recovery
Wed Aug 13 15:42:42 2014
Successfully onlined Undo Tablespace 1.
Wed Aug 13 15:42:42 2014
SMON: enabling tx recovery
Wed Aug 13 15:42:42 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2772
Wed Aug 13 15:42:48 2014
Completed: alter database open
Wed Aug 13 15:42:48 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Aug 13 15:42:54 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Wed Aug 13 15:54:46 2014
Starting ORACLE instance (normal)
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Tue Aug 19 09:20:07 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:749M/1013M, Ph+PgF:2267M/2440M, VA:1945M/2047M
Tue Aug 19 09:20:07 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 12582912
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 180355072
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=620
PSP0 started with pid=3, OS id=420
MMAN started with pid=4, OS id=640
DBW0 started with pid=5, OS id=424
LGWR started with pid=6, OS id=932
CKPT started with pid=7, OS id=924
SMON started with pid=8, OS id=1144
RECO started with pid=9, OS id=1396
CJQ0 started with pid=10, OS id=1356
MMON started with pid=11, OS id=1600
MMNL started with pid=12, OS id=1624
Tue Aug 19 09:20:07 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Tue Aug 19 09:20:07 2014
alter database mount exclusive
Tue Aug 19 09:20:11 2014
Setting recovery target incarnation to 2
Tue Aug 19 09:20:11 2014
Successful mount of redo thread 1, with mount id 2737130887
Tue Aug 19 09:20:11 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Aug 19 09:20:11 2014
alter database open
Tue Aug 19 09:20:11 2014
Beginning crash recovery of 1 threads
Tue Aug 19 09:20:11 2014
Started redo scan
Tue Aug 19 09:20:11 2014
Completed redo scan
544 redo blocks read, 59 data blocks need recovery
Tue Aug 19 09:20:11 2014
Started redo application at
Thread 1: logseq 12, block 2523
Tue Aug 19 09:20:12 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 12 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Tue Aug 19 09:20:12 2014
Completed redo application
Tue Aug 19 09:20:12 2014
Completed crash recovery at
Thread 1: logseq 12, block 3067, scn 445267
59 data blocks read, 59 data blocks written, 544 redo blocks read
Tue Aug 19 09:20:12 2014
Thread 1 advanced to log sequence 13
Thread 1 opened at log sequence 13
Current log# 2 seq# 13 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Tue Aug 19 09:20:12 2014
SMON: enabling cache recovery
Tue Aug 19 09:20:13 2014
Successfully onlined Undo Tablespace 1.
Tue Aug 19 09:20:13 2014
SMON: enabling tx recovery
Tue Aug 19 09:20:13 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2144
Tue Aug 19 09:20:15 2014
Completed: alter database open
Tue Aug 19 09:20:16 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Wed Aug 20 09:33:24 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:743M/1013M, Ph+PgF:2263M/2440M, VA:1945M/2047M
Wed Aug 20 09:33:24 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 12582912
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 180355072
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=640
PSP0 started with pid=3, OS id=656
MMAN started with pid=4, OS id=1012
DBW0 started with pid=5, OS id=1376
LGWR started with pid=6, OS id=1408
CKPT started with pid=7, OS id=1552
SMON started with pid=8, OS id=1468
RECO started with pid=9, OS id=1428
CJQ0 started with pid=10, OS id=1360
MMON started with pid=11, OS id=1528
MMNL started with pid=12, OS id=1608
Wed Aug 20 09:33:24 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Wed Aug 20 09:33:24 2014
alter database mount exclusive
Wed Aug 20 09:33:28 2014
Setting recovery target incarnation to 2
Wed Aug 20 09:33:28 2014
Successful mount of redo thread 1, with mount id 2737154340
Wed Aug 20 09:33:28 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Aug 20 09:33:28 2014
alter database open
Wed Aug 20 09:33:28 2014
Beginning crash recovery of 1 threads
Wed Aug 20 09:33:28 2014
Started redo scan
Wed Aug 20 09:33:28 2014
Completed redo scan
1288 redo blocks read, 259 data blocks need recovery
Wed Aug 20 09:33:28 2014
Started redo application at
Thread 1: logseq 13, block 4397
Wed Aug 20 09:33:29 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 13 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Wed Aug 20 09:33:29 2014
Completed redo application
Wed Aug 20 09:33:29 2014
Completed crash recovery at
Thread 1: logseq 13, block 5685, scn 468299
259 data blocks read, 259 data blocks written, 1288 redo blocks read
Wed Aug 20 09:33:29 2014
Thread 1 advanced to log sequence 14
Thread 1 opened at log sequence 14
Current log# 1 seq# 14 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Wed Aug 20 09:33:29 2014
SMON: enabling cache recovery
Wed Aug 20 09:33:30 2014
Successfully onlined Undo Tablespace 1.
Wed Aug 20 09:33:30 2014
SMON: enabling tx recovery
Wed Aug 20 09:33:31 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2128
Wed Aug 20 09:33:33 2014
Completed: alter database open
Wed Aug 20 09:33:33 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Wed Aug 20 10:16:20 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:749M/1013M, Ph+PgF:2271M/2440M, VA:1945M/2047M
Wed Aug 20 10:16:20 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 12582912
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 180355072
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=616
PSP0 started with pid=3, OS id=620
MMAN started with pid=4, OS id=624
DBW0 started with pid=5, OS id=628
LGWR started with pid=6, OS id=992
CKPT started with pid=7, OS id=1180
SMON started with pid=8, OS id=1352
RECO started with pid=9, OS id=1380
CJQ0 started with pid=10, OS id=1496
MMON started with pid=11, OS id=1524
MMNL started with pid=12, OS id=1620
Wed Aug 20 10:16:21 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Wed Aug 20 10:16:21 2014
alter database mount exclusive
Wed Aug 20 10:16:25 2014
Setting recovery target incarnation to 2
Wed Aug 20 10:16:25 2014
Successful mount of redo thread 1, with mount id 2737203253
Wed Aug 20 10:16:25 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Aug 20 10:16:25 2014
alter database open
Wed Aug 20 10:16:25 2014
Beginning crash recovery of 1 threads
Wed Aug 20 10:16:25 2014
Started redo scan
Wed Aug 20 10:16:25 2014
Completed redo scan
601 redo blocks read, 41 data blocks need recovery
Wed Aug 20 10:16:25 2014
Started redo application at
Thread 1: logseq 14, block 956
Wed Aug 20 10:16:25 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 14 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Wed Aug 20 10:16:26 2014
Completed redo application
Wed Aug 20 10:16:26 2014
Completed crash recovery at
Thread 1: logseq 14, block 1557, scn 489784
41 data blocks read, 41 data blocks written, 601 redo blocks read
Wed Aug 20 10:16:26 2014
Thread 1 advanced to log sequence 15
Thread 1 opened at log sequence 15
Current log# 2 seq# 15 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Wed Aug 20 10:16:26 2014
SMON: enabling cache recovery
Wed Aug 20 10:16:29 2014
Successfully onlined Undo Tablespace 1.
Wed Aug 20 10:16:29 2014
SMON: enabling tx recovery
Wed Aug 20 10:16:29 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2064
Wed Aug 20 10:16:32 2014
Completed: alter database open
Wed Aug 20 10:16:33 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Aug 20 13:36:02 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Wed Aug 20 13:49:49 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 3839K exceeds notification threshold (2048K)
KGL object name :with sqlplan as (
select c006 object_owner, c007 object_type,c008 object_name
from htmldb_collections
where COLLECTION_NAME='HTMLDB_QUERY_PLAN'
and c007 in ('TABLE','INDEX','MATERIALIZED VIEW','INDEX (UNIQUE)')),
ws_schemas as(
select schema
from wwv_flow_company_schemas
where security_group_id = :flow_security_group_id),
t as(
select s.object_owner table_owner,s.object_name table_name,
d.OBJECT_ID
from sqlplan s,sys.dba_objects d

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Wed Aug 20 15:09:23 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:747M/1013M, Ph+PgF:2269M/2440M, VA:1945M/2047M
Wed Aug 20 15:09:23 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 12582912
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 180355072
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=652
PSP0 started with pid=3, OS id=424
MMAN started with pid=4, OS id=1076
DBW0 started with pid=5, OS id=1108
LGWR started with pid=6, OS id=1144
CKPT started with pid=7, OS id=1192
SMON started with pid=8, OS id=1516
RECO started with pid=9, OS id=1244
CJQ0 started with pid=10, OS id=1860
MMON started with pid=11, OS id=1604
MMNL started with pid=12, OS id=1596
Wed Aug 20 15:09:25 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Wed Aug 20 15:09:25 2014
alter database mount exclusive
Wed Aug 20 15:09:29 2014
Setting recovery target incarnation to 2
Wed Aug 20 15:09:29 2014
Successful mount of redo thread 1, with mount id 2737251813
Wed Aug 20 15:09:29 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Aug 20 15:09:29 2014
alter database open
Wed Aug 20 15:09:29 2014
Beginning crash recovery of 1 threads
Wed Aug 20 15:09:29 2014
Started redo scan
Wed Aug 20 15:09:30 2014
Completed redo scan
2970 redo blocks read, 435 data blocks need recovery
Wed Aug 20 15:09:30 2014
Started redo application at
Thread 1: logseq 15, block 7529
Wed Aug 20 15:09:30 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Wed Aug 20 15:09:31 2014
Completed redo application
Wed Aug 20 15:09:31 2014
Completed crash recovery at
Thread 1: logseq 15, block 10499, scn 518966
435 data blocks read, 435 data blocks written, 2970 redo blocks read
Wed Aug 20 15:09:32 2014
Thread 1 advanced to log sequence 16
Thread 1 opened at log sequence 16
Current log# 1 seq# 16 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Wed Aug 20 15:09:32 2014
SMON: enabling cache recovery
Wed Aug 20 15:09:34 2014
Successfully onlined Undo Tablespace 1.
Wed Aug 20 15:09:34 2014
SMON: enabling tx recovery
Wed Aug 20 15:09:34 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2212
Wed Aug 20 15:09:37 2014
Completed: alter database open
Wed Aug 20 15:09:37 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Aug 20 15:22:05 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Thu Aug 21 13:35:47 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:741M/1013M, Ph+PgF:2263M/2440M, VA:1945M/2047M
Thu Aug 21 13:35:47 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 12582912
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 180355072
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=1520
PSP0 started with pid=3, OS id=1528
MMAN started with pid=4, OS id=1544
DBW0 started with pid=5, OS id=1532
LGWR started with pid=6, OS id=1608
CKPT started with pid=7, OS id=1904
SMON started with pid=8, OS id=1652
RECO started with pid=9, OS id=1684
CJQ0 started with pid=10, OS id=1688
MMON started with pid=11, OS id=1692
MMNL started with pid=12, OS id=1700
Thu Aug 21 13:35:47 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Thu Aug 21 13:35:47 2014
alter database mount exclusive
Thu Aug 21 13:35:51 2014
Setting recovery target incarnation to 2
Thu Aug 21 13:35:51 2014
Successful mount of redo thread 1, with mount id 2737317235
Thu Aug 21 13:35:51 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Thu Aug 21 13:35:51 2014
alter database open
Thu Aug 21 13:35:51 2014
Beginning crash recovery of 1 threads
Thu Aug 21 13:35:51 2014
Started redo scan
Thu Aug 21 13:35:51 2014
Completed redo scan
1893 redo blocks read, 373 data blocks need recovery
Thu Aug 21 13:35:52 2014
Started redo application at
Thread 1: logseq 16, block 2674
Thu Aug 21 13:35:52 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 16 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Thu Aug 21 13:35:53 2014
Completed redo application
Thu Aug 21 13:35:53 2014
Completed crash recovery at
Thread 1: logseq 16, block 4567, scn 542997
373 data blocks read, 373 data blocks written, 1893 redo blocks read
Thu Aug 21 13:35:53 2014
Thread 1 advanced to log sequence 17
Thread 1 opened at log sequence 17
Current log# 2 seq# 17 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Thu Aug 21 13:35:53 2014
SMON: enabling cache recovery
Thu Aug 21 13:35:54 2014
Successfully onlined Undo Tablespace 1.
Thu Aug 21 13:35:54 2014
SMON: enabling tx recovery
Thu Aug 21 13:35:54 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2176
Thu Aug 21 13:35:57 2014
Completed: alter database open
Thu Aug 21 13:35:57 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Thu Aug 21 15:14:59 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:745M/1013M, Ph+PgF:2270M/2440M, VA:1945M/2047M
Thu Aug 21 15:14:59 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 12582912
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 180355072
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=656
PSP0 started with pid=3, OS id=432
MMAN started with pid=4, OS id=1064
DBW0 started with pid=5, OS id=1068
LGWR started with pid=6, OS id=1072
CKPT started with pid=7, OS id=1512
SMON started with pid=8, OS id=1520
RECO started with pid=9, OS id=1592
CJQ0 started with pid=10, OS id=1560
MMON started with pid=11, OS id=1600
MMNL started with pid=12, OS id=1556
Thu Aug 21 15:14:59 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Thu Aug 21 15:14:59 2014
alter database mount exclusive
Thu Aug 21 15:15:03 2014
Setting recovery target incarnation to 2
Thu Aug 21 15:15:04 2014
Successful mount of redo thread 1, with mount id 2737313203
Thu Aug 21 15:15:04 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Thu Aug 21 15:15:04 2014
alter database open
Thu Aug 21 15:15:04 2014
Beginning crash recovery of 1 threads
Thu Aug 21 15:15:04 2014
Started redo scan
Thu Aug 21 15:15:04 2014
Completed redo scan
2112 redo blocks read, 269 data blocks need recovery
Thu Aug 21 15:15:04 2014
Started redo application at
Thread 1: logseq 17, block 8108
Thu Aug 21 15:15:04 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Thu Aug 21 15:15:04 2014
Completed redo application
Thu Aug 21 15:15:04 2014
Completed crash recovery at
Thread 1: logseq 17, block 10220, scn 566427
269 data blocks read, 269 data blocks written, 2112 redo blocks read
Thu Aug 21 15:15:05 2014
Thread 1 advanced to log sequence 18
Thread 1 opened at log sequence 18
Current log# 1 seq# 18 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Thu Aug 21 15:15:06 2014
SMON: enabling cache recovery
Thu Aug 21 15:15:08 2014
Successfully onlined Undo Tablespace 1.
Thu Aug 21 15:15:08 2014
SMON: enabling tx recovery
Thu Aug 21 15:15:09 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2068
Thu Aug 21 15:15:12 2014
Completed: alter database open
Thu Aug 21 15:15:12 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Aug 21 15:23:46 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2208K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Fri Aug 22 10:21:28 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:747M/1013M, Ph+PgF:2270M/2440M, VA:1945M/2047M
Fri Aug 22 10:21:28 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 12582912
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 180355072
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=440
PSP0 started with pid=3, OS id=1068
MMAN started with pid=4, OS id=1256
DBW0 started with pid=5, OS id=1540
LGWR started with pid=6, OS id=1300
CKPT started with pid=7, OS id=1296
SMON started with pid=8, OS id=1228
RECO started with pid=9, OS id=1564
CJQ0 started with pid=10, OS id=1488
MMON started with pid=11, OS id=1332
MMNL started with pid=12, OS id=1288
Fri Aug 22 10:21:28 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri Aug 22 10:21:29 2014
alter database mount exclusive
Fri Aug 22 10:21:33 2014
Setting recovery target incarnation to 2
Fri Aug 22 10:21:33 2014
Successful mount of redo thread 1, with mount id 2737382761
Fri Aug 22 10:21:33 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Aug 22 10:21:33 2014
alter database open
Fri Aug 22 10:21:33 2014
Beginning crash recovery of 1 threads
Fri Aug 22 10:21:33 2014
Started redo scan
Fri Aug 22 10:21:33 2014
Completed redo scan
1095 redo blocks read, 311 data blocks need recovery
Fri Aug 22 10:21:33 2014
Started redo application at
Thread 1: logseq 18, block 2006
Fri Aug 22 10:21:33 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 18 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Fri Aug 22 10:21:34 2014
Completed redo application
Fri Aug 22 10:21:34 2014
Completed crash recovery at
Thread 1: logseq 18, block 3101, scn 589562
311 data blocks read, 311 data blocks written, 1095 redo blocks read
Fri Aug 22 10:21:35 2014
Thread 1 advanced to log sequence 19
Thread 1 opened at log sequence 19
Current log# 2 seq# 19 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Fri Aug 22 10:21:35 2014
SMON: enabling cache recovery
Fri Aug 22 10:21:38 2014
Successfully onlined Undo Tablespace 1.
Fri Aug 22 10:21:38 2014
SMON: enabling tx recovery
Fri Aug 22 10:21:38 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2072
Fri Aug 22 10:21:41 2014
Completed: alter database open
Fri Aug 22 10:21:42 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Aug 22 10:23:17 2014
Starting ORACLE instance (normal)
Fri Aug 22 13:14:26 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Fri Aug 22 15:04:30 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:744M/1013M, Ph+PgF:2266M/2440M, VA:1945M/2047M
Fri Aug 22 15:04:30 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 12582912
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 180355072
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=1096
PSP0 started with pid=3, OS id=1100
MMAN started with pid=4, OS id=1192
DBW0 started with pid=5, OS id=1200
LGWR started with pid=6, OS id=1580
CKPT started with pid=7, OS id=1628
SMON started with pid=8, OS id=1772
RECO started with pid=9, OS id=1732
CJQ0 started with pid=10, OS id=1784
MMON started with pid=11, OS id=1568
MMNL started with pid=12, OS id=1404
Fri Aug 22 15:04:30 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri Aug 22 15:04:30 2014
alter database mount exclusive
Fri Aug 22 15:04:34 2014
Setting recovery target incarnation to 2
Fri Aug 22 15:04:34 2014
Successful mount of redo thread 1, with mount id 2737358270
Fri Aug 22 15:04:34 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Aug 22 15:04:34 2014
alter database open
Fri Aug 22 15:04:34 2014
Beginning crash recovery of 1 threads
Fri Aug 22 15:04:34 2014
Started redo scan
Fri Aug 22 15:04:35 2014
Completed redo scan
2503 redo blocks read, 367 data blocks need recovery
Fri Aug 22 15:04:35 2014
Started redo application at
Thread 1: logseq 19, block 6966
Fri Aug 22 15:04:35 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 19 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Fri Aug 22 15:04:36 2014
Completed redo application
Fri Aug 22 15:04:36 2014
Completed crash recovery at
Thread 1: logseq 19, block 9469, scn 618144
367 data blocks read, 367 data blocks written, 2503 redo blocks read
Fri Aug 22 15:04:36 2014
Thread 1 advanced to log sequence 20
Thread 1 opened at log sequence 20
Current log# 1 seq# 20 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Fri Aug 22 15:04:36 2014
SMON: enabling cache recovery
Fri Aug 22 15:04:38 2014
Successfully onlined Undo Tablespace 1.
Fri Aug 22 15:04:38 2014
SMON: enabling tx recovery
Fri Aug 22 15:04:39 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2288
Fri Aug 22 15:04:45 2014
Completed: alter database open
Fri Aug 22 15:04:46 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Aug 22 15:17:51 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Fri Aug 22 15:25:15 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 3839K exceeds notification threshold (2048K)
KGL object name :with sqlplan as (
select c006 object_owner, c007 object_type,c008 object_name
from htmldb_collections
where COLLECTION_NAME='HTMLDB_QUERY_PLAN'
and c007 in ('TABLE','INDEX','MATERIALIZED VIEW','INDEX (UNIQUE)')),
ws_schemas as(
select schema
from wwv_flow_company_schemas
where security_group_id = :flow_security_group_id),
t as(
select s.object_owner table_owner,s.object_name table_name,
d.OBJECT_ID
from sqlplan s,sys.dba_objects d

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Mon Aug 25 09:21:30 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:741M/1013M, Ph+PgF:2260M/2440M, VA:1945M/2047M
Mon Aug 25 09:21:30 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 12582912
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 180355072
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=1196
PSP0 started with pid=3, OS id=1612
MMAN started with pid=4, OS id=1616
DBW0 started with pid=5, OS id=1628
LGWR started with pid=6, OS id=1624
CKPT started with pid=7, OS id=1704
SMON started with pid=8, OS id=1912
RECO started with pid=9, OS id=1908
CJQ0 started with pid=10, OS id=1992
MMON started with pid=11, OS id=1800
MMNL started with pid=12, OS id=2056
Mon Aug 25 09:21:32 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Aug 25 09:21:32 2014
alter database mount exclusive
Mon Aug 25 09:21:36 2014
Setting recovery target incarnation to 2
Mon Aug 25 09:21:36 2014
Successful mount of redo thread 1, with mount id 2737675996
Mon Aug 25 09:21:36 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Aug 25 09:21:36 2014
alter database open
Mon Aug 25 09:21:36 2014
Beginning crash recovery of 1 threads
Mon Aug 25 09:21:36 2014
Started redo scan
Mon Aug 25 09:21:36 2014
Completed redo scan
1687 redo blocks read, 306 data blocks need recovery
Mon Aug 25 09:21:36 2014
Started redo application at
Thread 1: logseq 20, block 3025
Mon Aug 25 09:21:37 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 20 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Mon Aug 25 09:21:38 2014
Completed redo application
Mon Aug 25 09:21:38 2014
Completed crash recovery at
Thread 1: logseq 20, block 4712, scn 641599
306 data blocks read, 306 data blocks written, 1687 redo blocks read
Mon Aug 25 09:21:38 2014
Thread 1 advanced to log sequence 21
Thread 1 opened at log sequence 21
Current log# 2 seq# 21 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Mon Aug 25 09:21:38 2014
SMON: enabling cache recovery
Mon Aug 25 09:21:39 2014
Successfully onlined Undo Tablespace 1.
Mon Aug 25 09:21:39 2014
SMON: enabling tx recovery
Mon Aug 25 09:21:39 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2300
Mon Aug 25 09:21:41 2014
Completed: alter database open
Mon Aug 25 09:21:42 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Aug 25 10:36:51 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2208K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Mon Aug 25 13:02:51 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:746M/1013M, Ph+PgF:2272M/2440M, VA:1945M/2047M
Mon Aug 25 13:02:51 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=624
PSP0 started with pid=3, OS id=680
MMAN started with pid=4, OS id=676
DBW0 started with pid=5, OS id=428
LGWR started with pid=6, OS id=1148
CKPT started with pid=7, OS id=832
SMON started with pid=8, OS id=1544
RECO started with pid=9, OS id=1576
CJQ0 started with pid=10, OS id=1580
MMON started with pid=11, OS id=1584
MMNL started with pid=12, OS id=1588
Mon Aug 25 13:02:51 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Aug 25 13:02:51 2014
alter database mount exclusive
Mon Aug 25 13:02:56 2014
Setting recovery target incarnation to 2
Mon Aug 25 13:02:56 2014
Successful mount of redo thread 1, with mount id 2737638075
Mon Aug 25 13:02:56 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Aug 25 13:02:56 2014
alter database open
Mon Aug 25 13:02:56 2014
Beginning crash recovery of 1 threads
Mon Aug 25 13:02:56 2014
Started redo scan
Mon Aug 25 13:02:56 2014
Completed redo scan
3283 redo blocks read, 471 data blocks need recovery
Mon Aug 25 13:02:56 2014
Started redo application at
Thread 1: logseq 21, block 2077
Mon Aug 25 13:02:57 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 21 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Mon Aug 25 13:02:57 2014
Completed redo application
Mon Aug 25 13:02:58 2014
Completed crash recovery at
Thread 1: logseq 21, block 5360, scn 665257
471 data blocks read, 471 data blocks written, 3283 redo blocks read
Mon Aug 25 13:02:59 2014
Thread 1 advanced to log sequence 22
Thread 1 opened at log sequence 22
Current log# 1 seq# 22 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Mon Aug 25 13:02:59 2014
SMON: enabling cache recovery
Mon Aug 25 13:03:02 2014
Successfully onlined Undo Tablespace 1.
Mon Aug 25 13:03:02 2014
SMON: enabling tx recovery
Mon Aug 25 13:03:02 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1756
Mon Aug 25 13:03:06 2014
Completed: alter database open
Mon Aug 25 13:03:06 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Aug 25 13:09:51 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2208K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Mon Aug 25 15:28:36 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:745M/1013M, Ph+PgF:2269M/2440M, VA:1945M/2047M
Mon Aug 25 15:28:36 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=644
PSP0 started with pid=3, OS id=604
MMAN started with pid=4, OS id=680
DBW0 started with pid=5, OS id=676
LGWR started with pid=6, OS id=704
CKPT started with pid=7, OS id=1084
SMON started with pid=8, OS id=1500
RECO started with pid=9, OS id=1284
CJQ0 started with pid=10, OS id=1220
MMON started with pid=11, OS id=1560
MMNL started with pid=12, OS id=1568
Mon Aug 25 15:28:37 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Aug 25 15:28:37 2014
alter database mount exclusive
Mon Aug 25 15:28:41 2014
Setting recovery target incarnation to 2
Mon Aug 25 15:28:41 2014
Successful mount of redo thread 1, with mount id 2737614053
Mon Aug 25 15:28:41 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Aug 25 15:28:41 2014
alter database open
Mon Aug 25 15:28:41 2014
Beginning crash recovery of 1 threads
Mon Aug 25 15:28:41 2014
Started redo scan
Mon Aug 25 15:28:41 2014
Completed redo scan
3176 redo blocks read, 318 data blocks need recovery
Mon Aug 25 15:28:41 2014
Started redo application at
Thread 1: logseq 22, block 3018
Mon Aug 25 15:28:42 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 22 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Mon Aug 25 15:28:42 2014
Completed redo application
Mon Aug 25 15:28:42 2014
Completed crash recovery at
Thread 1: logseq 22, block 6194, scn 690381
318 data blocks read, 318 data blocks written, 3176 redo blocks read
Mon Aug 25 15:28:43 2014
Thread 1 advanced to log sequence 23
Thread 1 opened at log sequence 23
Current log# 2 seq# 23 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Mon Aug 25 15:28:43 2014
SMON: enabling cache recovery
Mon Aug 25 15:28:46 2014
Successfully onlined Undo Tablespace 1.
Mon Aug 25 15:28:46 2014
SMON: enabling tx recovery
Mon Aug 25 15:28:46 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2052
Mon Aug 25 15:28:50 2014
Completed: alter database open
Mon Aug 25 15:28:51 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Tue Aug 26 09:19:55 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:741M/1013M, Ph+PgF:2266M/2440M, VA:1945M/2047M
Tue Aug 26 09:19:55 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=624
PSP0 started with pid=3, OS id=640
MMAN started with pid=4, OS id=680
DBW0 started with pid=5, OS id=1068
LGWR started with pid=6, OS id=1188
CKPT started with pid=7, OS id=1220
SMON started with pid=8, OS id=1472
RECO started with pid=9, OS id=1424
CJQ0 started with pid=10, OS id=1288
MMON started with pid=11, OS id=1248
MMNL started with pid=12, OS id=1372
Tue Aug 26 09:19:56 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Tue Aug 26 09:19:56 2014
alter database mount exclusive
Tue Aug 26 09:20:00 2014
Setting recovery target incarnation to 2
Tue Aug 26 09:20:00 2014
Successful mount of redo thread 1, with mount id 2737707516
Tue Aug 26 09:20:00 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Aug 26 09:20:00 2014
alter database open
Tue Aug 26 09:20:00 2014
Beginning crash recovery of 1 threads
Tue Aug 26 09:20:00 2014
Started redo scan
Tue Aug 26 09:20:00 2014
Completed redo scan
253 redo blocks read, 37 data blocks need recovery
Tue Aug 26 09:20:00 2014
Started redo application at
Thread 1: logseq 23, block 2683
Tue Aug 26 09:20:00 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 23 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Tue Aug 26 09:20:00 2014
Completed redo application
Tue Aug 26 09:20:00 2014
Completed crash recovery at
Thread 1: logseq 23, block 2936, scn 713162
37 data blocks read, 37 data blocks written, 253 redo blocks read
Tue Aug 26 09:20:01 2014
Thread 1 advanced to log sequence 24
Thread 1 opened at log sequence 24
Current log# 1 seq# 24 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Tue Aug 26 09:20:02 2014
SMON: enabling cache recovery
Tue Aug 26 09:20:04 2014
Successfully onlined Undo Tablespace 1.
Tue Aug 26 09:20:04 2014
SMON: enabling tx recovery
Tue Aug 26 09:20:04 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1836
Tue Aug 26 09:20:08 2014
Completed: alter database open
Tue Aug 26 09:20:08 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Aug 26 10:24:53 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Tue Aug 26 15:11:00 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:741M/1013M, Ph+PgF:2266M/2440M, VA:1945M/2047M
Tue Aug 26 15:11:00 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=420
PSP0 started with pid=3, OS id=980
MMAN started with pid=4, OS id=1108
DBW0 started with pid=5, OS id=1200
LGWR started with pid=6, OS id=1220
CKPT started with pid=7, OS id=1420
SMON started with pid=8, OS id=1424
RECO started with pid=9, OS id=1472
CJQ0 started with pid=10, OS id=1468
MMON started with pid=11, OS id=1384
MMNL started with pid=12, OS id=1332
Tue Aug 26 15:11:00 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Tue Aug 26 15:11:00 2014
alter database mount exclusive
Tue Aug 26 15:11:04 2014
Setting recovery target incarnation to 2
Tue Aug 26 15:11:04 2014
Successful mount of redo thread 1, with mount id 2737792836
Tue Aug 26 15:11:04 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Aug 26 15:11:04 2014
alter database open
Tue Aug 26 15:11:04 2014
Beginning crash recovery of 1 threads
Tue Aug 26 15:11:04 2014
Started redo scan
Tue Aug 26 15:11:04 2014
Completed redo scan
1811 redo blocks read, 289 data blocks need recovery
Tue Aug 26 15:11:04 2014
Started redo application at
Thread 1: logseq 24, block 1554
Tue Aug 26 15:11:05 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 24 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Tue Aug 26 15:11:05 2014
Completed redo application
Tue Aug 26 15:11:05 2014
Completed crash recovery at
Thread 1: logseq 24, block 3365, scn 736297
289 data blocks read, 289 data blocks written, 1811 redo blocks read
Tue Aug 26 15:11:06 2014
Thread 1 advanced to log sequence 25
Thread 1 opened at log sequence 25
Current log# 2 seq# 25 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Tue Aug 26 15:11:06 2014
SMON: enabling cache recovery
Tue Aug 26 15:11:09 2014
Successfully onlined Undo Tablespace 1.
Tue Aug 26 15:11:09 2014
SMON: enabling tx recovery
Tue Aug 26 15:11:09 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1336
Tue Aug 26 15:11:13 2014
Completed: alter database open
Tue Aug 26 15:11:14 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Wed Aug 27 09:27:02 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:744M/1013M, Ph+PgF:2268M/2440M, VA:1945M/2047M
Wed Aug 27 09:27:02 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=596
PSP0 started with pid=3, OS id=684
MMAN started with pid=4, OS id=432
DBW0 started with pid=5, OS id=696
LGWR started with pid=6, OS id=1092
CKPT started with pid=7, OS id=1136
SMON started with pid=8, OS id=1172
RECO started with pid=9, OS id=1208
CJQ0 started with pid=10, OS id=1248
MMON started with pid=11, OS id=1252
MMNL started with pid=12, OS id=1196
Wed Aug 27 09:27:03 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Wed Aug 27 09:27:03 2014
alter database mount exclusive
Wed Aug 27 09:27:07 2014
Setting recovery target incarnation to 2
Wed Aug 27 09:27:07 2014
Successful mount of redo thread 1, with mount id 2737849127
Wed Aug 27 09:27:07 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Aug 27 09:27:07 2014
alter database open
Wed Aug 27 09:27:07 2014
Beginning crash recovery of 1 threads
Wed Aug 27 09:27:07 2014
Started redo scan
Wed Aug 27 09:27:07 2014
Completed redo scan
1235 redo blocks read, 219 data blocks need recovery
Wed Aug 27 09:27:07 2014
Started redo application at
Thread 1: logseq 25, block 1783
Wed Aug 27 09:27:07 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 25 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Wed Aug 27 09:27:08 2014
Completed redo application
Wed Aug 27 09:27:08 2014
Completed crash recovery at
Thread 1: logseq 25, block 3018, scn 759508
219 data blocks read, 219 data blocks written, 1235 redo blocks read
Wed Aug 27 09:27:08 2014
Thread 1 advanced to log sequence 26
Thread 1 opened at log sequence 26
Current log# 1 seq# 26 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Wed Aug 27 09:27:09 2014
SMON: enabling cache recovery
Wed Aug 27 09:27:11 2014
Successfully onlined Undo Tablespace 1.
Wed Aug 27 09:27:11 2014
SMON: enabling tx recovery
Wed Aug 27 09:27:11 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1368
Wed Aug 27 09:27:16 2014
Completed: alter database open
Wed Aug 27 09:27:16 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Wed Aug 27 13:19:31 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:747M/1013M, Ph+PgF:2270M/2440M, VA:1945M/2047M
Wed Aug 27 13:19:31 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=588
PSP0 started with pid=3, OS id=680
MMAN started with pid=4, OS id=676
DBW0 started with pid=5, OS id=1076
LGWR started with pid=6, OS id=1096
CKPT started with pid=7, OS id=1100
SMON started with pid=8, OS id=1144
RECO started with pid=9, OS id=1168
CJQ0 started with pid=10, OS id=1292
MMON started with pid=11, OS id=1284
MMNL started with pid=12, OS id=1228
Wed Aug 27 13:19:32 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Wed Aug 27 13:19:32 2014
alter database mount exclusive
Wed Aug 27 13:19:36 2014
Setting recovery target incarnation to 2
Wed Aug 27 13:19:36 2014
Successful mount of redo thread 1, with mount id 2737822884
Wed Aug 27 13:19:36 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Aug 27 13:19:36 2014
alter database open
Wed Aug 27 13:19:36 2014
Beginning crash recovery of 1 threads
Wed Aug 27 13:19:36 2014
Started redo scan
Wed Aug 27 13:19:36 2014
Completed redo scan
980 redo blocks read, 230 data blocks need recovery
Wed Aug 27 13:19:36 2014
Started redo application at
Thread 1: logseq 26, block 2849
Wed Aug 27 13:19:37 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 26 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Wed Aug 27 13:19:37 2014
Completed redo application
Wed Aug 27 13:19:37 2014
Completed crash recovery at
Thread 1: logseq 26, block 3829, scn 781929
230 data blocks read, 230 data blocks written, 980 redo blocks read
Wed Aug 27 13:19:38 2014
Thread 1 advanced to log sequence 27
Thread 1 opened at log sequence 27
Current log# 2 seq# 27 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Wed Aug 27 13:19:38 2014
SMON: enabling cache recovery
Wed Aug 27 13:19:41 2014
Successfully onlined Undo Tablespace 1.
Wed Aug 27 13:19:41 2014
SMON: enabling tx recovery
Wed Aug 27 13:19:41 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1628
Wed Aug 27 13:19:45 2014
Completed: alter database open
Wed Aug 27 13:19:45 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Aug 27 13:20:02 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Wed Aug 27 15:16:05 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:744M/1013M, Ph+PgF:2270M/2440M, VA:1945M/2047M
Wed Aug 27 15:16:05 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=684
PSP0 started with pid=3, OS id=928
MMAN started with pid=4, OS id=1088
DBW0 started with pid=5, OS id=1104
LGWR started with pid=6, OS id=1108
CKPT started with pid=7, OS id=1540
SMON started with pid=8, OS id=1544
RECO started with pid=9, OS id=1612
CJQ0 started with pid=10, OS id=1636
MMON started with pid=11, OS id=1632
MMNL started with pid=12, OS id=1656
Wed Aug 27 15:16:05 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Wed Aug 27 15:16:05 2014
alter database mount exclusive
Wed Aug 27 15:16:10 2014
Setting recovery target incarnation to 2
Wed Aug 27 15:16:10 2014
Successful mount of redo thread 1, with mount id 2737808373
Wed Aug 27 15:16:10 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Aug 27 15:16:10 2014
alter database open
Wed Aug 27 15:16:10 2014
Beginning crash recovery of 1 threads
Wed Aug 27 15:16:10 2014
Started redo scan
Wed Aug 27 15:16:10 2014
Completed redo scan
1736 redo blocks read, 333 data blocks need recovery
Wed Aug 27 15:16:10 2014
Started redo application at
Thread 1: logseq 27, block 3307
Wed Aug 27 15:16:10 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 27 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Wed Aug 27 15:16:10 2014
Completed redo application
Wed Aug 27 15:16:11 2014
Completed crash recovery at
Thread 1: logseq 27, block 5043, scn 805961
333 data blocks read, 333 data blocks written, 1736 redo blocks read
Wed Aug 27 15:16:12 2014
Thread 1 advanced to log sequence 28
Thread 1 opened at log sequence 28
Current log# 1 seq# 28 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Wed Aug 27 15:16:12 2014
SMON: enabling cache recovery
Wed Aug 27 15:16:14 2014
Successfully onlined Undo Tablespace 1.
Wed Aug 27 15:16:14 2014
SMON: enabling tx recovery
Wed Aug 27 15:16:15 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2080
Wed Aug 27 15:16:19 2014
Completed: alter database open
Wed Aug 27 15:16:19 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Aug 27 15:16:49 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Thu Aug 28 09:36:23 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:743M/1013M, Ph+PgF:2267M/2440M, VA:1945M/2047M
Thu Aug 28 09:36:23 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=432
PSP0 started with pid=3, OS id=436
MMAN started with pid=4, OS id=440
DBW0 started with pid=5, OS id=444
LGWR started with pid=6, OS id=448
CKPT started with pid=7, OS id=456
SMON started with pid=8, OS id=460
RECO started with pid=9, OS id=464
CJQ0 started with pid=10, OS id=468
MMON started with pid=11, OS id=472
MMNL started with pid=12, OS id=476
Thu Aug 28 09:36:23 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Thu Aug 28 09:36:23 2014
alter database mount exclusive
Thu Aug 28 09:36:27 2014
Setting recovery target incarnation to 2
Thu Aug 28 09:36:27 2014
Successful mount of redo thread 1, with mount id 2737936599
Thu Aug 28 09:36:27 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Thu Aug 28 09:36:27 2014
alter database open
Thu Aug 28 09:36:28 2014
Beginning crash recovery of 1 threads
Thu Aug 28 09:36:28 2014
Started redo scan
Thu Aug 28 09:36:28 2014
Completed redo scan
1923 redo blocks read, 273 data blocks need recovery
Thu Aug 28 09:36:28 2014
Started redo application at
Thread 1: logseq 28, block 3081
Thu Aug 28 09:36:28 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 28 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Thu Aug 28 09:36:29 2014
Completed redo application
Thu Aug 28 09:36:29 2014
Completed crash recovery at
Thread 1: logseq 28, block 5004, scn 829769
273 data blocks read, 273 data blocks written, 1923 redo blocks read
Thu Aug 28 09:36:29 2014
Thread 1 advanced to log sequence 29
Thread 1 opened at log sequence 29
Current log# 2 seq# 29 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Thu Aug 28 09:36:29 2014
SMON: enabling cache recovery
Thu Aug 28 09:36:30 2014
Successfully onlined Undo Tablespace 1.
Thu Aug 28 09:36:30 2014
SMON: enabling tx recovery
Thu Aug 28 09:36:30 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2220
Thu Aug 28 09:36:35 2014
Completed: alter database open
Thu Aug 28 09:36:35 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Thu Aug 28 09:41:36 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:743M/1013M, Ph+PgF:2268M/2440M, VA:1945M/2047M
Thu Aug 28 09:41:36 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=1144
PSP0 started with pid=3, OS id=1388
MMAN started with pid=4, OS id=1420
DBW0 started with pid=5, OS id=1628
LGWR started with pid=6, OS id=1672
CKPT started with pid=7, OS id=1652
SMON started with pid=8, OS id=1532
RECO started with pid=9, OS id=1856
CJQ0 started with pid=10, OS id=1588
MMON started with pid=11, OS id=1768
MMNL started with pid=12, OS id=1764
Thu Aug 28 09:41:37 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Thu Aug 28 09:41:37 2014
alter database mount exclusive
Thu Aug 28 09:41:41 2014
Setting recovery target incarnation to 2
Thu Aug 28 09:41:41 2014
Successful mount of redo thread 1, with mount id 2737929489
Thu Aug 28 09:41:41 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Thu Aug 28 09:41:41 2014
alter database open
Thu Aug 28 09:41:41 2014
Beginning crash recovery of 1 threads
Thu Aug 28 09:41:41 2014
Started redo scan
Thu Aug 28 09:41:41 2014
Completed redo scan
150 redo blocks read, 67 data blocks need recovery
Thu Aug 28 09:41:41 2014
Started redo application at
Thread 1: logseq 29, block 3
Thu Aug 28 09:41:41 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 29 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Thu Aug 28 09:41:42 2014
Completed redo application
Thu Aug 28 09:41:42 2014
Completed crash recovery at
Thread 1: logseq 29, block 153, scn 849944
67 data blocks read, 67 data blocks written, 150 redo blocks read
Thu Aug 28 09:41:42 2014
Thread 1 advanced to log sequence 30
Thread 1 opened at log sequence 30
Current log# 1 seq# 30 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Thu Aug 28 09:41:42 2014
SMON: enabling cache recovery
Thu Aug 28 09:41:45 2014
Successfully onlined Undo Tablespace 1.
Thu Aug 28 09:41:45 2014
SMON: enabling tx recovery
Thu Aug 28 09:41:46 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2144
Thu Aug 28 09:41:50 2014
Completed: alter database open
Thu Aug 28 09:41:50 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Aug 28 13:04:41 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Thu Aug 28 14:03:10 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 3839K exceeds notification threshold (2048K)
KGL object name :with sqlplan as (
select c006 object_owner, c007 object_type,c008 object_name
from htmldb_collections
where COLLECTION_NAME='HTMLDB_QUERY_PLAN'
and c007 in ('TABLE','INDEX','MATERIALIZED VIEW','INDEX (UNIQUE)')),
ws_schemas as(
select schema
from wwv_flow_company_schemas
where security_group_id = :flow_security_group_id),
t as(
select s.object_owner table_owner,s.object_name table_name,
d.OBJECT_ID
from sqlplan s,sys.dba_objects d

Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Fri Aug 29 10:20:56 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:754M/1013M, Ph+PgF:2275M/2440M, VA:1945M/2047M
Fri Aug 29 10:20:56 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=1984
PSP0 started with pid=3, OS id=1988
MMAN started with pid=4, OS id=1992
DBW0 started with pid=5, OS id=2020
LGWR started with pid=6, OS id=2008
CKPT started with pid=7, OS id=2004
SMON started with pid=8, OS id=2040
RECO started with pid=9, OS id=1812
CJQ0 started with pid=10, OS id=128
MMON started with pid=11, OS id=152
MMNL started with pid=12, OS id=168
Fri Aug 29 10:20:56 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri Aug 29 10:20:56 2014
alter database mount exclusive
Fri Aug 29 10:21:00 2014
Setting recovery target incarnation to 2
Fri Aug 29 10:21:01 2014
Successful mount of redo thread 1, with mount id 2737955016
Fri Aug 29 10:21:01 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Aug 29 10:21:01 2014
alter database open
Fri Aug 29 10:21:01 2014
Beginning crash recovery of 1 threads
Fri Aug 29 10:21:01 2014
Started redo scan
Fri Aug 29 10:21:01 2014
Completed redo scan
3147 redo blocks read, 372 data blocks need recovery
Fri Aug 29 10:21:01 2014
Started redo application at
Thread 1: logseq 30, block 8962
Fri Aug 29 10:21:02 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 30 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Fri Aug 29 10:21:02 2014
Completed redo application
Fri Aug 29 10:21:02 2014
Completed crash recovery at
Thread 1: logseq 30, block 12109, scn 879603
372 data blocks read, 372 data blocks written, 3147 redo blocks read
Fri Aug 29 10:21:04 2014
Thread 1 advanced to log sequence 31
Thread 1 opened at log sequence 31
Current log# 2 seq# 31 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Successful open of redo thread 1
Fri Aug 29 10:21:04 2014
SMON: enabling cache recovery
Fri Aug 29 10:21:06 2014
Successfully onlined Undo Tablespace 1.
Fri Aug 29 10:21:06 2014
SMON: enabling tx recovery
Fri Aug 29 10:21:06 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2056
Fri Aug 29 10:21:09 2014
Completed: alter database open
Fri Aug 29 10:21:09 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file c:oraclexeapporacleadminxebdumpalert_xe.log
Fri Aug 29 13:03:09 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:754M/1013M, Ph+PgF:2276M/2440M, VA:1945M/2047M
Fri Aug 29 13:03:09 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 83886080
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 285212672
control_files = C:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_recovery_file_dest = C:oraclexeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = C:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = C:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = C:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=1620
PSP0 started with pid=3, OS id=1432
MMAN started with pid=4, OS id=1396
DBW0 started with pid=5, OS id=1360
LGWR started with pid=6, OS id=1356
CKPT started with pid=7, OS id=1352
SMON started with pid=8, OS id=1896
RECO started with pid=9, OS id=1900
CJQ0 started with pid=10, OS id=412
MMON started with pid=11, OS id=1904
MMNL started with pid=12, OS id=1908
Fri Aug 29 13:03:09 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri Aug 29 13:03:09 2014
alter database mount exclusive
Fri Aug 29 13:03:13 2014
Setting recovery target incarnation to 2
Fri Aug 29 13:03:13 2014
Successful mount of redo thread 1, with mount id 2737968589
Fri Aug 29 13:03:13 2014
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Aug 29 13:03:14 2014
alter database open
Fri Aug 29 13:03:14 2014
Beginning crash recovery of 1 threads
Fri Aug 29 13:03:14 2014
Started redo scan
Fri Aug 29 13:03:14 2014
Completed redo scan
1382 redo blocks read, 269 data blocks need recovery
Fri Aug 29 13:03:14 2014
Started redo application at
Thread 1: logseq 31, block 10091
Fri Aug 29 13:03:14 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 31 Reading mem 0
Mem# 0 errs 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_9Y9DGBKL_.LOG
Fri Aug 29 13:03:14 2014
Completed redo application
Fri Aug 29 13:03:15 2014
Completed crash recovery at
Thread 1: logseq 31, block 11473, scn 903810
269 data blocks read, 269 data blocks written, 1382 redo blocks read
Fri Aug 29 13:03:15 2014
Thread 1 advanced to log sequence 32
Thread 1 opened at log sequence 32
Current log# 1 seq# 32 mem# 0: C:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_9Y9DG9XS_.LOG
Successful open of redo thread 1
Fri Aug 29 13:03:15 2014
SMON: enabling cache recovery
Fri Aug 29 13:03:16 2014
Successfully onlined Undo Tablespace 1.
Fri Aug 29 13:03:16 2014
SMON: enabling tx recovery
Fri Aug 29 13:03:16 2014
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1816
Fri Aug 29 13:03:21 2014
Completed: alter database open
Fri Aug 29 13:03:21 2014
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Aug 29 13:25:04 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2208K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==