Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SMON: Parallel transaction recovery tried

203 views
Skip to first unread message

Tuhin Kumar

unread,
Mar 10, 2004, 6:11:30 AM3/10/04
to
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

srivenu

unread,
Mar 11, 2004, 12:58:40 AM3/11/04
to
You get this message if SMON failed to generate the slave servers
necessary to perform a parallel rollback of a transaction.
Check the value for the parameter, FAST_START_PARALLEL_ROLLBACK
(default is LOW). LOW limits the number of rollback processes to 2 *
CPU_COUNT.
HIGH limits the number of rollback processes to 4 * CPU_COUNT.
You may want to set the value of this parameter to FALSE.
0 new messages