Home -> Usenet -> comp.databases.oracle -> SMON: Parallel transaction recovery tried

SMON: Parallel transaction recovery tried

From: Tuhin Kumar <tkumar_at_ipolicynet.com>
Date: 9 Mar 2004 21:49:35 -0800
Message-ID: <e4ad76f5.0403092149.433a2a3e_at_posting.google.com> 






Hi,


     I got these following messages in the BDUMP file. Around these
time my process was always getting blocked while updating a table.
Does this messages mean anything critical:
Dump file d:\oracle\admin\usmdb\bdump\usmdb_smon_1564.trc
Sun Mar 07 03:17:27 2004


ORACLE V9.2.0.1.0 - Production vsnsta=0


vsnsql=12 vsnxtr=3


Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production


Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Instance name: usmdb



Redo thread mounted by this instance: 1



Oracle process number: 6



Windows thread id: 1564, image: ORACLE.EXE




    
  
  •   2004-03-07 03:17:27.000
  
  •   SESSION ID:(5.1) 2004-03-07 03:17:27.000

  
  •   2004-03-07 03:17:27.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 03:58:28.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 04:38:38.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 04:39:23.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 05:20:16.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 06:01:25.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 06:42:27.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 07:23:28.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 08:04:33.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 08:45:31.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 09:26:36.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 10:07:42.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 10:48:46.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 11:29:41.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 12:10:56.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 12:51:52.000
SMON: Parallel transaction recovery tried
  
  •   2004-03-07 13:32:55.000
SMON: Parallel transaction recovery tried






Thanks,


Tuhin
Received on Wed Mar 10 2004 - 06:49:35 CET












Original text of this message