RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Oracle Locks
«Prev
Next»
Tuning Oracle Instance
Instance Tuning
Main Components SGA
Oracle Library Cache
Query Dictionary Cache
Shared Pool Tuning
Shared Pool Optimal Tuning
Pin Packages Shared Pool
Pinning Memory Objects
Reserved Size
Shared Pool Reserved Size
Tuning Parameters
Identifying High Use Packages
Identify Swapped out Items
Detecting Library Cache Contention
Reduce Fragmentation
Library Cache Statistics
Reuse SQL Library Cache
Tuning Shared Pool
Data Buffer Cache
Tuning Data Buffer
Calculate buffer Hit Ratio
Full table Scan
Impact Adding Data Buffers
Predict Amount Spare Memory
Create multiple Buffer Pools
Configure Multiple Buffer Pools
Monitor Buffer Cache
Use Table Caching
Databuffer Cache Conclusion
Redo Log Tuning
log_checkpoint_interval
RedoLog Wait Statistics
size Archived RedoLog FileSystem
RedoLogs Online Size Determination
Sorting Operations
Oracle Sorting Basics
Monitoring Temp Tablespace
sort_direct_writes
Tuning Oracle Locks
Oracle Lock Modes - Exericse
Overview of Oracle lock modes
Objective:
Describe the Oracle lock modes.
Exercise scoring
For this exercise, you will need to respond to the scenario presented below using what you now know about Oracle locks. Once you have completed your answer, you will submit your answer.
Background
Your programming community has been having a problem when attempting to acquire a whole table with an exclusive lock (using the LOCK TABLE command). Their task is updating 3,000 rows in a table, and the task has been waiting too long for all shared locks to clear.
The programmers are upset because they cannot understand why the task must wait for shared locks. You have been asked to describe to your programmer community why Oracle will not allow a task to acquire an exclusive lock until all other tasks are done reading a row (with shared locks), and outline another method for achieving the goal.
Instructions
Prepare a short paragraph explaining why it is necessary for Oracle to wait until all shared locks have cleared for a row before allowing an exclusive lock to be set. It should also explain another alternative to a full table lock.
Hint
Remember the discussion about Oracle's locking scheme from the beginning of this module.
Submitting your Exercise
Enter your answer into the text box below. Click the
Submit
button to submit your answer
.
Submit