Database Administration (MOSC)

MOSC Banner

how to set Transaction parameter in 11g

edited Apr 8, 2013 6:01AM in Database Administration (MOSC) 5 commentsAnswered
Hello Experts,

I am working on database consolidataion, like moving standalone databases to RAC environment. during the migration phase we have identified transaction parameters has different size for each source database and target db as well.

is there any best way to identified how much value we can set on target db.

Source Platform : Solaris (VCS cluster), Oracle version 10.2.0.4

Target Platform : Linux (RAC), Oracle Version 11.2.0.3

for an example.

Source DB 1 : ABC -> transaction=2340 (standalone db, dedicated to particular application ABC)

Source DB 2 : XZ -> transaction=500 (standalone db, dedicated to particular application XZ)

Source DB 3 : Y2K -> transaction=3000 (standalone db, dedicated to particular application Y2K)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center