Re: Tune for 'db file sequential read'

From: <CHUCK_HAMILTON_at_qvc.com>
Date: Wed, 3 May 2000 14:50:43 -0400
Message-Id: <10486.104847@fatcity.com>

What was the wait event it spent most if it's time on?
--

Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA

                                                                                                                   
                    Deepak Sharma                                                                                  
                    <sharmakdeep@        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    yahoo.com>           cc:     (bcc: CHUCK HAMILTON/QVC)                                         
                    Ext: NA              Subject:     Tune for 'db file sequential read'                           
                    Sent by:                                                                                       
                    root_at_fatcity.                                                                                  
                    com                                                                                            
                                                                                                                   
                                                                                                                   
                    05/03/00                                                                                       
                    02:06 PM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L

On querying the v$session_event, I could see one process taking a very large wait time. The process takes about 4 Hrs to complete on *this* instance (A), whereas it takes a few minutes on another instance(B) with almost same amount of data. The Metalink pages suggest to test by increasing DB_BLOCK_BUFFERS, but the interesting thing is that instance A's SGA is 128M, whereas instance B's is 44M. Any suggestions ?

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/
--

Author: Deepak Sharma
INET: sharmakdeep_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 03 2000 - 13:50:43 CDT