The parameters (p1, p2, p3) for some of the most common wait events are given below.
Thanks
Thursday, August 20, 2009
Subscribe to:
Post Comments (Atom)
My Favourite Blogs
Visits
Archive
-
▼
2009
(120)
-
▼
August
(13)
- Wait Events Parameter
- Controlfile Sequential Read/ Parallel Write
- db file parallel read/write
- Objects and Blocks in waits
- db file scattered read
- db file sequential read
- Optimizer Statistics - Views
- Restore old statistics
- Gathering System Statistics
- Sampling in Statistics Gathering
- Manual Statistics Gathering
- Automatic Statistic Gathering
- Recompile Invalid Objects
-
▼
August
(13)
Followers
Labels
- Performance Tuning
- ASM
- Hit Ratio Analysis
- Flashback Recovery
- SQL
- Wait Events
- Undo Tablespace
- 10g Features
- Errors
- Backup
- Tracing
- RAC
- Miscellaneous
- FRA
- RMAN
- Recovery
- SQL Scripts
- Temporary Tablespace
- Data Pump
- Installation
- OEM
- Parameters
- Shrink
- Utilities
- ADDM
- Architecture
- TSPITR
- Unix
- AWR
- High Availability
- Latch
- Network
- Privilege
Oracle Database Administration. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com
No comments:
Post a Comment