MMAN – memory broker statistics
Some background on memory broker: The Automatic Shared Memory Management feature uses background process named Memory Manager (MMAN).MMAN serves as the SGA Memory Broker and coordinates the sizing of the memory components. The SGA Memory Broker keeps track of the sizes of the components and pending resize operations.There is not so many document on this … Read more
Sqlplus command line history.
If you are running sqlplus or RMAN on Windows than you can use upper arrow to get history.What about linux? First option: 1) Install readline wrapper: yum install rlwrap 2) Change .bashrc and make alias : alias sqlplus=’rlwrap sqlplus’ alias rman=’rlwrap rman’ The other option is to install qqlplus which you can find on the link … Read more
How to dump corrupted Oracle database blocks?
Oracle blocks are uniquely identified by an absolute file number and a block number Command to dump one Oracle block alter system dump datafile <file_number> block <block_id> or to dump few blocks alter system dump datafile <file_number> block min <first_block> block max <last_block> But if blocks are corrupted this may not be possible. Solutions: 1) … Read more