DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: OCP Question

  1. #1
    Join Date
    Mar 2001
    Posts
    188

    Question

    Hello Friends,
    i will make the ocp. I have a question which i cant answer. Can anyone tell me the answer + a description of the answer (Why).

    The question is:

    32 Employees, every employee has an active transaction. The enviroment is a typicall OLTP enviroment.
    How much rollbach segments do you need.

    Answers are:

    16 ( )
    8 ( )
    4 ( )
    for every transaction ( )
    for every User ( )

    Thanks for help

    So long
    Thomas Schmidt
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Oracle recommends 1 RBS per 4 concurrent transactions , so the answer is

    32/4 = 8 RBS.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by dknight
    Oracle recommends 1 RBS per 4 concurrent transactions , so the answer is

    32/4 = 8 RBS.
    1 RBS per 4 CTs in Oracle 8/8i. The recommendations are a bit different for lower versions.


  4. #4
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    well..active transactions doesn't mean CONCURRENT transaction does it?
    so what u recommending are ASSUMED answer...
    ngwh,
    Singapore.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width