-
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
-
Oracle recommends 1 RBS per 4 concurrent transactions , so the answer is
32/4 = 8 RBS.
David Knight
OCP DBA 8i, 9i, 10g
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|