MMAN – memory broker statistics

Posted by oraclue on November 19, 2008 · 1 Comment 

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

Filed under Internals

Sqlplus command line history.

Posted by oraclue on November 13, 2008 · 1 Comment 

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

Filed under Uncategorized

How to dump corrupted Oracle database blocks?

Posted by oraclue on November 6, 2008 · 2 Comments 

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

Filed under Internals