Orace DB

Moved from Documents section to Discussion area

*******************************************************************************

The following is a detailed Report generated, while executing a Procedure through sqlplus.

Kindly recommend a solution. 

DETAILED ADDM REPORT FOR TASK 'TASK_7409' WITH ID 7409
  
Analysis Period: 21-APR-2010 from 14:30:38 to 16:30:30
  
Database ID/Instance: 3752571471/1
 
Database/Instance Names: BISE3DB/bise3db
                    Host Name: BI
             Database Version: 10.2.0.1.0
               Snapshot Range: from 4822 to 4824
                Database Time: 4930 seconds
        Average Database Load: .7 active sessions

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

FINDING 1: 100% impact (4930 seconds)
-------------------------------------
Significant virtual memory paging was detected on the host operating system.

RECOMMENDATION 1: Host Configuration, 100% benefit (4930 seconds)
      ACTION: Host operating system was experiencing significant paging but no
         particular root cause could be detected. Investigate processes that