|
|
 |
|
Oracle Tips
by Burleson Consulting
|
The Data Warehouse Development Life Cycle
Parallelism And Oracle Data Warehousing
The V$LOCK_ACTIVITY View
The V$:LOCK_ACTIVITY view is a very good way to determine if you
have reached the maximum lock convert rate for your DLM. Because the
maximum lock convert rate is unique to each vendor's DLM, you need
to compare the results from V$:LOCK_ACTIVITY with the maximum values
in your OS vendor's documentation for their DLM. Regardless, if the
maximum lock convert rate has been reached, you will need to
repartition the application to balance alike transactions into
common instances.
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
|
|
|