Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Shared Pool Wait while using SQL Loader

Shared Pool Wait while using SQL Loader

From: Chindarkar, Chetan (CONS FIN , Contractor) <Chetan.Chindarkar_at_gecapital.com>
Date: Tue, 08 Jul 2003 17:35:50 -0700
Message-ID: <F001.005C3EB2.20030708172924@fatcity.com>


Gurus ,

We run a Oracle 8.1.7.4.0 dw on Sun Solaris 2.8 version and its a data warehouse environment. There are lots of SQL Loader jobs which run on a day-to-day basis.

Normally it takes 15-20 mins to finish the loading but today it is taking more than an hour and nothing seems to happen. This is a range partitioned table.

Here are the results of the queries on v$ views.

       SID SEQ# EVENT

---------- ---------- ----------------------------------------------------------------
P1TEXT                                                           P2TEXT
---------------------------------------------------------------- 
----------------------------------------------------------------
P3TEXT                                                            WAIT_TIME 
SECONDS_IN_WAIT STATE
---------------------------------------------------------------- ---------- 
--------------- -------------------
         1      26767 pmon timer
duration
                                                                          0            
4750 WAITING
       113       9126 db file sequential read
file#                                                            block#
blocks                                                                   -1            

   0 WAITED SHORT TIME

        86       2404 db file scattered read
file#                                                            block#
blocks                                                                    2            

   0 WAITED KNOWN TIME

         8       7539 smon timer
sleep time                                                       failed
                                                                          0            
 232 WAITING
        70         36 SQL*Net message to client
driver id                                                        #bytes
                                                                         -1            
   0 WAITED SHORT TIMEhandle address                                                   
3830864540 E4565A9C
lock address                                                     4121106472 F5A31828
10*mode+namespace                                                        31 0000001F   
       0             677 WAITING

        70         32 SQL*Net message to client
driver id                                                        1650815232 62657100
#bytes                                                                    1 00000001
                                                                          0 00         
      -1               0 WAITED SHORT TIME


Please advise ...

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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 Tue Jul 08 2003 - 19:35:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US