Re: rollback questions

From: Vince Laurent <eAddict_at_yahoo.com>
Date: Mon, 23 Dec 2002 14:55:02 -0600
Message-ID: <7jte0v0vfhig104ti8cove5ajehj69rs0t@4ax.com>

On Sat, 21 Dec 2002 17:30:44 -0000, "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote:

>How many concurrent transactions do you have?
SQL> select * from v$resource_limit where resource_name='transactions';

RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITL_AL LIMIT_VALU

------------- ------------------- --------------- -------- ----------
transactions         2                 16            198       198

>How many concurrent active sessions?

That can vary. SAP assigns users in groups to 1 oracle process. I am not sure what exactly the number is you are looking for here too. We have so far maxed out at about 300 users on SAP at the same time. Thats is not a 1 to 1 (SAP to Oracle) ratio.

>How frequently is the database restarted?

Once a week - until we get the mirroring/backup working...

>Do you have overnight batch jobs running?
Yes. But I am unable to assign them to a specific rollback segment since the user/transaction is masked by SAP.

>What type of system is this (OLTP, DW, mixed)?

OLTP would be the best description.

Thanks for your help!
Vince Received on Mon Dec 23 2002 - 14:55:02 CST