RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Oracle Locks
«Prev
Next»
Tuning Oracle Instance
Instance Tuning
Main Components SGA
Shared Pool Tuning
Oracle Library Cache
Query Dictionary Cache
Global Area Session
Data Buffer Cache
Redo Log Buffer
Instance Tuning Conclusion
Shared Pool Tuning
Shared Pool Optimal Tuning
Pin Packages Shared Pool
Pinning Supplied Packages
Reserved Size
Identifying High Use Packages
Pinned Packages Output
IIdentify Swapped out Items
Statistics gathered from Startup
Detecting Library Cache Contention
Library Cache Statistics
Reuse SQL Library Cache
Tuning Shared Pool
Data Buffer Cache
Tuning Data Buffer
Calculate buffer Hit Ratio
Non- Full table Scan
Full table Scan
Impact Adding Data Buffers
Predict Amount Spare Memory
Create multiple Buffer Pools
Configure Multiple Buffer Pools
Size Buffer Pools
Monitor Buffer Cache
Use Table Caching
Databuffer Cache Conclusion
Redo Log Tuning
Oracle Redo Logs
Tuning Techniques
View RedoLog Activity
Redo Log Parameters
RedoLog Wait Statistics
RedoLogs Online Size Determination
size Archived RedoLog FileSystem
Tune redo Log Operations
log_checkpoint_interval
RedoLog Tuning Conclusion
Sorting Operations
Oracle Sorting Basics
Sorting Parameters
SQL Join Operations
Monitor for Disk Sorts
Sorting Direct Writes
Temporary Sorting Space
Monitoring Temp Tablespace
Remove SQL Sorts
Sorting Operations Conclusion
Tuning Oracle Locks
Oracle Lock Concepts - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which is true about database deadlocks? (Please select all that apply.)
Please select all the correct answers.
A.
Oracle deadlocks must be manually cleaned-up with the KILL SESSION command.
B.
Oracle deadlocks are detected by Oracle.
C.
Oracle deadlocks can be created by a single session.
D.
Oracle will terminate the task that creates the deadlock.
2.
Which Oracle view will allow you to see Oracle sessions that are waiting for locks to release?
Please select the best answer.
A.
The V$SYSSTAT view
B.
The DBA_WAITERS view
C.
The DBA_HOLDERS view
D.
The V$LOCK_ACTIVITY view
3.
Which locking mechanism will be invoked when an SQL UPDATE is issued?
Please select the best answer.
A.
Row share locks
B.
Row exclusive locks
C.
Table share locks
D.
Table exclusive locks
4.
You have decided to give all of your employees a five percent raise. What Oracle mechanism will result in the fewest lock resources being used?
Please select the best answer.
A.
Select all rows in the table with the FOR UPDATE clause.
B.
Issue the LOCK TABLE command before the update.
C.
Just issue the update and let Oracle handle the locks.
D.
Place the update in a PL/SQL cursor and commit after every 50 updates.