[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_60

Title:	Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:	RDB_60 is archived, please use RDB_70..
Moderator:	NOVA::SMITHISON

Created:	Fri Mar 18 1994
Last Modified:	Fri May 30 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	5118
Total number of notes:	28246

5018.0. "RBs decrease in # then increase?" by M5::LWILCOX (Chocolate in January!!) Tue Feb 11 1997 10:31

Maybe I need more coffee (or less...) or I'm just forgetting something real
basic here.

I had a customer RMU/CLOSE/CLUSTER/ABORT=DELPRC/WAIT on a db that seemed to
be "hung".  As expected, RB processes started up, about 150 of them.  They
seemed to take longer than expected, so I had him SHOW PROC/CONT/ID on a
few to be sure something was happenning.  They were getting CPU and I/O.
Another SHOW SYSTEM would show various of the RB processes in RWSCS and
others of them in PFW.  It would also show fewer and fewer RBs, and even
got down to just 1, but then the next SHOW SYSTEM would show 140 or so
again.  I don't recall seeing the number of RBs go down then shoot back
up again.  This is the part that puzzles me.  Is this "usual" and I just
haven't seen it?  This went on for about a half hour with RBs decreasing
then increasing in number.  Then they all finished.

Thanks.

Liz

T.R	Title	User	Personal Name	Date	Lines
5018.1		DUCATI::LASTOVICA	Is it possible to be totally partial?	`Tue Feb 11 1997 10:45`	2
	I imagine that the monitor log file will indicate what was going on. Do they use the logical name to control the number of DBRs that run?
5018.2		M5::LWILCOX	Chocolate in January!!	`Fri Feb 14 1997 10:09`	12
	<<< Note 5018.1 by DUCATI::LASTOVICA "Is it possible to be totally partial?" >>> >>I imagine that the monitor log file will indicate what was going on. >>Do they use the logical name to control the number of DBRs that run? Ah, good thought. Let's say it was set to 20, would the first 20 DBRs finish before the next 20 start, or does a new one start as each one finishes? Thanks. Liz
5018.3	Monitor waits until ALL active DBRs have finished	NOVA::R_ANDERSON	Oracle Corporation (603) 881-1935	`Sat Feb 15 1997 08:02`	5
	If you specified a max DBR count of "20" then the monitor will start 20 DBRs at once and wait for them ALL to finish before starting the NEXT batch of 20 DBRs. Rick
5018.4		svrav1.au.oracle.com::MBRADLEY	I was dropped on my head as a baby. What's your excuse?	`Sun Feb 16 1997 20:17`	1
	Also, if Global buffers are enabled you only get one DBR at a time.
5018.5		M5::LWILCOX	Chocolate in January!!	`Mon Feb 17 1997 16:09`	1
	Thanks, Rick, just what I needed!!