DBWR
------
checkpoint
dirty buffer reach threshold
no free buffers
timeout
drop table
truncate table
LGWR
--------
commit
more than 1MB
1/3rd full
before DBWR
every 3 seconds
skip to main |
skip to sidebar
Blog Archive
-
▼
2008
(33)
-
▼
July
(33)
- loading objects into shared pool
- sga components used,free
- log sequence number
- statspack
- sql_trace
- schedules
- job scripts
- flashback scripts
- PARALLELISM rman
- Block number of the row
- recovery question
- blocks that reside in the buffer_cache
- Hit Ratios
- archivelog destination
- DBWR and LGWR
- database buffer cache, library cache
- changing global_name
- append and parallel hints, nologging
- snapshot too old
- enterprise manager
- shrink_me
- number of rows per block
- shrink,alter table move,deallocate unused
- corrupt blocks
- droping all user_objects
- redo scripts
- rman scripts
- tablespace usage
- temp tablespace scripts
- undo_retention
- Some useful unix commands
- Changing username
- Rman scenerios
-
▼
July
(33)
No comments:
Post a Comment