Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Shared Pool Wait while using SQL Loader
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_TIMESECONDS_IN_WAIT STATE
---------------------------------------------------------------- ---------- --------------- ------------------- 1 26767 pmon timer duration 04750 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 0232 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